[Home] [Help]
PACKAGE: APPS.AR_RAXINVPR_XMLP_PKG
Source
1 PACKAGE AR_RAXINVPR_XMLP_PKG AS
2 /* $Header: RAXINVPRS.pls 120.0 2007/12/27 14:27:31 abraghun noship $ */
3 P_TRX_NUMBER_LOW varchar2(40);
4 P_TRX_NUMBER_HIGH varchar2(40);
5 P_CHOICE varchar2(40);
6 P_OPEN_INVOICE varchar2(40);
7 P_CUST_TRX_TYPE_ID number;
8 P_INSTALLMENT_NUMBER number;
9 P_DATES_LOW date;
10 P_DATES_HIGH date;
11 P_CUSTOMER_ID varchar2(40);
12 p_customer_class_code varchar2(40);
13 p_batch_id varchar2(40);
14 P_customer_trx_id number;
15 p_where1 varchar2(8096):= 'U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID
16 AND U_BILL.SITE_USE_ID = A.BILL_TO_SITE_USE_ID
17 AND A.COMPLETE_FLAG = ''Y''
18 AND A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID
19 AND DECODE(P.PAYMENT_SCHEDULE_ID, '''', 0, NVL(T.PRINTING_LEAD_DAYS,0) ) = 0
20 AND NVL(P.TERMS_SEQUENCE_NUMBER,TL.SEQUENCE_NUM)=TL.SEQUENCE_NUM
21 AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID (+)
22 AND A.PRINTING_OPTION IN (''PRI'', ''REP'')
23 AND A.TERM_ID = TL.TERM_ID
24 AND A.TERM_ID = T.TERM_ID
25 AND L_TYPES.LOOKUP_TYPE = ''INV/CM''
26 AND TYPES.CUST_TRX_TYPE_ID = A.CUST_TRX_TYPE_ID
27 AND L_TYPES.LOOKUP_CODE = DECODE( TYPES.TYPE, ''DEP'', ''INV'', TYPES.TYPE ) AND A_BILL.party_site_id = party_site.party_site_id
28 AND B.PARTY_ID = PARTY.PARTY_ID
29 AND loc.location_id = party_site.location_id';
30 p_where2 varchar2(8096):= 'U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID
31 AND U_BILL.SITE_USE_ID = A.BILL_TO_SITE_USE_ID
32 AND A.COMPLETE_FLAG = ''Y''
33 AND NVL(A.PRINTING_OPTION, ''REP'') IN (''PRI'', ''REP'')
34 AND A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID
35 AND T.PRINTING_LEAD_DAYS > 0
36 AND T.TERM_ID = A.TERM_ID
37 AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID
38 AND L_TYPES.LOOKUP_TYPE = ''INV/CM''
39 AND TYPES.CUST_TRX_TYPE_ID = A.CUST_TRX_TYPE_ID
40 AND L_TYPES.LOOKUP_CODE = DECODE( TYPES.TYPE, ''DEP'', ''INV'', TYPES.TYPE ) AND A_BILL.party_site_id = party_site.party_site_id
41 AND B.PARTY_ID = PARTY.PARTY_ID
42 AND loc.location_id = party_site.location_id';
43 P_table1 varchar2(8096):='AR_ADJUSTMENTS COM_ADJ, AR_PAYMENT_SCHEDULES P,
44 RA_CUST_TRX_LINE_GL_DIST REC, RA_CUSTOMER_TRX A, HZ_CUST_ACCOUNTS B,
45 RA_TERMS T, RA_TERMS_LINES TL, RA_CUST_TRX_TYPES TYPES, AR_LOOKUPS L_TYPES,
46 HZ_PARTIES PARTY, HZ_CUST_ACCT_SITES A_BILL, HZ_PARTY_SITES PARTY_SITE,
47 HZ_LOCATIONS LOC, HZ_CUST_SITE_USES U_BILL';
48 P_table2 varchar2(8096):='RA_TERMS_LINES TL,
49 RA_CUST_TRX_TYPES TYPES, AR_LOOKUPS L_TYPES,
50 HZ_CUST_ACCOUNTS B, HZ_PARTIES PARTY, HZ_CUST_SITE_USES U_BILL,
51 HZ_CUST_ACCT_SITES A_BILL, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC,
52 AR_ADJUSTMENTS COM_ADJ, RA_CUSTOMER_TRX A, AR_PAYMENT_SCHEDULES P, RA_TERMS T';
53 P_adj_number_low varchar2(32767);
54 P_adj_number_high varchar2(32767);
55 P_adj_dates_low date;
56 P_adj_dates_high date;
57 P_cust_trx_class varchar2(40);
58 P_CONC_REQUEST_ID number;
59 P_MIN_PRECISION number;
60 INSTALLMENT_PRINTING_PENDING varchar2(32767);
61 RP_DATA_FOUND varchar2(100);
62 RP_COMPANY_NAME varchar2(50);
63 RP_REPORT_NAME varchar2(240);
64 Print_option varchar2(80);
65 Type_id varchar2(30);
66 Customer_id varchar2(50);
67 Batch_id varchar2(50);
68 Open_Invoices varchar2(80);
69 Invoice_Dates varchar2(50);
70 Invoice_Numbers varchar2(50);
71 Functional_Currency varchar2(15);
72 function AfterPForm return boolean ;
73 function BeforeReport return boolean ;
74 function AfterReport return boolean ;
75 function installment_last_print_datefor(sequence_num in number, last_printed_sequence_num in number, printing_pending in varchar2, last_print_date in date) return date ;
76 Function INSTALLMENT_PRINTING_PENDING_p return varchar2;
77 Function RP_DATA_FOUND_p return varchar2;
78 Function RP_COMPANY_NAME_p return varchar2;
79 Function RP_REPORT_NAME_p return varchar2;
80 Function Print_option_p return varchar2;
81 Function Type_id_p return varchar2;
82 Function Customer_id_p return varchar2;
83 Function Batch_id_p return varchar2;
84 Function Open_Invoices_p return varchar2;
85 Function Invoice_Dates_p return varchar2;
86 Function Invoice_Numbers_p return varchar2;
87 Function Functional_Currency_p return varchar2;
88 function D_AmountFormula return VARCHAR2;
89 END AR_RAXINVPR_XMLP_PKG;
90
91