declare
	al_button number;	
	pl_id ParamList;

begin
	pl_id := Get_Parameter_List('repPara'); --create a parameter list
	IF NOT Id_Null(pl_id) THEN 
		Destroy_Parameter_List( pl_id ); 
	END IF; 
	
	pl_id := Create_Parameter_List('repPara'); 
	Add_Parameter(pl_id, 'PARAMFORM',TEXT_PARAMETER, 'NO');
	Add_Parameter(pl_id, 'P_DO_NO',TEXT_PARAMETER, :Master_SALES.Do_Number); --passing inv_no as parameter
	Add_Parameter(pl_id, 'P_DO_DATE',TEXT_PARAMETER, :MAster_SALES.Do_DATE); --passing inv_date as parameter
	
	Run_Product(REPORTS, 'E:\Do_dcmbl Forms\REPORTS\DO_Food_Portrait', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
end;

SQL> SELECT DISTINCT vsf.MRR_NO, vsf.MRR_DATE, vsf.DO_NO, 
  2  vsf.DO_DATE, vsf.DEPO_NAME, vsf.DISTRIBUTOR_NAME, vsf.ADDRESS
  3  FROM V_DO_SALES vsf
  4  WHERE (vsf.DO_NO = :P_DO_NO
  5   AND vsf.DO_DATE = :P_DO_DATE);
Bind variable "P_DO_DATE" not declared.
SQL> /
Bind variable "P_DO_DATE" not declared.
SQL> 
SQL> 
SQL> SELECT DISTINCT vsf.PRODUCT_QUANTITY, vsf.PIECES, 
  2  vsf.PRODUCT_NAME, vsf.SL_NO, vsf.INV_RATE, vsf.SALES_AMOUNT
  3  FROM V_DO_SALES vsf
  4  WHERE (vsf.DO_NO = :P_DO_NO
  5   AND vsf.DO_DATE = :P_DO_DATE);
Bind variable "P_DO_DATE" not declared.
SQL> SELECT DISTINCT NUMTOCHAR_PACK(SUM(VSF.PRODUCT_QUANTITY)) DISPLAY_COL1, NUMTOCHAR_PIECES(SUM(VS
F.PIECES)) DISPLAY_COL2, 
  2  SUM(VSF.PIECES) DISPLAY_COL3
  3  FROM V_DO_SALES VSF
  4  WHERE (VSF.DO_DATE = :P_DO_DATE
  5   AND VSF.DO_NO = :P_DO_NO);
Bind variable "P_DO_NO" not declared.
SQL> 

SQL> SELECT DISTINCT vsf.MRR_NO, vsf.MRR_DATE, vsf.DO_NO, 
  2  vsf.DO_DATE, vsf.DEPO_NAME, vsf.DISTRIBUTOR_NAME, vsf.ADDRESS
  3  FROM V_DO_SALES vsf
  4  WHERE (vsf.DO_NO = &P_DO_NO
  5   AND vsf.DO_DATE = &P_DO_DATE); 
Enter value for p_do_no: 114
old   4: WHERE (vsf.DO_NO = &P_DO_NO
new   4: WHERE (vsf.DO_NO = 114
Enter value for p_do_date: 31-12-2008
old   5:  AND vsf.DO_DATE = &P_DO_DATE)
new   5:  AND vsf.DO_DATE = 31-12-2008)
 AND vsf.DO_DATE = 31-12-2008)
                 *
ERROR at line 5:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER