[Home] [Help]
PACKAGE: APPS.AP_APXTRSWP_XMLP_PKG
Source
1 PACKAGE AP_APXTRSWP_XMLP_PKG AS
2 /* $Header: APXTRSWPS.pls 120.0 2007/12/27 08:42:09 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_TRACE_SWITCH varchar2(1);
9 P_AIP_ORG_WHERE varchar2(2000);
10 P_AC_ORG_WHERE varchar2(2000);
11 P_APH_ORG_WHERE varchar2(2000);
12 P_AI_ORG_WHERE varchar2(2000);
13 P_AID_ORG_WHERE varchar2(2000);
14 P_PH_ORG_WHERE varchar2(2000);
15 P_PLL_ORG_WHERE varchar2(2000);
16 P_SWEEP_NOW varchar2(1);
17 P_SWEEP_NOW_1 varchar2(1);
18 P_REPORTING_ENTITY_ID number;
19 P_REPORTING_LEVEL varchar2(30);
20 P_PERIOD_NAME varchar2(15);
21 P_TO_PERIOD varchar2(15);
22 P_FROM_ACCTG_DATE date;
23 P_TO_ACCTG_DATE date;
24 P_entity_name varchar2(240);
25 P_level_name varchar2(200);
26 P_AH_ORG_WHERE varchar2(2000);
27 P_UNACC_TRANS_SWP varchar2(200);
28 P_UNACC_SWP_REV varchar2(200);
29 P_UNACC_TRANS_REP varchar2(200);
30 P_ACCT_METHOD varchar2(1);
31 P_START_DATE date;
32 P_END_DATE date;
33 P_UNACCT_RPT varchar2(1);
34 C_NLS_YES varchar2(80);
35 C_NLS_NO varchar2(80);
36 C_NLS_ALL varchar2(80);
37 C_NLS_NO_DATA_EXISTS varchar2(240);
38 C_NLS_VOID varchar2(80);
39 C_NLS_NA varchar2(80);
40 C_NLS_END_OF_REPORT varchar2(100);
41 C_REPORT_START_DATE date;
42 C_COMPANY_NAME_HEADER varchar2(50);
43 C_BASE_CURRENCY_CODE varchar2(15);
44 C_BASE_PRECISION number;
45 C_BASE_MIN_ACCT_UNIT number;
46 C_BASE_DESCRIPTION varchar2(240);
47 C_CHART_OF_ACCOUNTS_ID number;
48 --Applications Template Report varchar2(1);
49 Applications_Template_Report varchar2(1);
50 --C_AIP_MULTI_ORG_WHERE varchar2(2000) := := 'AND 1=1' ;
51 C_AIP_MULTI_ORG_WHERE varchar2(2000) := 'AND 1=1' ;
52 --C_APH_MULTI_ORG_WHERE varchar2(2000) := := 'AND 1=1' ;
53 C_APH_MULTI_ORG_WHERE varchar2(2000) := 'AND 1=1' ;
54 --C_PMTS_MULTI_ORG_WHERE varchar2(2000) := := 'AND 1=1' ;
55 C_PMTS_MULTI_ORG_WHERE varchar2(2000) := 'AND 1=1' ;
56 --C_INV_MULTI_ORG_WHERE varchar2(2000) := := 'AND 1=1' ;
57 C_INV_MULTI_ORG_WHERE varchar2(2000) := 'AND 1=1' ;
58 --C_ORG_FROM_TABLES varchar2(200) := := 'sys.dual' ;
59 C_ORG_FROM_TABLES varchar2(200) := 'sys.dual' ;
60 --C_SELECT_LE varchar2(20) := := ''Legal Entity'' ;
61 C_SELECT_LE varchar2(20) := 'Legal Entity' ;
62 --C_SELECT_OU varchar2(20) := := ''Operating Unit'' ;
63 C_SELECT_OU varchar2(20) := 'Operating Unit' ;
64 C_REP_TITLE varchar2(50);
65 C_SWEEP_TO_DATE date;
66 LEDGER_PART varchar2(3);
67 C_ACCRUAL_BASIS_IN_USE varchar2(1);
68 C_FROM_ACCTG_DATE date;
69 C_TO_ACCTG_DATE date;
70 C_APH_ACCTG_DATE varchar2(45);
71 C_SWEEP_NOW varchar2(80);
72 C_DATE_FILTER_INV varchar2(2000);
73 C_DATE_FILTER_PAY varchar2(2000);
74 C_DATE_FILTER_PAYHIST varchar2(2000);
75 C_LEDGER_PARTIAL_OU varchar2(240);
76 FUNCTION get_base_curr_data RETURN BOOLEAN ;
77 FUNCTION custom_init RETURN BOOLEAN ;
78 FUNCTION get_cover_page_values RETURN BOOLEAN ;
79 FUNCTION get_nls_strings RETURN BOOLEAN ;
80 function BeforeReport return boolean ;
81 function AfterReport return boolean ;
82 FUNCTION get_company_name RETURN BOOLEAN ;
83 FUNCTION get_flexdata RETURN BOOLEAN ;
84 FUNCTION GET_ORG_PLACEHOLDERS RETURN BOOLEAN ;
85 FUNCTION UPDATE_PO_CLOSE_DATE RETURN BOOLEAN ;
86 FUNCTION UPDATE_ACCTG_DATES RETURN BOOLEAN ;
87 FUNCTION GET_ACCTG_DATE RETURN BOOLEAN ;
88 function AfterPForm return boolean ;
89 --FUNCTION GET_ACCRUAL_BAS ;
90 FUNCTION GET_ACCRUAL_BASIS return boolean;
91 FUNCTION get_filtered_dates RETURN BOOLEAN ;
92 function g_1_orgsgroupfilter(CO_org_id in number) return boolean ;
93 Function C_NLS_YES_p return varchar2;
94 Function C_NLS_NO_p return varchar2;
95 Function C_NLS_ALL_p return varchar2;
96 Function C_NLS_NO_DATA_EXISTS_p return varchar2;
97 Function C_NLS_VOID_p return varchar2;
98 Function C_NLS_NA_p return varchar2;
99 Function C_NLS_END_OF_REPORT_p return varchar2;
100 Function C_REPORT_START_DATE_p return date;
101 Function C_COMPANY_NAME_HEADER_p return varchar2;
102 Function C_BASE_CURRENCY_CODE_p return varchar2;
103 Function C_BASE_PRECISION_p return number;
104 Function C_BASE_MIN_ACCT_UNIT_p return number;
105 Function C_BASE_DESCRIPTION_p return varchar2;
106 Function C_CHART_OF_ACCOUNTS_ID_p return number;
107 --Function Applications Template Report_p return varchar2;
108 Function Applications_Template_Report_p return varchar2;
109 Function C_AIP_MULTI_ORG_WHERE_p return varchar2;
110 Function C_APH_MULTI_ORG_WHERE_p return varchar2;
111 Function C_PMTS_MULTI_ORG_WHERE_p return varchar2;
112 Function C_INV_MULTI_ORG_WHERE_p return varchar2;
113 Function C_ORG_FROM_TABLES_p return varchar2;
114 Function C_SELECT_LE_p return varchar2;
115 Function C_SELECT_OU_p return varchar2;
116 Function C_REP_TITLE_p return varchar2;
117 Function C_SWEEP_TO_DATE_p return date;
118 Function C_ACCRUAL_BASIS_IN_USE_p return varchar2;
119 Function C_FROM_ACCTG_DATE_p return date;
120 Function C_TO_ACCTG_DATE_p return date;
121 Function C_APH_ACCTG_DATE_p return varchar2;
122 Function C_SWEEP_NOW_p return varchar2;
123 Function C_DATE_FILTER_INV_p return varchar2;
124 Function C_DATE_FILTER_PAY_p return varchar2;
125 Function C_DATE_FILTER_PAYHIST_p return varchar2;
126 Function C_LEDGER_PARTIAL_OU_p return varchar2;
127 function M_G_4_FUTURE_PAY_GRPFRFormatTr(co_org_id number) return varchar2;
128 function M_G_5_PAY_BATCH_GRPFRFormatTri(co_org_id number) return varchar2;
129 function M_G_6_UNTRANS_ACCT_GRPFRFormat(co_org_id number) return varchar2;
130 function M_G_3_UNACCT_PAY_GRPFRFormatTr(co_org_id number) return varchar2;
131 function M_G_2_UNACCT_INV_GRPFRFormatTr(co_org_id number) return varchar2;
132 function F_END_OF_REPORT1FormatTrigger return number;
133 END AP_APXTRSWP_XMLP_PKG;
134
135