eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CSP_SEC_INV_ACC_PKG dependencies on CSP_SEC_INVENTORIES

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_SEC_INVENTORIES');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_SEC_INV_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_SEC_INVENTORIES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSP_SEC_INVENTORIES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'CSP_SEC_INVENTORIES';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_SEC_INV_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_SEC_INVENTORIES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSP_SEC_INVENTORIES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level
12:

Line 22: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2

18: )
19: RETURN BOOLEAN
20: IS
21:
22: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
23: , b_organization_id NUMBER
24: ) IS
25: SELECT csi.secondary_inventory_id
26: FROM csp_sec_inventories csi

Line 26: FROM csp_sec_inventories csi

22: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
23: , b_organization_id NUMBER
24: ) IS
25: SELECT csi.secondary_inventory_id
26: FROM csp_sec_inventories csi
27: WHERE (csi.SECONDARY_INVENTORY_NAME = b_subinventory_code
28: AND csi.ORGANIZATION_ID = b_organization_id)
29: OR ( CONDITION_TYPE = 'B'
30: -- Bug 3724123

Line 33: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;

29: OR ( CONDITION_TYPE = 'B'
30: -- Bug 3724123
31: AND csi.ORGANIZATION_ID = JTM_HOOK_UTIL_PKG.Get_Profile_Value('CS_INV_VALIDATION_ORG',0));
32:
33: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;
34:
35: l_return_value BOOLEAN := FALSE;
36:
37: BEGIN

Line 50: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);

46: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
47: END IF;
48:
49: /*** Retreive record assigned by Hook ***/
50: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
51: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
52: IF c_csp_sec_inventories%NOTFOUND THEN
53: /*** could not find assignment record -> exit ***/
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 51: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

47: END IF;
48:
49: /*** Retreive record assigned by Hook ***/
50: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
51: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
52: IF c_csp_sec_inventories%NOTFOUND THEN
53: /*** could not find assignment record -> exit ***/
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
55: jtm_message_log_pkg.Log_Msg

Line 52: IF c_csp_sec_inventories%NOTFOUND THEN

48:
49: /*** Retreive record assigned by Hook ***/
50: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
51: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
52: IF c_csp_sec_inventories%NOTFOUND THEN
53: /*** could not find assignment record -> exit ***/
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
55: jtm_message_log_pkg.Log_Msg
56: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 65: CLOSE c_csp_sec_inventories;

61:
62: RETURN l_return_value;
63: END IF;
64:
65: CLOSE c_csp_sec_inventories;
66: ELSE
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 77: WHILE c_csp_sec_inventories%FOUND LOOP

73: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
74: END IF;
75:
76: /*** Loop over all available records and put them in the acc table ***/
77: WHILE c_csp_sec_inventories%FOUND LOOP
78: /*** Call common package to insert record into ACC table ***/
79: JTM_HOOK_UTIL_PKG.Insert_Acc
80: ( p_publication_item_names => g_publication_item_name
81: ,p_acc_table_name => g_acc_table_name

Line 83: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID

79: JTM_HOOK_UTIL_PKG.Insert_Acc
80: ( p_publication_item_names => g_publication_item_name
81: ,p_acc_table_name => g_acc_table_name
82: ,p_pk1_name => g_pk1_name
83: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID
84: ,p_resource_id => p_resource_id
85: );
86: CSL_MTL_SEC_INV_ACC_PKG.Insert_MTL_Sec_Inventory(p_resource_id, p_subinventory_code, p_organization_id);
87: CSL_MTL_ITEM_LOCATIONS_ACC_PKG.Insert_Item_Locs_By_Subinv

Line 93: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

89: , p_organization_id => p_organization_id
90: , p_resource_id => p_resource_id
91: );
92:
93: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
94: END LOOP;
95: l_return_value := TRUE;
96: END IF;
97:

Line 109: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2

105: p_subinventory_code IN VARCHAR2,
106: p_organization_id IN NUMBER
107: )
108: IS
109: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
110: , b_organization_id NUMBER
111: ) IS
112: SELECT csi.secondary_inventory_id
113: FROM csp_sec_inventories csi

Line 113: FROM csp_sec_inventories csi

109: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
110: , b_organization_id NUMBER
111: ) IS
112: SELECT csi.secondary_inventory_id
113: FROM csp_sec_inventories csi
114: WHERE (csi.SECONDARY_INVENTORY_NAME = b_subinventory_code
115: AND csi.ORGANIZATION_ID = b_organization_id)
116: OR ( CONDITION_TYPE = 'B'
117: -- Bug 3724123

Line 120: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;

116: OR ( CONDITION_TYPE = 'B'
117: -- Bug 3724123
118: AND csi.ORGANIZATION_ID = JTM_HOOK_UTIL_PKG.Get_Profile_Value('CS_INV_VALIDATION_ORG',0));
119:
120: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;
121:
122: l_acc_id NUMBER;
123:
124: BEGIN

Line 137: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);

133: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
134: END IF;
135:
136: /*** Retreive record assigned by Hook ***/
137: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
138: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
139: IF c_csp_sec_inventories%NOTFOUND THEN
140: /*** could not find assignment record -> exit ***/
141: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 138: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

134: END IF;
135:
136: /*** Retreive record assigned by Hook ***/
137: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
138: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
139: IF c_csp_sec_inventories%NOTFOUND THEN
140: /*** could not find assignment record -> exit ***/
141: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
142: jtm_message_log_pkg.Log_Msg

Line 139: IF c_csp_sec_inventories%NOTFOUND THEN

135:
136: /*** Retreive record assigned by Hook ***/
137: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
138: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
139: IF c_csp_sec_inventories%NOTFOUND THEN
140: /*** could not find assignment record -> exit ***/
141: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
142: jtm_message_log_pkg.Log_Msg
143: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 150: CLOSE c_csp_sec_inventories;

146: || p_organization_id || ' for resource id ' || p_resource_id
147: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
148: END IF;
149:
150: CLOSE c_csp_sec_inventories;
151: ELSE
152: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
153: jtm_message_log_pkg.Log_Msg
154: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 162: WHILE c_csp_sec_inventories%FOUND LOOP

158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
159: END IF;
160:
161: /*** Loop over all available records and put them in the acc table ***/
162: WHILE c_csp_sec_inventories%FOUND LOOP
163: /*** Call common package to insert record into ACC table ***/
164: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
165: ( P_ACC_TABLE_NAME => g_acc_table_name
166: ,P_PK1_NAME => g_pk1_name

Line 167: ,P_PK1_NUM_VALUE => r_csp_sec_inventories.SECONDARY_INVENTORY_ID

163: /*** Call common package to insert record into ACC table ***/
164: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
165: ( P_ACC_TABLE_NAME => g_acc_table_name
166: ,P_PK1_NAME => g_pk1_name
167: ,P_PK1_NUM_VALUE => r_csp_sec_inventories.SECONDARY_INVENTORY_ID
168: ,P_RESOURCE_ID => p_resource_id);
169:
170:
171: IF l_acc_id = -1 THEN

Line 177: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID

173: JTM_HOOK_UTIL_PKG.Insert_Acc
174: ( p_publication_item_names => g_publication_item_name
175: ,p_acc_table_name => g_acc_table_name
176: ,p_pk1_name => g_pk1_name
177: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID
178: ,p_resource_id => p_resource_id
179: );
180:
181: CSL_MTL_SEC_INV_ACC_PKG.Insert_MTL_Sec_Inventory(p_resource_id, p_subinventory_code, p_organization_id);

Line 201: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

197: CSL_MTL_SEC_INV_ACC_PKG.Update_MTL_Sec_Inventory(p_resource_id, p_subinventory_code, p_organization_id);
198: END IF;
199:
200:
201: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
202: END LOOP;
203: /*** Succesfull looped through recordset ***/
204:
205: END IF;

Line 227: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2

223: )
224: RETURN BOOLEAN
225: IS
226:
227: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
228: , b_organization_id NUMBER
229: ) IS
230: SELECT csi.secondary_inventory_id
231: FROM csp_sec_inventories csi

Line 231: FROM csp_sec_inventories csi

227: CURSOR c_csp_sec_inventories( b_subinventory_code VARCHAR2
228: , b_organization_id NUMBER
229: ) IS
230: SELECT csi.secondary_inventory_id
231: FROM csp_sec_inventories csi
232: WHERE (csi.SECONDARY_INVENTORY_NAME = b_subinventory_code
233: AND csi.ORGANIZATION_ID = b_organization_id)
234: OR ( CONDITION_TYPE = 'B'
235: -- Bug 3724123

Line 238: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;

234: OR ( CONDITION_TYPE = 'B'
235: -- Bug 3724123
236: AND csi.ORGANIZATION_ID = JTM_HOOK_UTIL_PKG.Get_Profile_Value('CS_INV_VALIDATION_ORG',0));
237:
238: r_csp_sec_inventories c_csp_sec_inventories%ROWTYPE;
239:
240: l_return_value BOOLEAN := FALSE;
241:
242: BEGIN

Line 255: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);

251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
252: END IF;
253:
254: /*** Retreive record assigned by Hook ***/
255: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
256: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
257: IF c_csp_sec_inventories%NOTFOUND THEN
258: /*** could not find assignment record -> exit ***/
259: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 256: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

252: END IF;
253:
254: /*** Retreive record assigned by Hook ***/
255: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
256: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
257: IF c_csp_sec_inventories%NOTFOUND THEN
258: /*** could not find assignment record -> exit ***/
259: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
260: jtm_message_log_pkg.Log_Msg

Line 257: IF c_csp_sec_inventories%NOTFOUND THEN

253:
254: /*** Retreive record assigned by Hook ***/
255: OPEN c_csp_sec_inventories( p_subinventory_code, p_organization_id);
256: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
257: IF c_csp_sec_inventories%NOTFOUND THEN
258: /*** could not find assignment record -> exit ***/
259: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
260: jtm_message_log_pkg.Log_Msg
261: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 268: CLOSE c_csp_sec_inventories;

264: || p_organization_id || ' for resource id ' || p_resource_id
265: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
266: END IF;
267:
268: CLOSE c_csp_sec_inventories;
269: RETURN l_return_value;
270: ELSE
271: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
272: jtm_message_log_pkg.Log_Msg

Line 281: WHILE c_csp_sec_inventories%FOUND LOOP

277: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
278: END IF;
279:
280: /*** Loop over all available records and put them in the acc table ***/
281: WHILE c_csp_sec_inventories%FOUND LOOP
282: /*** Call common package to insert record into ACC table ***/
283: JTM_HOOK_UTIL_PKG.Delete_Acc
284: ( p_publication_item_names => g_publication_item_name
285: ,p_acc_table_name => g_acc_table_name

Line 287: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID

283: JTM_HOOK_UTIL_PKG.Delete_Acc
284: ( p_publication_item_names => g_publication_item_name
285: ,p_acc_table_name => g_acc_table_name
286: ,p_pk1_name => g_pk1_name
287: ,p_pk1_num_value => r_csp_sec_inventories.SECONDARY_INVENTORY_ID
288: ,p_resource_id => p_resource_id
289: );
290:
291: CSL_MTL_SEC_INV_ACC_PKG.Delete_MTL_Sec_Inventory(p_resource_id, p_subinventory_code, p_organization_id);

Line 299: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;

295: , p_resource_id => p_resource_id
296: );
297:
298:
299: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
300: END LOOP;
301: /*** Succesfull looped through recordset ***/
302: l_return_value := TRUE;
303: END IF;