81: l_inv_loc_assignment.ATTRIBUTE13 := p_ATTRIBUTE13;
82: l_inv_loc_assignment.ATTRIBUTE14 := p_ATTRIBUTE14;
83: l_inv_loc_assignment.ATTRIBUTE15 := p_ATTRIBUTE15;
84:
85: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
86: 'Insert_Row',
87: 'B', 'C') THEN
88: csp_inv_loc_assignments_cuhk.create_inventory_location_Pre
89: ( px_inv_loc_assignment => l_inv_loc_assignment ,
101: END IF;
102: END IF;
103: -- Pre call to the Vertical Type User Hook
104: --
105: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
106: 'Insert_Row',
107: 'B', 'V') THEN
108: csp_inv_loc_assignments_vuhk.create_inventory_location_Pre
109: ( px_inv_loc_assignment => l_inv_loc_assignment ,
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));
206:
207: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
208: 'Insert_Row',
209: 'A', 'C') THEN
210: csp_inv_loc_assignments_cuhk.create_inventory_location_Post
211: ( px_inv_loc_assignment => l_inv_loc_assignment ,
223: END IF;
224: END IF;
225: -- Pre call to the Vertical Type User Hook
226: --
227: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
228: 'Insert_Row',
229: 'A', 'V') THEN
230: csp_inv_loc_assignments_vuhk.create_inventory_location_Post
231: ( px_inv_loc_assignment => l_inv_loc_assignment ,
326: l_inv_loc_assignment.ATTRIBUTE13 := p_ATTRIBUTE13;
327: l_inv_loc_assignment.ATTRIBUTE14 := p_ATTRIBUTE14;
328: l_inv_loc_assignment.ATTRIBUTE15 := p_ATTRIBUTE15;
329: user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID := l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID ;
330: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
331: 'Update_Row',
332: 'B', 'C') THEN
333: csp_inv_loc_assignments_cuhk.update_inventory_location_Pre
334: ( px_inv_loc_assignment => l_inv_loc_assignment ,
346: END IF;
347: END IF;
348: -- Pre call to the Vertical Type User Hook
349: --
350: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
351: 'Update_Row',
352: 'B', 'V') THEN
353: csp_inv_loc_assignments_vuhk.update_inventory_location_Pre
354: ( px_inv_loc_assignment => l_inv_loc_assignment ,
414: If (SQL%NOTFOUND) then
415: RAISE NO_DATA_FOUND;
416: End If;
417:
418: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
419: 'Update_Row',
420: 'A', 'C') THEN
421: csp_inv_loc_assignments_cuhk.update_inventory_location_post
422: ( px_inv_loc_assignment => l_inv_loc_assignment ,
434: END IF;
435: END IF;
436: -- Pre call to the Vertical Type User Hook
437: --
438: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
439: 'Update_Row',
440: 'A', 'V') THEN
441: csp_inv_loc_assignments_vuhk.update_inventory_location_Post
442: ( px_inv_loc_assignment => l_inv_loc_assignment ,
475: l_msg_data varchar2(1000);
476: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.DELETE_ROW';
477: BEGIN
478: user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID := p_CSP_INV_LOC_ASSIGNMENT_ID ;
479: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
480: 'Delete_Row',
481: 'B', 'C') THEN
482: csp_inv_loc_assignments_cuhk.delete_inventory_location_pre
483: ( p_inv_loc_assignment_id => p_CSP_INV_LOC_ASSIGNMENT_ID ,
495: END IF;
496: END IF;
497: -- Pre call to the Vertical Type User Hook
498: --
499: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
500: 'Update_Row',
501: 'B', 'V') THEN
502: csp_inv_loc_assignments_vuhk.delete_inventory_location_pre
503: ( p_inv_loc_assignment_id => p_CSP_INV_LOC_ASSIGNMENT_ID ,
531: If (SQL%NOTFOUND) then
532: RAISE NO_DATA_FOUND;
533: End If;
534:
535: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
536: 'Delete_Row',
537: 'A', 'C') THEN
538: csp_inv_loc_assignments_cuhk.delete_inventory_location_post
539: ( p_inv_loc_assignment_id => p_CSP_INV_LOC_ASSIGNMENT_ID ,
551: END IF;
552: END IF;
553: -- Pre call to the Vertical Type User Hook
554: --
555: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
556: 'Delete_Row',
557: 'A', 'V') THEN
558: csp_inv_loc_assignments_vuhk.delete_inventory_location_Post
559: ( p_inv_loc_assignment_id => p_CSP_INV_LOC_ASSIGNMENT_ID ,