[Home] [Help]
PACKAGE: APPS.AR_ARXDIR_XMLP_PKG
Source
1 PACKAGE AR_ARXDIR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXDIRS.pls 120.0 2007/12/27 13:47:52 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_CUSTOMER_NAME_LOW varchar2(50);
5 P_CUSTOMER_NAME_HIGH varchar2(50);
6 P_ORDER_BY varchar2(50);
7 /*ADDED AS FIX*/
8 P_ORDER_BY_T VARCHAR2(50);
9 P_ITEM_NUMBER_LOW varchar2(30);
10 P_ITEM_NUMBER_HIGH varchar2(30);
11 P_SET_OF_BOOKS_ID number;
12 P_DUE_DATE_LOW date;
13 P_DUE_DATE_HIGH date;
14 P_COLLECTOR_LOW varchar2(30);
15 P_COLLECTOR_HIGH varchar2(30);
16 lp_customer_name_low varchar2(100) :=' ';
17 lp_customer_name_high varchar2(100) :=' ';
18 lp_item_number_low varchar2(100) :=' ';
19 lp_item_number_high varchar2(100) :=' ';
20 lp_due_date_low varchar2(100) :=' ';
21 lp_due_date_high varchar2(100) :=' ';
22 lp_collector_low varchar2(100) :=' ';
23 lp_collector_high varchar2(200) :=' ';
24 lp_order_by varchar2(900) :=' ';
25 -- lp_customer_name_low varchar2(100);
26 -- lp_customer_name_high varchar2(100);
27 -- lp_item_number_low varchar2(100);
28 -- lp_item_number_high varchar2(100);
29 -- lp_due_date_low varchar2(100);
30 -- lp_due_date_high varchar2(100);
31 -- lp_collector_low varchar2(100);
32 -- lp_collector_high varchar2(200);
33 -- lp_order_by varchar2(900);
34
35 P_CUSTOMER_NUMBER_LOW varchar2(30);
36 P_CUSTOMER_NUMBER_HIGH varchar2(30);
37 lp_customer_number_low varchar2(100) :=' ';
38 lp_customer_number_high varchar2(200) :=' ';
39 -- lp_customer_number_low varchar2(100);
40 -- lp_customer_number_high varchar2(200);
41
42 P_CONS_PROFILE_VALUE varchar2(10);
43 --P_CONS_PROFILE_VALUE varchar2(10) :='N';
44 --LP_QUERY_SHOW_BILL varchar2(1000);
45 LP_QUERY_SHOW_BILL varchar2(1000):='ar_payment_schedules.trx_number';
46 LP_TABLE_SHOW_BILL varchar2(1000):=' ';
47 LP_WHERE_SHOW_BILL varchar2(1000):=' ';
48 LP_STATUS varchar2(100):=' ';
49 -- LP_TABLE_SHOW_BILL varchar2(1000);
50 -- LP_WHERE_SHOW_BILL varchar2(1000);
51 -- LP_STATUS varchar2(100);
52
53 P_INVOICE_STATUS varchar2(50);
54 P_INVOICE_STATUS_PARAM varchar2(50);
55 RP_COMPANY_NAME varchar2(50);
56 RP_REPORT_NAME varchar2(80);
57 RP_DATA_FOUND varchar2(300);
58 RPD_REPORT_TOTAL_INV varchar2(17);
59 RPD_REPORT_TOTAL_BAL varchar2(17);
60 RPD_REPORT_TOTAL_DISP varchar2(17);
61 rp_sum_for varchar2(2000);
62 function BeforeReport return boolean ;
63 function AfterReport return boolean ;
64 function report_nameformula(Company_Name in varchar2) return varchar2 ;
65 function AfterPForm return boolean ;
66 function c_data_not_foundformula(Currency_Main in varchar2) return number ;
67 function c_cust_summary_labelformula(Dummy_Customer_Name in varchar2) return varchar2 ;
68 function c_currency_summary_labelformul(Currency_Main in varchar2) return varchar2 ;
69 function cons_numberformula(Number in varchar2, cons_bill_number in varchar2) return varchar2 ;
70 Function RP_COMPANY_NAME_p return varchar2;
71 Function RP_REPORT_NAME_p return varchar2;
72 Function RP_DATA_FOUND_p return varchar2;
73 Function RPD_REPORT_TOTAL_INV_p return varchar2;
74 Function RPD_REPORT_TOTAL_BAL_p return varchar2;
75 Function RPD_REPORT_TOTAL_DISP_p return varchar2;
76 Function rp_sum_for_p return varchar2;
77 END AR_ARXDIR_XMLP_PKG;
78