PACKAGE: APPS.BOM_CSTRPWDD_XMLP_PKG

Source

1 PACKAGE BOM_CSTRPWDD_XMLP_PKG AS
2 /* $Header: CSTRPWDDS.pls 120.0 2007/12/24 10:15:25 dwkrishn noship $ */
3   P_STRUCT_NUM VARCHAR2(15);
4 
5   P_CLASS_CODE VARCHAR2(10);
6 
7   P_ASSEMBLY_ID NUMBER;
8 
9   P_CURRENCY_CODE VARCHAR2(15);
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13   P_FLEXDATA VARCHAR2(850);
14 
15   P_ASSY_FLEX VARCHAR2(850);
16 
17   P_QUANTITY_PRECISION NUMBER;
18 
19   P_DEPARTMENT NUMBER;
20 
21   P_LINE NUMBER;
22 
23   P_TRANS_TYPE NUMBER;
24 
25   P_ACTIVITY NUMBER;
26 
27   P_DEBUG NUMBER;
28 
29   P_LIMIT_ENTITY VARCHAR2(900) := '1=1';
30 
31   P_EXCHANGE_RATE NUMBER;
32 
33   P_CURRENCY_PRECISION NUMBER;
34 
35   P_RATE_PRECISION NUMBER;
36 
37   P_COST_GROUP_ID NUMBER;
38 
39   P_COST_TYPE_ID NUMBER;
40 
41   P_PERIOD_ID NUMBER;
42 
43   P_ACCT_HI VARCHAR2(900);
44 
45   P_ACCT_LO VARCHAR2(900);
46 
47   P_WHERE_ACCT VARCHAR2(900);
48 
49   P_LIMIT_CLASSES VARCHAR2(900) := '1=1';
50 
51   P_JOB NUMBER;
52 
53   CP_RESPONSIBILITY VARCHAR2(220);
54 
55   CP_REQUEST_TIME VARCHAR2(50);
56 
57   CP_APPLICATION VARCHAR2(300);
58 
59   CP_REQUESTED_BY VARCHAR2(120);
60 
61   CP_LEGAL_ENTITY VARCHAR2(80);
62 
63   CP_COST_GROUP VARCHAR2(20);
64 
65   CP_COST_TYPE VARCHAR2(20);
66 
67   CP_WIP_ENTITY_NAME_COV VARCHAR2(300);
68 
69   CP_LINE_CODE_COV VARCHAR2(20);
70 
71   CP_TXN_TYPE_COV VARCHAR2(100);
72 
73   CP_DEPARTMENT_CODE_COV VARCHAR2(20);
74 
75   CP_ACTIVITY_COV VARCHAR2(25);
76 
77   CP_PERIOD_NAME VARCHAR2(25);
78 
79   FUNCTION BEFOREREPORT RETURN BOOLEAN;
80 
81   FUNCTION AFTERREPORT RETURN BOOLEAN;
82 
83   FUNCTION C_SUBTITLE_CURRENCYFORMULA RETURN VARCHAR2;
84 
85   FUNCTION C_ACCT_DESCRIPFORMULA(C_FLEXDATA IN VARCHAR2
86                                 ,ACCOUNT IN VARCHAR2
87                                 ,C_ACCT_DESCRIP IN VARCHAR2) RETURN VARCHAR2;
88 
89   FUNCTION C_FLEX_SORTFORMULA(C_FLEXDATA IN VARCHAR2
90                              ,ACCOUNT IN VARCHAR2
91                              ,C_FLEX_SORT IN VARCHAR2) RETURN VARCHAR2;
92 
93   --PROCEDURE FORMAT_QUANTITY(P_PRECISION IN NUMBER);
94 
95   FUNCTION CLASS(R_CLASS IN VARCHAR2
96                 ,D_CLASS IN VARCHAR2) RETURN CHARACTER;
97 
98   FUNCTION C_ACCT_TOTAL_RFORMULA(C_ACCT_TOTAL IN NUMBER) RETURN NUMBER;
99 
100   FUNCTION C_JOB_TOTAL_RFORMULA(C_JOB_TOTAL IN NUMBER) RETURN NUMBER;
101 
102   FUNCTION C_EXT_COST_RFORMULA(EXTENDED_COST IN NUMBER) RETURN NUMBER;
103 
104   FUNCTION C_REPT_TOTAL_RFORMULA(C_REPT_TOTAL IN NUMBER) RETURN NUMBER;
105 
106   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
107 
108   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
109 
110   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
111 
112   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
113 
114   FUNCTION CP_LEGAL_ENTITY_P RETURN VARCHAR2;
115 
116   FUNCTION CP_COST_GROUP_P RETURN VARCHAR2;
117 
118   FUNCTION CP_COST_TYPE_P RETURN VARCHAR2;
119 
120   FUNCTION CP_WIP_ENTITY_NAME_COV_P RETURN VARCHAR2;
121 
122   FUNCTION CP_LINE_CODE_COV_P RETURN VARCHAR2;
123 
124   FUNCTION CP_TXN_TYPE_COV_P RETURN VARCHAR2;
125 
126   FUNCTION CP_DEPARTMENT_CODE_COV_P RETURN VARCHAR2;
127 
128   FUNCTION CP_ACTIVITY_COV_P RETURN VARCHAR2;
129 
130   FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
131 
132 END BOM_CSTRPWDD_XMLP_PKG;
133