eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AR_ARXPIREP_XMLP_PKG

Source


1 PACKAGE AR_ARXPIREP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXPIREPS.pls 120.0 2007/12/27 14:01:31 abraghun noship $ */
3   P_REQUEST_ID NUMBER;
4   P_SOB_ID NUMBER;
5   P_BAL_LOW VARCHAR2(30);
6   P_BAL_HIGH VARCHAR2(30);
7   P_POSTED_LOW DATE;
8   P_POSTED_HIGH DATE;
9   P_POSTED_FLAG VARCHAR2(30);
10   P_LOW_DATE DATE;
11   P_HIGH_DATE DATE;
12   P_CURRENCY_CODE VARCHAR2(30);
13   P_MIN_PRECISION NUMBER;
14   LP_BAL_LOW VARCHAR2(200);
15   LP_BAL_HIGH VARCHAR2(200);
16   LP_CURRENCY_CODE VARCHAR2(200);
17   P_COAID NUMBER;
18   LP_BAL_LOW1 VARCHAR2(2000);
19   LP_BAL_HIGH1 VARCHAR2(2000);
20   P_CA_SET_OF_BOOKS_ID NUMBER;
21   P_CA_ORG_ID NUMBER := -1;
22   P_MRCSOBTYPE VARCHAR2(32767) := 'P';
23   LP_AR_RECEIVABLE_APPS_ALL VARCHAR2(50) := 'ar_receivable_applications_all';
24   LP_AR_RECEIVABLE_APPS VARCHAR2(50) := 'ar_receivable_applications';
25   LP_AR_RATE_ADJUSTMENTS_ALL VARCHAR2(50) := 'ar_rate_adjustments_all';
26   LP_AR_RATE_ADJUSTMENTS VARCHAR2(50) := 'ar_rate_adjustments';
27   LP_AR_MISC_CASH_DISTS_ALL VARCHAR2(50) := 'ar_misc_cash_distributions_all';
28   LP_AR_MISC_CASH_DISTS VARCHAR2(50) := 'ar_misc_cash_distributions';
29   LP_RA_CUST_TRX_GL_DIST_ALL VARCHAR2(50) := 'ar_xla_ctlgd_lines_v';
30   LP_CUST_TRX_LINE_GL_DIST VARCHAR2(50) := 'ra_cust_trx_line_gl_dist';
31   LP_RA_BATCHES_ALL VARCHAR2(50) := 'ra_batches_all';
32   LP_RA_BATCHES VARCHAR2(50) := 'ra_batches';
33   LP_RA_CUSTOMER_TRX_ALL VARCHAR2(50) := 'ra_customer_trx_all';
34   LP_RA_CUSTOMER_TRX VARCHAR2(50) := 'ra_customer_trx';
35   LP_AR_DISTRIBUTIONS_ALL VARCHAR2(50) := 'ar_xla_ard_lines_v';
36   LP_AR_DISTRIBUTIONS VARCHAR2(50) := 'ar_xla_ard_lines_v';
37   LP_AR_CASH_RECEIPTS_ALL VARCHAR2(50) := 'ar_cash_receipts_all';
38   LP_AR_CASH_RECEIPTS VARCHAR2(50) := 'ar_cash_receipts';
39   LP_AR_BATCHES_ALL VARCHAR2(50) := 'ar_batches_all';
40   LP_AR_BATCHES VARCHAR2(50) := 'ar_batches';
41   LP_AR_CASH_RECEIPT_HISTORY_ALL VARCHAR2(50) := 'ar_cash_receipt_history_all';
42   LP_AR_CASH_RECEIPT_HISTORY VARCHAR2(50) := 'ar_cash_receipt_history';
43   LP_AR_ADJUSTMENTS_ALL VARCHAR2(50) := 'ar_adjustments_all';
44   LP_AR_ADJUSTMENTS VARCHAR2(50) := 'ar_adjustments';
45   LP_AR_PAYMENT_SCHEDULES_ALL VARCHAR2(50) := 'ar_payment_schedules_all';
46   LP_AR_PAYMENT_SCHEDULES VARCHAR2(50) := 'lp_ar_payment_schedules';
47   LP_AR_SYSTEM_PARAMETERS_ALL VARCHAR2(50) := 'ar_system_parameters_all';
48   LP_AR_SYSTEM_PARAMETERS VARCHAR2(50) := 'ar_system_parameters';
49   LP_RA_CUST_TRX_GL_DIST VARCHAR2(50) := 'ar_xla_ctlgd_lines_v';
50   LP_AR_TRANSACTION_HISTORY_ALL VARCHAR2(50) := 'ar_transaction_history';
51   LP_AR_TRANSACTION_HISTORY VARCHAR2(50) := 'ar_transaction_history';
52   LP_HZ_CUST_ACCOUNTS_ALL VARCHAR2(50) := 'hz_cust_Accounts_all';
53   LP_HZ_CUST_ACCOUNTS VARCHAR2(50) := 'hz_cust_Accounts';
54   LP_RA_CUST_TRX_TYPES VARCHAR2(50) :='ra_cust_trx_types';
55   LP_RA_CUST_TRX_TYPES_ALL VARCHAR2(50) :='ra_cust_trx_types_all';
56   P_ORG_WHERE_CT VARCHAR2(2000);
57   P_ORG_WHERE_CTT VARCHAR2(2000);
58   P_ORG_WHERE_ARD VARCHAR2(2000);
59   P_ORG_WHERE_ACCT VARCHAR2(2000);
60   P_ORG_WHERE_ADJ VARCHAR2(2000);
61   P_ORG_WHERE_GLDIST VARCHAR2(2000);
62   P_ORG_WHERE_CR VARCHAR2(2000);
63   P_ORG_WHERE_CRH VARCHAR2(2000);
64   P_ORG_WHERE_RA VARCHAR2(2000);
65   P_ORG_WHERE_CTINV VARCHAR2(2000);
66   P_ORG_WHERE_MCD VARCHAR2(2000);
67   P_ORG_WHERE_TH VARCHAR2(2000);
68   P_REPORTING_ENTITY_ID NUMBER;
69   P_REPORTING_ENTITY_NAME VARCHAR2(200);
70   P_REPORTING_LEVEL VARCHAR2(30);
71   P_REPORTING_LEVEL_NAME VARCHAR2(80);
72   P_CONC_REQUEST_ID NUMBER;
73   LP_ADJ_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
74   LP_CB_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
75   LP_CM_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
76   LP_DM_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
77   LP_INV_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
78   LP_MISC_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
79   LP_TRADE_SELECT VARCHAR2(2000) := 'select ''xxx'' JOURNAL_CATEGORY, ''Y'' ASSET_TYPE, ''Y'' LIABILITY_TYPE, ''Y'' EXPENSE_TYPE, ''Y'' REVENUE_TYPE from dual';
80   ACCT_BAL_APROMPT VARCHAR2(80);
81   REF_CURR_CODE VARCHAR2(32767);
82   SUM_SP_ENT_CR_DBC NUMBER;
83   SUM_SP_ACCT_DR_DBC NUMBER;
84   SUM_SP_ACCT_CR_DBC NUMBER;
85   TMP_ENT_CR_DBC NUMBER;
86   TMP_ACCT_DR_DBC NUMBER;
87   TMP_ACCT_CR_DBC NUMBER;
88   TMP_ENT_DR_DBC NUMBER;
89   SUM_SP_ENT_DR_DBC NUMBER;
90   D_GSUM_ENT_CR_DBC VARCHAR2(20);
91   RP_COMPANY_NAME VARCHAR2(50);
92   RP_REPORT_NAME VARCHAR2(240);
93   RP_DATA_FOUND VARCHAR2(100);
94   RP_POSTED_HDR VARCHAR2(500);
95   RP_GL_HDR VARCHAR2(260);
96   D_GSUM_ENT_DR_DBC VARCHAR2(20);
97   D_GSUM_ACCT_DR_DBC VARCHAR2(20);
98   D_GSUM_ACCT_CR_DBC VARCHAR2(20);
99   C_FLEX_SBC VARCHAR2(500);
100   FUNCTIONAL_CURRENCY VARCHAR2(15);
101   C_CURRENCY_CODE_DBC VARCHAR2(15);
102   C_CURRENCY_CODE_SBC VARCHAR2(15);
103   C_POSTED_DESC VARCHAR2(100);
104   C_INDUSTRY_CODE VARCHAR2(20);
105   C_SALES_TITLE VARCHAR2(20);
106   PL_POSTED_DATE_FROM_TO VARCHAR2(260);
107   RP_REPORT_SUBNAME VARCHAR2(80);
108   PL_GL_DATE_FROM_TO VARCHAR2(240);
109   RP_MESSAGE VARCHAR2(2000);
110   CP_ACC_MESSAGE VARCHAR2(2000);
111   FUNCTION BEFOREREPORT RETURN BOOLEAN;
112   FUNCTION AFTERREPORT RETURN BOOLEAN;
113   FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
114   FUNCTION C_POSTED_DESCRIPTIONFORMULA RETURN VARCHAR2;
115   FUNCTION C_DELIMFORMULA(COA_ID IN NUMBER) RETURN VARCHAR2;
116   FUNCTION C_BAL_VS_IDFORMULA(COA_ID IN NUMBER
117                              ,ACCT_FLEX_BAL_SEG IN VARCHAR2) RETURN NUMBER;
118   FUNCTION GL_HDRFORMULA RETURN VARCHAR2;
119   FUNCTION SET_SUM_SPFORMULA(ENTERED_DR_DBC IN NUMBER
120                             ,ENTERED_CR_DBC IN NUMBER
121                             ,ACCOUNTED_DR_DBC IN NUMBER
122                             ,ACCOUNTED_CR_DBC IN NUMBER
123                             ,CATEGORY_CODE_DBC IN VARCHAR2) RETURN NUMBER;
124   FUNCTION AFTERPFORM RETURN BOOLEAN;
125   FUNCTION C_CURRENCY_CODEFORMULA RETURN VARCHAR2;
126   FUNCTION SET_FUNC_CURRFORMULA(C_FUNCTIONAL_CURRENCY IN VARCHAR2) RETURN VARCHAR2;
127   FUNCTION SET_CURR_CODE_DBCFORMULA(CURRENCY_CODE_DBC IN VARCHAR2) RETURN VARCHAR2;
128   PROCEDURE GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
129                               ,P_LOOKUP_CODE IN VARCHAR2
130                               ,P_LOOKUP_MEANING IN OUT NOCOPY VARCHAR2);
131   --PROCEDURE GET_BOILER_PLATES;
132   FUNCTION SET_DISPLAY_FOR_CORE(P_FIELD_NAME IN VARCHAR2) RETURN BOOLEAN;
133   FUNCTION SET_DISPLAY_FOR_GOV(P_FIELD_NAME IN VARCHAR2) RETURN BOOLEAN;
134   FUNCTION POSTED_HDRFORMULA RETURN VARCHAR2;
135   FUNCTION POSTED_YES_NOFORMULA(POSTING_CONTROL_ID IN NUMBER) RETURN VARCHAR2;
136   FUNCTION BEFOREPFORM RETURN BOOLEAN;
137   FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
138   FUNCTION REF_CURR_CODE_P RETURN VARCHAR2;
139   FUNCTION SUM_SP_ENT_CR_DBC_P RETURN NUMBER;
140   FUNCTION SUM_SP_ACCT_DR_DBC_P RETURN NUMBER;
141   FUNCTION SUM_SP_ACCT_CR_DBC_P RETURN NUMBER;
142   FUNCTION TMP_ENT_CR_DBC_P RETURN NUMBER;
143   FUNCTION TMP_ACCT_DR_DBC_P RETURN NUMBER;
144   FUNCTION TMP_ACCT_CR_DBC_P RETURN NUMBER;
145   FUNCTION TMP_ENT_DR_DBC_P RETURN NUMBER;
146   FUNCTION SUM_SP_ENT_DR_DBC_P RETURN NUMBER;
147   FUNCTION D_GSUM_ENT_CR_DBC_P RETURN VARCHAR2;
148   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
149   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
150   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
151   FUNCTION RP_POSTED_HDR_P RETURN VARCHAR2;
152   FUNCTION RP_GL_HDR_P RETURN VARCHAR2;
153   FUNCTION D_GSUM_ENT_DR_DBC_P RETURN VARCHAR2;
154   FUNCTION D_GSUM_ACCT_DR_DBC_P RETURN VARCHAR2;
155   FUNCTION D_GSUM_ACCT_CR_DBC_P RETURN VARCHAR2;
156   FUNCTION C_FLEX_SBC_P RETURN VARCHAR2;
157   FUNCTION FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
158   FUNCTION C_CURRENCY_CODE_DBC_P RETURN VARCHAR2;
159   FUNCTION C_CURRENCY_CODE_SBC_P RETURN VARCHAR2;
160   FUNCTION C_POSTED_DESC_P RETURN VARCHAR2;
161   FUNCTION C_INDUSTRY_CODE_P RETURN VARCHAR2;
162   FUNCTION C_SALES_TITLE_P RETURN VARCHAR2;
163   FUNCTION PL_POSTED_DATE_FROM_TO_P RETURN VARCHAR2;
164   FUNCTION RP_REPORT_SUBNAME_P RETURN VARCHAR2;
165   FUNCTION PL_GL_DATE_FROM_TO_P RETURN VARCHAR2;
166   FUNCTION RP_MESSAGE_P RETURN VARCHAR2;
167   FUNCTION CP_ACC_MESSAGE_P RETURN VARCHAR2;
168  /*  FUNCTION GET(APPL_ID IN INTEGER
169               ,DEP_APPL_ID IN INTEGER
170               ,STATUS OUT NOCOPY VARCHAR2
171               ,INDUSTRY OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
172  FUNCTION GET_APP_INFO(APPLICATION_SHORT_NAME IN VARCHAR2
173                        ,STATUS OUT NOCOPY VARCHAR2
174                        ,INDUSTRY OUT NOCOPY VARCHAR2
175                        ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
176   FUNCTION GET_APP_INFO_OTHER(APPLICATION_SHORT_NAME IN VARCHAR2
177                              ,TARGET_SCHEMA IN VARCHAR2
178                              ,STATUS OUT NOCOPY VARCHAR2
179                              ,INDUSTRY OUT NOCOPY VARCHAR2
180                              ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;*/
181 END AR_ARXPIREP_XMLP_PKG;
182