[Home] [Help]
PACKAGE: APPS.BOM_CSTRPDSS_XMLP_PKG
Source
1 PACKAGE BOM_CSTRPDSS_XMLP_PKG 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