PACKAGE: APPS.AP_APXINPSR_XMLP_PKG

Source

1 PACKAGE AP_APXINPSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: APXINPSRS.pls 120.1.12020000.2 2012/07/30 07:27:18 lyanduru ship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER;
8 
9   P_FLEXDATA VARCHAR2(600);
10 
11   P_SET_OF_BOOKS_ID NUMBER;
12 
13   P_TRACE_SWITCH VARCHAR2(1);
14 
15   P_INCLUDE_INVOICE VARCHAR2(40);
16 
17   P_INCLUDE_CREDIT VARCHAR2(40);
18 
19   P_FROM_DATE DATE;
20 
21   P_TO_DATE DATE;
22 
23   P_VENDOR_ID VARCHAR2(40);
24 
25   P_VENDOR_TYPE_LOOKUP_CODE VARCHAR2(40);
26 
27   SORT_BY_ALTERNATE VARCHAR2(5);
28 
29   P_PREPAYMENT_TYPE VARCHAR2(40);
30 
31   P_PREPAYMENT_LINE_FLAG VARCHAR2(40);
32 
33   P_CHART_OF_ACCOUNTS_ID NUMBER;
34 
35   C_NLS_YES VARCHAR2(80);
36 
37   C_NLS_NO VARCHAR2(80);
38 
39   C_NLS_ALL VARCHAR2(80);
40 
41   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
42 
43   C_NLS_VOID VARCHAR2(80);
44 
45   C_NLS_NA VARCHAR2(80);
46 
47   C_NLS_END_OF_REPORT VARCHAR2(100);
48 
49   C_REPORT_START_DATE DATE;
50 
51   C_COMPANY_NAME_HEADER VARCHAR2(50);
52 
53   C_BASE_CURRENCY_CODE VARCHAR2(15);
54 
55   C_BASE_PRECISION NUMBER;
56 
57   C_BASE_MIN_ACCT_UNIT NUMBER;
58 
59   C_BASE_DESCRIPTION VARCHAR2(240);
60 
61   C_CHART_OF_ACCOUNTS_ID NUMBER;
62 
63   C_CALENDAR_AWARE_ALT  NUMBER;  --Bug11774150
64 
65   APPLICATIONS_TEMPLATE_REPORT VARCHAR2(1);
66 
67   C_VENDOR_DYNAMIC_SQL VARCHAR2(1000);
68 
69   C_INVOICE_DYNAMIC_SQL VARCHAR2(1000);
70 
71   C_HEADER_VENDOR_TYPE VARCHAR2(80);
72 
73   C_HEADER_VENDOR_NAME VARCHAR2(240);
74 
75   C_HEADER_INCLUDE_INVOICE VARCHAR2(80);
76 
77   C_HEADER_INCLUDE_CREDIT VARCHAR2(80);
78 
79   C_NLS_UNPAID VARCHAR2(80);
80 
81   C_HEADER_SHOW_PREPAY_DIST VARCHAR2(80);
82 
83   C_HEADER_PREPAYMENT_TYPE VARCHAR2(80);
84 
85   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
86 
87   FUNCTION CUSTOM_INIT RETURN BOOLEAN;
88 
89   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
90 
91   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
92 
93   FUNCTION BEFOREREPORT RETURN BOOLEAN;
94 
95   FUNCTION AFTERREPORT RETURN BOOLEAN;
96 
97   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
98 
99   FUNCTION C_AMOUNT_FOR_SUMFORMULA(C_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2
100                                   ,C_AMOUNT_REMAINING IN NUMBER
101                                   ,C_PAYMENT_STATUS_FLAG IN VARCHAR2
102                                   ,C_EARLIEST_SETTLEMENT_DATE IN VARCHAR2
103                                   ,C_PAYMENT_CROSS_RATE IN NUMBER
104                                   ,C_INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
105 
106   FUNCTION C_AMOUNT_REMAINING_CONVERTFORM(C_PAYMENT_CROSS_RATE IN NUMBER
107                                          ,C_AMOUNT_REMAINING IN NUMBER
108                                          ,C_INVOICE_CURRENCY_CODE IN VARCHAR2
109                                          ,C_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2) RETURN NUMBER;
110 
111   FUNCTION C_AMOUNT_REMAINING_DSPFORMULA(C_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2
112                                         ,C_PAYMENT_STATUS_FLAG IN VARCHAR2
113                                         ,C_AMOUNT_REMAINING_TRANS IN VARCHAR2) RETURN CHAR;
114 
115   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
116 
117   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
118 
119   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
120 
121   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
122 
123   FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
124 
125   FUNCTION C_NLS_NA_P RETURN VARCHAR2;
126 
127   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
128 
129   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
130 
131   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
132 
133   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
134 
135   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
136 
137   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
138 
139   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
140 
141   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
142 
143   FUNCTION APPLICATIONS_TEMPLATE_REPORT_P RETURN VARCHAR2;
144 
145   FUNCTION C_VENDOR_DYNAMIC_SQL_P RETURN VARCHAR2;
146 
147   FUNCTION C_INVOICE_DYNAMIC_SQL_P RETURN VARCHAR2;
148 
149   FUNCTION C_HEADER_VENDOR_TYPE_P RETURN VARCHAR2;
150 
151   FUNCTION C_HEADER_VENDOR_NAME_P RETURN VARCHAR2;
152 
153   FUNCTION C_HEADER_INCLUDE_INVOICE_P RETURN VARCHAR2;
154 
155   FUNCTION C_HEADER_INCLUDE_CREDIT_P RETURN VARCHAR2;
156 
157   FUNCTION C_NLS_UNPAID_P RETURN VARCHAR2;
158 
159   FUNCTION C_HEADER_SHOW_PREPAY_DIST_P RETURN VARCHAR2;
160 
161   FUNCTION C_HEADER_PREPAYMENT_TYPE_P RETURN VARCHAR2;
162 
163   FUNCTION C_CALENDAR_AWARE_ALT_P RETURN NUMBER; --14272141
164 
165 END AP_APXINPSR_XMLP_PKG;
166