PACKAGE: APPS.BOM_CSTRPDSS_XMLP_PKG

Source

1 PACKAGE BOM_CSTRPDSS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRPDSSS.pls 120.0 2007/12/24 10:12:42 dwkrishn noship $ */
3   P_ACCT_TO VARCHAR2(900);
4 
5   P_ACCT_FROM VARCHAR2(900);
6 
7   P_SORT_ID NUMBER;
8 
9   PLEX_ACCOUNT_WHERE VARCHAR2(2000);
10 
11   P_ITEM_STRUCT_NUM NUMBER;
12 
13   PLEX_ACCOUNT_FLEX VARCHAR2(2000);
14 
15   PLEX_ITEM_FLEX VARCHAR2(2000) := ' ';
16 
17   P_CONC_REQUEST_ID NUMBER;
18 
19   P_WIP NUMBER;
20 
21   P_COST_GROUP_ID NUMBER;
22 
23   P_COST_TYPE_ID NUMBER;
24 
25   P_PERIOD_ID NUMBER;
26 
27   P_GL_STRUCT_NUM NUMBER;
28 
29   P_SORT_OPTION VARCHAR2(2000) := '(TO_CHAR(3))';
30 
31   P_MAT_TABLE_FROM VARCHAR2(200);
32 
33   P_MAT_WHERE VARCHAR2(300) := ' ';
34 
35   P_RCV_TABLE_FROM VARCHAR2(200);
36 
37   P_RCV_WHERE VARCHAR2(300);
38 
39   P_QUANTITY_PRECISION NUMBER;
40 
41   CP_RESPONSIBILITY VARCHAR2(200);
42 
43   CP_REQUEST_TIME VARCHAR2(30);
44 
45   CP_APPLICATION VARCHAR2(240);
46 
47   CP_REQUESTED_BY VARCHAR2(100);
48 
49   CP_LEGAL_ENTITY VARCHAR2(240);
50 
51   CP_ACCT_ID NUMBER;
52 
53   CP_COST_GROUP VARCHAR2(32767);
54 
55   CP_COST_TYPE VARCHAR2(32767);
56 
57   R_CURRENCY_CODE VARCHAR2(17);
58 
59   CP_PERIOD_NAME VARCHAR2(15);
60 
61   CP_PRECISION NUMBER;
62 
63   QTY_PRECISION varchar2(50);
64 
65   FUNCTION BEFOREREPORT RETURN BOOLEAN;
66 
67   FUNCTION C_item(C_item_field_p varchar2) RETURN varchar2;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70 
71   FUNCTION C_ACCT_PADFORMULA(C_ACCT_PAD IN VARCHAR2) RETURN VARCHAR2;
72 
73   FUNCTION AFTERPFORM RETURN BOOLEAN;
74 
75   --PROCEDURE FORMAT_QUANTITY(P_PRECISION IN NUMBER);
76 
77   FUNCTION CF_NET_ACTIVITY_RFORMULA(NET_ACTIVITY IN NUMBER) RETURN NUMBER;
78 
79   FUNCTION CF_SUM_CREDITS_RFORMULA(SUM_CREDITS IN NUMBER) RETURN NUMBER;
80 
81   FUNCTION CF_SUM_DEBITS_RFORMULA(SUM_DEBITS IN NUMBER) RETURN NUMBER;
82 
83   FUNCTION CF_ACCT_TOT_RFORMULA(C_ACCT_TOT IN NUMBER) RETURN NUMBER;
84 
85   FUNCTION CF_CR_ACCT_TOT_RFORMULA(C_CR_ACCT_TOT IN NUMBER) RETURN NUMBER;
86 
87   FUNCTION CF_DR_ACCT_TOT_RFORMULA(C_DR_ACCT_TOT IN NUMBER) RETURN NUMBER;
88 
89   FUNCTION CF_CR_TOT_RFORMULA(C_CR_TOT IN NUMBER) RETURN NUMBER;
90 
91   FUNCTION CF_DR_TOT_RFORMULA(C_DR_TOT IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION CF_REPORT_TOT_RFORMULA(C_REPORT_TOT IN NUMBER) RETURN NUMBER;
94 
95   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
96 
97   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
98 
99   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
100 
101   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
102 
103   FUNCTION CP_LEGAL_ENTITY_P RETURN VARCHAR2;
104 
105   FUNCTION CP_ACCT_ID_P RETURN NUMBER;
106 
107   FUNCTION CP_COST_GROUP_P RETURN VARCHAR2;
108 
109   FUNCTION CP_COST_TYPE_P RETURN VARCHAR2;
110 
111   FUNCTION R_CURRENCY_CODE_P RETURN VARCHAR2;
112 
113   FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
114 
115   FUNCTION CP_PRECISION_P RETURN NUMBER;
116 
117 END BOM_CSTRPDSS_XMLP_PKG;
118