[Home] [Help]
PACKAGE: APPS.AR_ARXPDI_XMLP_PKG
Source
1 PACKAGE AR_ARXPDI_XMLP_PKG AS
2 /* $Header: ARXPDIS.pls 120.1 2008/01/11 10:36:39 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_CUSTOMER_NAME_LOW varchar2(50);
5 P_CUSTOMER_NAME_HIGH varchar2(50);
6 P_INVOICE_TYPE_LOW varchar2(80);
7 P_INVOICE_TYPE_HIGH varchar2(80);
8 P_ORDER_BY varchar2(50);
9 P_PAST_DAYS_DUE_LOW varchar2(15);
10 P_PAST_DAYS_DUE_HIGH varchar2(15);
11 P_AMOUNT_LOW number;
12 P_AMOUNT_HIGH number;
13 P_COLLECTOR_LOW varchar2(30);
14 P_COLLECTOR_HIGH varchar2(30);
15 P_SALESREP_LOW varchar2(240);
16 P_SALESREP_HIGH varchar2(240);
17 P_AS_OF_DATE date;
18 lp_order_by varchar2(300):=' ';
19 lp_amount_low varchar2(200):=' ';
20 lp_amount_high varchar2(200):=' ';
21 lp_collector_low varchar2(100):=' ';
22 lp_collector_high varchar2(100):=' ';
23 lp_customer_name_low varchar2(100):=' ';
24 lp_customer_name_high varchar2(100):=' ';
25 lp_invoice_type_low varchar2(100):=' ';
26 lp_invoice_type_high varchar2(100):=' ';
27 ph_customer_number_low varchar2(50);
28 ph_customer_number_high varchar2(50);
29 P_CUSTOMER_NUMBER_LOW varchar2(50);
30 P_CUSTOMER_NUMBER_HIGH varchar2(50);
31 lp_customer_number_low varchar2(100):=' ';
32 lp_customer_number_high varchar2(100):=' ';
33 lp_past_days_due_low varchar2(100):=' ';
34 lp_past_days_due_high varchar2(100):=' ';
35 lp_salesrep_low varchar2(340):=' ';
36 lp_salesrep_high varchar2(340):=' ';
37 P_CONS_PROFILE_VALUE varchar2(10):='N';
38 LP_QUERY_SHOW_BILL varchar2(1000):=' ';
39 LP_TABLE_SHOW_BILL varchar2(1000):=' ';
40 LP_WHERE_SHOW_BILL varchar2(1000):=' ';
41 P_DAYS_PAST_DUE_FROM varchar2(100);
42 P_BALANCE_DUE_FROM varchar2(100);
43 P_balance_due varchar2(80);
44 P_customer varchar2(80);
45 P_salesperson varchar2(240);
46 P_as_of varchar2(2000);
47 ACCT_BAL_APROMPT varchar2(80);
48 RP_OLD_CURR varchar2(20);
49 RP_CURR_CHECK number;
50 RP_OLD_CUSTOMER varchar2(50);
51 RP_CUST_CHECK number;
52 RP_COMPANY_NAME varchar2(50);
53 RP_REPORT_NAME varchar2(80);
54 RP_DATA_FOUND varchar2(300);
55 RP_AS_OF_DATE varchar2(30);
56 RP_PAST_DAYS varchar2(40);
57 RP_BALANCE varchar2(50);
58 RP_SALE_CURR varchar2(270);
59 RP_CURR varchar2(30);
60 c_industry_code varchar2(20);
61 c_salesrep_title varchar2(20);
62 rp_balance_from varchar2(40);
63 rp_balance_to varchar2(40);
64 rp_past_days_from varchar2(40);
65 rp_past_days_to varchar2(40);
66 function BeforeReport return boolean ;
67 function AfterReport return boolean ;
68 function report_nameformula(Company_Name in varchar2) return varchar2 ;
69 function AfterPForm return boolean ;
70 function c_temp_salformula(Currency_Code in varchar2,Salesrep in varchar2) return varchar2 ;
71 function c_data_foundformula(Currency_Code in varchar2) return varchar2 ;
72 function c_custom_checkformula(Currency_Code in varchar2, Cust_ID in number) return varchar2 ;
73 procedure get_boiler_plates ;
74 procedure get_lookup_meaning(p_lookup_type in varchar2,
75 p_lookup_code in varchar2,
76 p_lookup_meaning in out NOCOPY varchar2)
77 ;
78 function set_display_for_core return boolean ;
79 function set_display_for_gov return boolean ;
80 function invoice_number_consformula(invoice_number in varchar2, cons_bill_number in varchar2) return varchar2 ;
81 function CF_ORDER_BYFormula return Char ;
82 function CF_salespersonFormula return Char ;
83 Function ACCT_BAL_APROMPT_p return varchar2;
84 Function RP_OLD_CURR_p return varchar2;
85 Function RP_CURR_CHECK_p return number;
86 Function RP_OLD_CUSTOMER_p return varchar2;
87 Function RP_CUST_CHECK_p return number;
88 Function RP_COMPANY_NAME_p return varchar2;
89 Function RP_REPORT_NAME_p return varchar2;
90 Function RP_DATA_FOUND_p return varchar2;
91 Function RP_AS_OF_DATE_p return varchar2;
92 Function RP_PAST_DAYS_p return varchar2;
93 Function RP_BALANCE_p return varchar2;
94 Function RP_SALE_CURR_p return varchar2;
95 Function RP_CURR_p return varchar2;
96 Function c_industry_code_p return varchar2;
97 Function c_salesrep_title_p return varchar2;
98 Function rp_balance_from_p return varchar2;
99 Function rp_balance_to_p return varchar2;
100 Function rp_past_days_from_p return varchar2;
101 Function rp_past_days_to_p return varchar2;
102 END AR_ARXPDI_XMLP_PKG;
103
104