[Home] [Help]
PACKAGE: APPS.AP_APXINRIR_XMLP_PKG
Source
1 PACKAGE AP_APXINRIR_XMLP_PKG AS
2 /* $Header: APXINRIRS.pls 120.0 2007/12/27 08:01:46 vjaganat noship $ */
3 P_FLEXDATA varchar2(800);
4 P_CONC_REQUEST_ID number;
5 P_MIN_PRECISION number;
6 P_DEBUG_SWITCH varchar2(1);
7 P_SOB_ID number;
8 P_FLEXDATA1 varchar2(800):='(GC2.SEGMENT1||''\n''||GC2.SEGMENT2||''\n''||GC2.SEGMENT3||''\n''||GC2.SEGMENT4||''\n''||GC2.SEGMENT5||''\n''||GC2.SEGMENT6||''\n''||GC2.SEGMENT7||''\n''||GC2.SEGMENT8||
9 ''\n''||GC2.SEGMENT9||''\n''||GC2.SEGMENT10||''\n''||GC2.SEGMENT11||''\n''||GC2.SEGMENT12||''\n''||GC2.SEGMENT13||''\n''||GC2.SEGMENT14||''\n''||GC2.SEGMENT15||''\n''||GC2.SEGMENT16||''\n''||GC2.SEGMENT17
10 ||''\n''||GC2.SEGMENT18||''\n''||GC2.SEGMENT19||''\n''||GC2.SEGMENT20||''\n''||GC2.SEGMENT21||''\n''||GC2.SEGMENT22||''\n''||GC2.SEGMENT23||''\n''||GC2.SEGMENT24||''\n''||GC2.SEGMENT25||''\n''||GC2.SEGMENT26||
11 ''\n''||GC2.SEGMENT27||''\n''||GC2.SEGMENT28||''\n''||GC2.SEGMENT29||''\n''||GC2.SEGMENT30)';
12 P_BATCH varchar2(50);
13 P_ENTRY_PERSON varchar2(50);
14 P_START_DATE date;
15 CP_START_DATE varchar2(25);
16 P_END_DATE date;
17 CP_END_DATE varchar2(25);
18 P_ACCOUNTING_PERIOD varchar2(15);
19 P_CANCELLED_FLAG varchar2(1);
20 P_UNAPPROVE_FLAG varchar2(1);
21 p_unapprove_flag_1 varchar2(1);
22 P_dynamic_batch_orderby varchar2(32767):= 'NULL';
23 P_invoice_amount varchar2(240):='inv1.invoice_amount';
24 P_gl_code_combinations2 varchar2(50):='gl_code_combinations GC2,';
25 P_INVOICE_TYPE varchar2(25);
26 P_TRACE_SWITCH varchar2(1);
27 SORT_BY_ALTERNATE varchar2(5);
28 P_VENDOR_ID number;
29 --C_BASE_CURRENCY_CODE varchar2(32767) := := '$$$' ;
30 C_BASE_CURRENCY_CODE varchar2(32767) := '$$$' ;
31 C_BASE_PRECISION number := 2 ;
32 C_BASE_MIN_ACCT_UNIT number;
33 --C_NLS_YES varchar2(80) := := 'Yes' ;
34 C_NLS_YES varchar2(80) := 'Yes' ;
35 --C_NLS_NO varchar2(80) := := 'No' ;
36 C_NLS_NO varchar2(80) := 'No' ;
37 C_NLS_ALL varchar2(80);
38 --C_COMPANY_NAME_HEADER varchar2(30) := := 'No Company Name' ;
39 C_COMPANY_NAME_HEADER varchar2(30) := 'No Company Name' ;
40 C_CHART_OF_ACCOUNTS_ID number;
41 C_NLS_NA varchar2(80);
42 C_NLS_NO_DATA_EXISTS varchar2(240);
43 C_SHOW_LIB_ACCT varchar2(1);
44 C_BATCH_FLAG varchar2(1);
45 C_BATCH_ID varchar2(15);
46 C_USER_ID varchar2(14);
47 C_liability_acct_flex varchar2(240);
48 C_batch_predicate varchar2(240):= ' ';
49 C_match_status_predicate varchar2(240) := ' ';
50 C_invoice_cancelled_predicate varchar2(240);
51 C_created_by_predicate varchar2(240);
52 C_start_date_predicate varchar2(240);
53 C_end_date_predicate varchar2(240);
54 C_gl_ccid2_predicate varchar2(240);
55 C_orderby_batch_id varchar2(50);
56 C_INV_TYPE_PRED varchar2(240);
57 C_NLS_END_OF_REPORT varchar2(100);
58 C_INVOICE_ID_PREDICATE varchar2(240);
59 C_ACCOUNTING_DATE_PREDICATE varchar2(150);
60 C_CANCELLED_INVOICES_ONLY varchar2(20);
61 C_UNAPPROVED_INVOICES_ONLY varchar2(20);
62 C_Supplier_Name varchar2(240);
63 C_INVOICE_TYPE1 varchar2(80);
64 function BeforeReport return boolean ;
65 function AfterReport return boolean ;
66 FUNCTION custom_init RETURN BOOLEAN ;
67 FUNCTION get_base_curr_data RETURN BOOLEAN ;
68 FUNCTION get_company_name RETURN BOOLEAN ;
69 FUNCTION get_nls_strings RETURN BOOLEAN ;
70 FUNCTION get_flexdata RETURN BOOLEAN ;
71 FUNCTION set_p_where RETURN BOOLEAN ;
72 FUNCTION GET_SUPPLIER_INVOICE_INFO RETURN BOOLEAN ;
73 Function C_BASE_CURRENCY_CODE_p return varchar2;
74 Function C_BASE_PRECISION_p return number;
75 Function C_BASE_MIN_ACCT_UNIT_p return number;
76 Function C_NLS_YES_p return varchar2;
77 Function C_NLS_NO_p return varchar2;
78 Function C_NLS_ALL_p return varchar2;
79 Function C_COMPANY_NAME_HEADER_p return varchar2;
80 Function C_CHART_OF_ACCOUNTS_ID_p return number;
81 Function C_NLS_NA_p return varchar2;
82 Function C_NLS_NO_DATA_EXISTS_p return varchar2;
83 Function C_SHOW_LIB_ACCT_p return varchar2;
84 Function C_BATCH_FLAG_p return varchar2;
85 Function C_BATCH_ID_p return varchar2;
86 Function C_USER_ID_p return varchar2;
87 Function C_liability_acct_flex_p return varchar2;
88 Function C_batch_predicate_p return varchar2;
89 Function C_match_status_predicate_p return varchar2;
90 --Function C_invoice_cancelled_predicate return varchar2;
91 Function C_invoice_cancelled_pred_1 return varchar2;
92 Function C_created_by_predicate_p return varchar2;
93 Function C_start_date_predicate_p return varchar2;
94 Function C_end_date_predicate_p return varchar2;
95 Function C_gl_ccid2_predicate_p return varchar2;
96 Function C_orderby_batch_id_p return varchar2;
97 Function C_INV_TYPE_PRED_p return varchar2;
98 Function C_NLS_END_OF_REPORT_p return varchar2;
99 Function C_INVOICE_ID_PREDICATE_p return varchar2;
100 Function C_ACCOUNTING_DATE_PREDICATE_p return varchar2;
101 Function C_CANCELLED_INVOICES_ONLY_p return varchar2;
102 Function C_UNAPPROVED_INVOICES_ONLY_p return varchar2;
103 Function C_Supplier_Name_p return varchar2;
104 Function C_INVOICE_TYPE1_p return varchar2;
105 END AP_APXINRIR_XMLP_PKG;
106
107