[Home] [Help]
PACKAGE: APPS.AR_ARXBPH_XMLP_PKG
Source
1 PACKAGE AR_ARXBPH_XMLP_PKG AS
2 /* $Header: ARXBPHS.pls 120.0 2007/12/27 13:36:24 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_IN_CUSTOMER_NUM_LOW varchar2(30);
5 P_IN_CUSTOMER_NUM_HIGH varchar2(30);
6 LP_CUSTOMER_NAME_LOW varchar2(200);
7 P_IN_CUSTOMER_LOW varchar2(50);
8 P_IN_CUSTOMER_HIGH varchar2(50);
9 P_IN_INVOICE_NUMBER_LOW varchar2(30);
10 P_IN_INVOICE_NUMBER_HIGH varchar2(30);
11 LP_TRX_DATE_LOW varchar2(200) := ' ';
12 LP_TRX_DATE_HIGH varchar2(200) := ' ';
13 P_IN_TRX_DATE_LOW date;
14 P_IN_TRX_DATE_HIGH date;
15 LP_INVOICE_AMOUNT_LOW varchar2(200) := ' ';
16 LP_INVOICE_AMOUNT_HIGH varchar2(200) := ' ';
17 LP_ACCOUNT_STATUS_LOW varchar2(200);
18 LP_ACCOUNT_STATUS_HIGH varchar2(200);
19 LP_INVOICE_NUMBER_HIGH varchar2(200) := ' ';
20 LP_INVOICE_NUMBER_LOW varchar2(200) := ' ';
21 P_WHERE_11 varchar2(400) := ' ';
22 P_IN_INVOICE_AMOUNT_LOW number;
23 P_IN_INVOICE_AMOUNT_HIGH number;
24 P_IN_BALANCE_DUE_LOW number;
25 P_IN_BALANCE_DUE_HIGH number;
26 P_IN_ACCOUNT_STATUS_LOW varchar2(200);
27 P_IN_ACCOUNT_STATUS_HIGH varchar2(200);
28 P_IN_ACCOUNT_STATUS_LOW_1 varchar2(200);
29 P_IN_ACCOUNT_STATUS_HIGH_1 varchar2(200);
30 LP_BALANCE_DUE_LOW varchar2(200) := ' ';
31 LP_BALANCE_DUE_HIGH varchar2(200) := ' ';
32 LP_CUSTOMER_NAME_HIGH varchar2(200);
33 P_sob number;
34 LP_CUSTOMER_NUM_LOW varchar2(200) := ' ';
35 LP_CUSTOMER_NUM_HIGH varchar2(200) := ' ';
36 P_WHERE_12 varchar2(200) := ' ';
37 P_WHERE_1 varchar2(200) := ' ';
38 P_WHERE_2 varchar2(200) := ' ';
39 lp_r_trx_date_low varchar2(200) := ' ';
40 lp_r_trx_date_high varchar2(200) := ' ';
41 P_CONS_PROFILE_VALUE varchar2(10) := 'N';
42 LP_QUERY_SHOW_BILL varchar2(1000);
43 LP_TABLE_SHOW_BILL varchar2(1000) := ' ';
44 LP_WHERE_SHOW_BILL varchar2(1000) := ' ';
45 lp_currency_show_bill varchar2(32767);
46 P_MAX_ID number;
47 Credits_Dummy varchar2(14);
48 Adjusts_Dummy varchar2(14);
49 Payment_no_dummy_cr varchar2(32767);
50 Payments_Dummy varchar2(14);
51 Adjusts_Dummy_Cr varchar2(14);
52 payment_no_dummy_adj varchar2(32767);
53 Payments_Dummy_adj varchar2(14);
54 Credits_Dummy_Adj varchar2(14);
55 RP_COMPANY_NAME varchar2(50);
56 RP_REPORT_NAME varchar2(80);
57 RP_DATA_FOUND varchar2(100);
58 Status_Low varchar2(200);
59 Status_high varchar2(200);
60 function BeforeReport return boolean ;
61 function AfterReport return boolean ;
62 function report_nameformula(Company_Name in varchar2) return varchar2 ;
63 function D_INVOICE_AMOUNTFormula(customer_name in varchar2) return VARCHAR2;
64
65 function Set_StatusFormula return VARCHAR2 ;
66 function AfterPForm return boolean ;
67 Function Credits_Dummy_p return varchar2;
68 Function Adjusts_Dummy_p return varchar2;
69 Function Payment_no_dummy_cr_p return varchar2;
70 Function Payments_Dummy_p return varchar2;
71 Function Adjusts_Dummy_Cr_p return varchar2;
72 Function payment_no_dummy_adj_p return varchar2;
73 Function Payments_Dummy_adj_p return varchar2;
74 Function Credits_Dummy_Adj_p return varchar2;
75 Function RP_COMPANY_NAME_p return varchar2;
76 Function RP_REPORT_NAME_p return varchar2;
77 Function RP_DATA_FOUND_p return varchar2;
78 Function Status_Low_p return varchar2;
79 Function Status_high_p return varchar2;
80 END AR_ARXBPH_XMLP_PKG;
81