DBA Data[Home] [Help]

PACKAGE: APPS.BOM_CSTRPCRE_XMLP_PKG

Source


1 PACKAGE BOM_CSTRPCRE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRPCRES.pls 120.1 2010/11/25 22:35:48 mpuranik ship $ */
3   P_REPORT_TYPE NUMBER;
4 
5   P_ORG_ID NUMBER;
6 
7   P_GL_NUM NUMBER;
8 
9   P_SORT_OPTION NUMBER;
10 
11   P_PERIOD_ID NUMBER;
12 
13   P_TO_DATE VARCHAR2(32767);
14   P_TO_DATE1 VARCHAR2(32767);
15   P_CG_FROM VARCHAR2(32767);
16 
17   P_CG_TO VARCHAR2(32767);
18 
19   P_SUB_FROM VARCHAR2(32767);
20 
21   P_SUB_TO VARCHAR2(32767);
22 
23   P_ITEM_FROM VARCHAR2(820);
24 
25   P_ITEM_TO VARCHAR2(820);
26 
27   P_CURRENCY_CODE VARCHAR2(32767);
28 
29   P_RATE_TYPE NUMBER;
30 
31   P_EXCHANGE_RATE_CHAR VARCHAR2(32767);
32 
33   P_ORG_NAME VARCHAR2(240);
34 
35   P_EXCHANGE_RATE NUMBER;
36 
37   P_CURRENCY_DSP VARCHAR2(40);
38 
39   P_ROUND_UNIT NUMBER:=1;
40 
41   P_ITEM_SEG VARCHAR2(2400);
42 
43   P_SORT_TEXT VARCHAR2(50);
44 
45   P_FROM_DATE DATE;
46 
47   P_CPCS_WHERE VARCHAR2(200) := '1 = 1';
48 
49   P_SOURCE_TABLE VARCHAR2(30) := 'cst_period_close_summary';
50 
51   P_TRACE VARCHAR2(1);
52 
53   P_SIMULATION VARCHAR2(1) := 'N';
54 
55   P_CG_SORT_TEXT VARCHAR2(40):= ' ';
56   P_SUB_SORT_TEXT VARCHAR2(40):= ' ';
57 
58   PV_SORT_OPTION VARCHAR2(80);
59   PV_REPORT_TYPE VARCHAR2(80);
60 
61   P_PERIOD_NAME VARCHAR2(15);
62 
63   P_CONC_REQUEST_ID NUMBER := 0;
64 
65   P_NULLSUB VARCHAR2(40);
66 
67   FUNCTION AFTERPFORM RETURN BOOLEAN;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70   FUNCTION BeforeReport RETURN BOOLEAN;
71 
72 END BOM_CSTRPCRE_XMLP_PKG;
73