[Home] [Help]
PACKAGE: APPS.AR_ARXRJR_XMLP_PKG
Source
1 PACKAGE AR_ARXRJR_XMLP_PKG AS
2 /* $Header: ARXRJRS.pls 120.0 2007/12/27 14:06:59 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 lp_company_low varchar2(2000):=' ';
5 lp_company_high varchar2(2000):=' ';
6 lp_account_low varchar2(2500):=' ';
7 lp_account_high varchar2(2500):=' ';
8 p_in_company_low varchar2(25);
9 p_in_company_high varchar2(25);
10 p_in_account_low varchar2(2000);
11 p_in_account_high varchar2(2000);
12 p_chart_of_accounts_id number;
13 p_report_mode varchar2(30);
14 p_status varchar2(30);
15 p_receipt_class varchar2(30);
16 p_payment_method varchar2(30);
17 p_gl_date_low date;
18 p_gl_date_high date;
19 p_currency varchar2(15);
20 p_order_by varchar2(30);
21 P_REPORT_MODE_T varchar2(30);
22 P_ORDER_BY_T varchar2(30);
23 FACCMSG varchar2(30);
24 lp_accounting_flex varchar2(2000):=' rpad(segment1,600) ';
25 lp_company_seg varchar2(1000):='segment1';
26 p_company_name varchar2(80);
27 p_currency_disp varchar2(15);
28 LP_GROUP_BY varchar2(1000):=' group by segment1, st.meaning, rc.name, rm.name, cr.cash_receipt_id, cr.receipt_number, party.party_name, cust_acct.account_number, site_uses.location,cr.doc_sequence_value ';
29 LP_NAME varchar2(200):='to_char(''AAAAAAAAAAAAAAAAAAAA'')';
30 LP_TRXDATE varchar2(200):='to_date(null)';
31 LP_GLDATE varchar2(200):='to_date(null)';
32 lp_order_by varchar2(100):=' ';
33 LP_GL_DATE_LOW varchar2(200):=' ';
34 LP_GL_DATE_HIGH varchar2(200):=' ';
35 LP_SOURCE_TYPE varchar2(200):=' ';
36 LP_RECEIPT_CLASS varchar2(200):=' ';
37 LP_PAYMENT_METHOD varchar2(200):=' ';
38 LP_CURRENCY varchar2(200):=' ';
39 P_REPORTING_LEVEL number;
40 P_reporting_context number;
41 P_SET_OF_BOOKS_ID number;
42 P_POSTING_STATUS varchar2(32767);
43 P_IN_CUSTOMER_NAME_LOW varchar2(200);
44 P_IN_CUSTOMER_NAME_HIGH varchar2(200);
45 P_IN_CUSTOMER_NUM_LOW varchar2(30);
46 P_IN_CUSTOMER_NUM_HIGH varchar2(30);
47 P_FROM_WHERE varchar2(2000);
48 P_cr_where varchar2(700):=' ';
49 P_hist varchar2(100):='ar_cash_receipt_history_all';
50 P_dist varchar2(100):= 'ar_xla_ard_lines_v';
51 p_gl varchar2(100):= 'gl_code_combinations';
52 P_cust varchar2(100):='hz_cust_accounts_all';
53 P_cash varchar2(100):='ar_cash_receipts';
54 P_party varchar2(100):='hz_parties';
55 P_site varchar2(100):='hz_cust_site_uses_All';
56 P_rm varchar2(100):='ar_receipt_methods';
57 P_RC varchar2(100):='ar_receipt_classes';
58 P_look varchar2(50):='ar_lookups';
59 P_batch varchar2(100):='ar_batches_all';
60 P_reporting_entity_id number;
61 lp_customer_name_low varchar2(200):=' ';
62 lp_customer_name_high varchar2(200):=' ';
63 lp_customer_num_low varchar2(2000):=' ';
64 lp_customer_num_high varchar2(2000):=' ';
65 P_cust_where varchar2(1000);
66 P_site_where varchar2(1000);
67 lp_account_high1 varchar2(2000);
68 lp_account_low1 varchar2(2000);
69 RP_DATA_FOUND varchar2(300);
70 C_BAL_OR_TRANS_AMOUNT varchar2(800) := 'SUM (DECODE(d.amount_cr, null,DECODE(:p_currency, null,d.acctd_amount_dr, d.amount_dr), DECODE(:p_currency, null,-d.acctd_amount_cr, -d.amount_cr)))' ;
71 C_HAVING varchar2(800);
72 reporting_level_name varchar2(30);
73 reporting_context_name varchar2(80);
74 Reporting_entity_level_name varchar2(80);
75 rp_message varchar2(2000);
76 CP_ACC_MESSAGE varchar2(2000);
77 function BeforeReport return boolean ;
78 function AfterReport return boolean ;
79 function AfterPForm return boolean ;
80 Function RP_DATA_FOUND_p return varchar2;
81 Function C_BAL_OR_TRANS_AMOUNT_p return varchar2;
82 Function C_HAVING_p return varchar2;
83 Function reporting_level_name_p return varchar2;
84 Function reporting_context_name_p return varchar2;
85 Function Reporting_entity_level_name_p return varchar2;
86 Function rp_message_p return varchar2;
87 Function CP_ACC_MESSAGE_p return varchar2;
88 function F_ACC_MESSAGEFormatTrigger return varchar2;
89
90 END AR_ARXRJR_XMLP_PKG;
91