[Home] [Help]
PACKAGE: APPS.AP_APXINAGE_XMLP_PKG
Source
1 PACKAGE AP_APXINAGE_XMLP_PKG AS
2 /* $Header: APXINAGES.pls 120.0 2007/12/27 07:48:28 vjaganat noship $ */
3 P_DEBUG_SWITCH varchar2(1);
4 P_CONC_REQUEST_ID number;
5 P_MIN_PRECISION number;
6 P_FLEXDATA varchar2(600);
7 P_SET_OF_BOOKS_ID number;
8 P_SORT_OPTION varchar2(32767);
9 P_SORT_OPTION_UPPER varchar2(32767);
10 P_SUMMARY_OPTION varchar2(15);
11 P_FORMAT_OPTION varchar2(32767);
12 P_FORMAT_OPTION_UPPER varchar2(32767);
13 P_AMOUNT_DUE_LOW number;
14 P_AMOUNT_DUE_HIGH number;
15 P_INVOICE_TYPE varchar2(30);
16 P_PARTY_ID varchar2(30);
17 P_PERIOD_TYPE varchar2(50);
18 P_ORDER_BY varchar2(1000) := ' ';
19 P_PARTY_PREDICATE varchar2(100) := ' ';
20 P_TRACE_SWITCH varchar2(1);
21 P_AMT_DUE_LOW number;
22 P_AMT_DUE_HIGH number;
23 P_AMOUNT_PREDICATE varchar2(200) := ' ';
24 SORT_BY_ALTERNATE varchar2(5);
25 C_BASE_CURRENCY_CODE varchar2(15);
26 C_BASE_PRECISION number;
27 C_BASE_MIN_ACCT_UNIT number;
28 C_BASE_DESCRIPTION varchar2(240);
29 C_COMPANY_NAME_HEADER varchar2(50);
30 C_REPORT_START_DATE date;
31 C_NLS_YES varchar2(80);
32 C_NLS_NO varchar2(80);
33 C_NLS_ALL varchar2(80);
34 C_NLS_NO_DATA_EXISTS varchar2(240);
35 C_REPORT_RUN_TIME varchar2(8);
36 C_CHART_OF_ACCOUNTS_ID number;
37 C_VENDOR_NAME_SELECT varchar2(240);
38 C_INVOICE_TYPE_SELECT varchar2(80);
39 C_MINDAYS number;
40 C_MAXDAYS number;
41 C_INV_DUE_1_HEAD_1 varchar2(15);
42 C_INV_DUE_1_HEAD_2 varchar2(15);
43 C_INV_DUE_2_HEAD_1 varchar2(15);
44 C_INV_DUE_2_HEAD_2 varchar2(15);
45 C_INV_DUE_3_HEAD_1 varchar2(15);
46 C_INV_DUE_3_HEAD_2 varchar2(15);
47 C_INV_DUE_4_HEAD_1 varchar2(15);
48 C_INV_DUE_4_HEAD_2 varchar2(15);
49 C_INV_DUE_1_RANGE_FR number;
50 C_INV_DUE_1_RANGE_TO number;
51 C_INV_DUE_2_RANGE_FR number;
52 C_INV_DUE_2_RANGE_TO number;
53 C_INV_DUE_3_RANGE_FR number;
54 C_INV_DUE_3_RANGE_TO number;
55 C_INV_DUE_4_RANGE_FR number;
56 C_INV_DUE_4_RANGE_TO number;
57 C_HEAD_INVOICE_TYPE varchar2(80);
58 C_HEAD_SORT_OPTION varchar2(80);
59 C_HEAD_VENDOR_NAME varchar2(240);
60 C_REP_DATA_CONVERTED varchar2(1);
61 C_NLS_END_OF_REPORT varchar2(100);
62 C_HEAD_SUMMARY_OPTION varchar2(80);
63 C_HEAD_FORMAT_OPTION varchar2(80);
64 FUNCTION get_base_curr_data RETURN BOOLEAN ;
65 FUNCTION custom_init RETURN BOOLEAN ;
66 FUNCTION get_cover_page_values RETURN BOOLEAN ;
67 FUNCTION get_nls_strings RETURN BOOLEAN ;
68 function BeforeReport return boolean ;
69 function AfterReport return boolean ;
70 FUNCTION get_company_name RETURN BOOLEAN ;
71 FUNCTION get_flexdata RETURN BOOLEAN ;
72 FUNCTION set_order_by RETURN BOOLEAN ;
73 FUNCTION get_period_info RETURN BOOLEAN ;
74 function c_contact_lineformula(C_CONTACT_SITE_ID in number) return varchar2 ;
75 function c_percent_remainingformula(C_AMT_DUE_ORIGINAL in number, C_AMT_DUE_REMAINING in number) return number ;
76 function c_inv_due_amt_1formula(C_DAYS_PAST_DUE in number, C_AMT_DUE_REMAINING in number) return number ;
77 function c_inv_due_amt_2formula(C_DAYS_PAST_DUE in number, C_AMT_DUE_REMAINING in number) return number ;
78 function c_inv_due_amt_3formula(C_DAYS_PAST_DUE in number, C_AMT_DUE_REMAINING in number) return number ;
79 function c_inv_due_amt_4formula(C_DAYS_PAST_DUE in number, C_AMT_DUE_REMAINING in number) return number ;
80 function c_per_v_inv_amt_1formula(C_SUM_V_INV_AMT_1 in number, C_SUM_V_DUE_REMAINING in number) return number ;
81 function c_per_v_inv_amt_2formula(C_SUM_V_INV_AMT_2 in number, C_SUM_V_DUE_REMAINING in number) return number ;
82 function c_per_v_inv_amt_3formula(C_SUM_V_INV_AMT_3 in number, C_SUM_V_DUE_REMAINING in number) return number ;
83 function c_per_v_inv_amt_4formula(C_SUM_V_INV_AMT_4 in number, C_SUM_V_DUE_REMAINING in number) return number ;
84 function c_check_data_convertedformula(C_DATA_CONVERTED in varchar2) return number ;
85 function c_per_inv_due_amt_1formula(C_SUM_INV_DUE_AMT_1 in number, C_SUM_AMT_REMAINING in number) return number ;
86 function c_per_inv_due_amt_2formula(C_SUM_INV_DUE_AMT_2 in number, C_SUM_AMT_REMAINING in number) return number ;
87 function c_per_inv_due_amt_3formula(C_SUM_INV_DUE_AMT_3 in number, C_SUM_AMT_REMAINING in number) return number ;
88 function c_per_inv_due_amt_4formula(C_SUM_INV_DUE_AMT_4 in number, C_SUM_AMT_REMAINING in number) return number ;
89 function c_pgbrk_data_convertedformula(C_SUM_DATA_CONVERTED in number) return varchar2 ;
90 function c_v_data_convertedformula(C_SUM_V_DATA_CONVERTED in number) return varchar2 ;
91 function c_tot_per_inv_due_1formula(C_TOT_INV_DUE_AMT_1 in number, C_TOT_AMT_REMAINING in number) return number ;
92 function c_tot_per_inv_due_2formula(C_TOT_INV_DUE_AMT_2 in number, C_TOT_AMT_REMAINING in number) return number ;
93 function c_tot_per_inv_due_3formula(C_TOT_INV_DUE_AMT_3 in number, C_TOT_AMT_REMAINING in number) return number ;
94 function c_tot_per_inv_due_4formula(C_TOT_INV_DUE_AMT_4 in number, C_TOT_AMT_REMAINING in number) return number ;
95 Function C_BASE_CURRENCY_CODE_p return varchar2;
96 Function C_BASE_PRECISION_p return number;
97 Function C_BASE_MIN_ACCT_UNIT_p return number;
98 Function C_BASE_DESCRIPTION_p return varchar2;
99 Function C_COMPANY_NAME_HEADER_p return varchar2;
100 Function C_REPORT_START_DATE_p return date;
101 Function C_NLS_YES_p return varchar2;
102 Function C_NLS_NO_p return varchar2;
103 Function C_NLS_ALL_p return varchar2;
104 Function C_NLS_NO_DATA_EXISTS_p return varchar2;
105 Function C_REPORT_RUN_TIME_p return varchar2;
106 Function C_CHART_OF_ACCOUNTS_ID_p return number;
107 Function C_VENDOR_NAME_SELECT_p return varchar2;
108 Function C_INVOICE_TYPE_SELECT_p return varchar2;
109 Function C_MINDAYS_p return number;
110 Function C_MAXDAYS_p return number;
111 Function C_INV_DUE_1_HEAD_1_p return varchar2;
112 Function C_INV_DUE_1_HEAD_2_p return varchar2;
113 Function C_INV_DUE_2_HEAD_1_p return varchar2;
114 Function C_INV_DUE_2_HEAD_2_p return varchar2;
115 Function C_INV_DUE_3_HEAD_1_p return varchar2;
116 Function C_INV_DUE_3_HEAD_2_p return varchar2;
117 Function C_INV_DUE_4_HEAD_1_p return varchar2;
118 Function C_INV_DUE_4_HEAD_2_p return varchar2;
119 Function C_INV_DUE_1_RANGE_FR_p return number;
120 Function C_INV_DUE_1_RANGE_TO_p return number;
121 Function C_INV_DUE_2_RANGE_FR_p return number;
122 Function C_INV_DUE_2_RANGE_TO_p return number;
123 Function C_INV_DUE_3_RANGE_FR_p return number;
124 Function C_INV_DUE_3_RANGE_TO_p return number;
125 Function C_INV_DUE_4_RANGE_FR_p return number;
126 Function C_INV_DUE_4_RANGE_TO_p return number;
127 Function C_HEAD_INVOICE_TYPE_p return varchar2;
128 Function C_HEAD_SORT_OPTION_p return varchar2;
129 Function C_HEAD_VENDOR_NAME_p return varchar2;
130 Function C_REP_DATA_CONVERTED_p return varchar2;
131 Function C_NLS_END_OF_REPORT_p return varchar2;
132 Function C_HEAD_SUMMARY_OPTION_p return varchar2;
133 Function C_HEAD_FORMAT_OPTION_p return varchar2;
134 END AP_APXINAGE_XMLP_PKG;
135