PACKAGE: APPS.CSP_LOOP_CALC_RULES_B_PKG

Source

1 PACKAGE CSP_LOOP_CALC_RULES_B_PKG AUTHID CURRENT_USER as
2 /* $Header: csptpcrs.pls 115.6 2002/11/26 07:12:05 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_LOOP_CALC_RULES_B_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_CALCULATION_RULE_ID  IN OUT NOCOPY NUMBER,
12           p_CREATED_BY    NUMBER,
13           p_CREATION_DATE    DATE,
14           p_LAST_UPDATED_BY    NUMBER,
15           p_LAST_UPDATE_DATE    DATE,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_CALCULATION_RULE_NAME    VARCHAR2,
18           p_INCLUDE_SALES_ORDERS    VARCHAR2,
19           p_INCLUDE_MOVE_ORDERS    VARCHAR2,
20           p_INCLUDE_REPAIR_ORDERS    VARCHAR2,
21           p_INCLUDE_WORK_ORDERS    VARCHAR2,
22           p_INCLUDE_PURCHASE_ORDERS    VARCHAR2,
23           p_INCLUDE_REQUISITIONS    VARCHAR2,
24           p_INCLUDE_INTERORG_TRANSFERS    VARCHAR2,
25           p_INCLUDE_ONHAND_GOOD    VARCHAR2,
26           p_INCLUDE_ONHAND_BAD    VARCHAR2,
27           p_INCLUDE_INTRANSIT_MOVE_ORD    VARCHAR2,
28           p_TOLERANCE_PERCENT    NUMBER,
29           p_TIME_FENCE    NUMBER,
30 		p_INCLUDE_DOA	VARCHAR2,
31 		p_ROLLUP_SUPERCESSION VARCHAR2,
32 		p_FORECAST_LOWER_SUPERCESSION VARCHAR2,
33           p_ATTRIBUTE_CATEGORY    VARCHAR2,
34           p_ATTRIBUTE1    VARCHAR2,
35           p_ATTRIBUTE2    VARCHAR2,
36           p_ATTRIBUTE3    VARCHAR2,
37           p_ATTRIBUTE4    VARCHAR2,
38           p_ATTRIBUTE5    VARCHAR2,
39           p_ATTRIBUTE6    VARCHAR2,
40           p_ATTRIBUTE7    VARCHAR2,
41           p_ATTRIBUTE8    VARCHAR2,
42           p_ATTRIBUTE9    VARCHAR2,
43           p_ATTRIBUTE10    VARCHAR2,
44           p_ATTRIBUTE11    VARCHAR2,
45           p_ATTRIBUTE12    VARCHAR2,
46           p_ATTRIBUTE13    VARCHAR2,
47           p_ATTRIBUTE14    VARCHAR2,
48           p_ATTRIBUTE15    VARCHAR2,
49           p_DESCRIPTION    VARCHAR2 );
50 
51 
52 PROCEDURE Update_Row(
53           p_CALCULATION_RULE_ID    NUMBER,
54           p_CREATED_BY    NUMBER,
55           p_CREATION_DATE    DATE,
56           p_LAST_UPDATED_BY    NUMBER,
57           p_LAST_UPDATE_DATE    DATE,
58           p_LAST_UPDATE_LOGIN    NUMBER,
59           p_CALCULATION_RULE_NAME    VARCHAR2,
60           p_INCLUDE_SALES_ORDERS    VARCHAR2,
61           p_INCLUDE_MOVE_ORDERS    VARCHAR2,
62           p_INCLUDE_REPAIR_ORDERS    VARCHAR2,
63           p_INCLUDE_WORK_ORDERS    VARCHAR2,
64           p_INCLUDE_PURCHASE_ORDERS    VARCHAR2,
65           p_INCLUDE_REQUISITIONS    VARCHAR2,
66           p_INCLUDE_INTERORG_TRANSFERS    VARCHAR2,
67           p_INCLUDE_ONHAND_GOOD    VARCHAR2,
68           p_INCLUDE_ONHAND_BAD    VARCHAR2,
69           p_INCLUDE_INTRANSIT_MOVE_ORD    VARCHAR2,
70           p_TOLERANCE_PERCENT    NUMBER,
71           p_TIME_FENCE    NUMBER,
72 		p_INCLUDE_DOA	VARCHAR2,
73 		p_ROLLUP_SUPERCESSION VARCHAR2,
74 		p_FORECAST_LOWER_SUPERCESSION VARCHAR2,
75           p_ATTRIBUTE_CATEGORY    VARCHAR2,
76           p_ATTRIBUTE1    VARCHAR2,
77           p_ATTRIBUTE2    VARCHAR2,
78           p_ATTRIBUTE3    VARCHAR2,
79           p_ATTRIBUTE4    VARCHAR2,
80           p_ATTRIBUTE5    VARCHAR2,
81           p_ATTRIBUTE6    VARCHAR2,
82           p_ATTRIBUTE7    VARCHAR2,
83           p_ATTRIBUTE8    VARCHAR2,
84           p_ATTRIBUTE9    VARCHAR2,
85           p_ATTRIBUTE10    VARCHAR2,
86           p_ATTRIBUTE11    VARCHAR2,
87           p_ATTRIBUTE12    VARCHAR2,
88           p_ATTRIBUTE13    VARCHAR2,
89           p_ATTRIBUTE14    VARCHAR2,
90           p_ATTRIBUTE15    VARCHAR2,
91           p_DESCRIPTION    VARCHAR2 );
92 
93 PROCEDURE Lock_Row(
94           p_CALCULATION_RULE_ID    NUMBER,
95           p_CREATED_BY    NUMBER,
96           p_CREATION_DATE    DATE,
97           p_LAST_UPDATED_BY    NUMBER,
98           p_LAST_UPDATE_DATE    DATE,
99           p_LAST_UPDATE_LOGIN    NUMBER,
100           p_CALCULATION_RULE_NAME    VARCHAR2,
101           p_INCLUDE_SALES_ORDERS    VARCHAR2,
102           p_INCLUDE_MOVE_ORDERS    VARCHAR2,
103           p_INCLUDE_REPAIR_ORDERS    VARCHAR2,
104           p_INCLUDE_WORK_ORDERS    VARCHAR2,
105           p_INCLUDE_PURCHASE_ORDERS    VARCHAR2,
106           p_INCLUDE_REQUISITIONS    VARCHAR2,
107           p_INCLUDE_INTERORG_TRANSFERS    VARCHAR2,
108           p_INCLUDE_ONHAND_GOOD    VARCHAR2,
109           p_INCLUDE_ONHAND_BAD    VARCHAR2,
110           p_INCLUDE_INTRANSIT_MOVE_ORD  VARCHAR2,
111           p_TOLERANCE_PERCENT    NUMBER,
112           p_TIME_FENCE    NUMBER,
113 		p_INCLUDE_DOA	VARCHAR2,
114 		p_ROLLUP_SUPERCESSION VARCHAR2,
115 		p_FORECAST_LOWER_SUPERCESSION VARCHAR2,
116           p_ATTRIBUTE_CATEGORY    VARCHAR2,
117           p_ATTRIBUTE1    VARCHAR2,
118           p_ATTRIBUTE2    VARCHAR2,
119           p_ATTRIBUTE3    VARCHAR2,
120           p_ATTRIBUTE4    VARCHAR2,
121           p_ATTRIBUTE5    VARCHAR2,
122           p_ATTRIBUTE6    VARCHAR2,
123           p_ATTRIBUTE7    VARCHAR2,
124           p_ATTRIBUTE8    VARCHAR2,
125           p_ATTRIBUTE9    VARCHAR2,
126           p_ATTRIBUTE10    VARCHAR2,
127           p_ATTRIBUTE11    VARCHAR2,
128           p_ATTRIBUTE12    VARCHAR2,
129           p_ATTRIBUTE13    VARCHAR2,
130           p_ATTRIBUTE14    VARCHAR2,
131           p_ATTRIBUTE15    VARCHAR2,
132           p_DESCRIPTION    VARCHAR2 );
133 
134 PROCEDURE Delete_Row(
135     p_CALCULATION_RULE_ID  NUMBER);
136 
137 procedure ADD_LANGUAGE;
138 
139 PROCEDURE Translate_Row
140 ( p_calculation_rule_id IN  NUMBER
141 , p_description  	  IN  VARCHAR2
142 , p_owner             IN VARCHAR2
143 );
144 
145 PROCEDURE Load_Row
146 ( p_calculation_rule_id IN  NUMBER
147 , p_description  	  IN  VARCHAR2
148 , p_owner             IN VARCHAR2
149 );
150 End CSP_LOOP_CALC_RULES_B_PKG;
151