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.CSP_INV_LOC_ASSIGNMENTS_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS_PKG

Line 1: PACKAGE BODY CSP_INV_LOC_ASSIGNMENTS_PKG AS

1: PACKAGE BODY CSP_INV_LOC_ASSIGNMENTS_PKG AS
2: /* $Header: cspttreb.pls 120.0 2005/05/25 11:37:41 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSP_INV_LOC_ASSIGNMENTS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_INV_LOC_ASSIGNMENTS_PKG

1: PACKAGE BODY CSP_INV_LOC_ASSIGNMENTS_PKG AS
2: /* $Header: cspttreb.pls 120.0 2005/05/25 11:37:41 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSP_INV_LOC_ASSIGNMENTS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_INV_LOC_ASSIGNMENTS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_INV_LOC_ASSIGNMENTS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspttreb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_CSP_INV_LOC_ASSIGNMENT_ID IN OUT NOCOPY NUMBER,

Line 48: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;

44: p_ATTRIBUTE15 VARCHAR2)
45:
46: IS
47: CURSOR C2 IS SELECT CSP_INV_LOC_ASSIGNMENTS_S1.nextval FROM sys.dual;
48: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;
49: l_return_status varchar2(100);
50: l_msg_count NUMBER;
51: l_msg_data varchar2(1000);
52: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.INSERT_ROW';

Line 52: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.INSERT_ROW';

48: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;
49: l_return_status varchar2(100);
50: l_msg_count NUMBER;
51: l_msg_data varchar2(1000);
52: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.INSERT_ROW';
53: BEGIN
54: l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID := px_CSP_INV_LOC_ASSIGNMENT_ID;
55: l_inv_loc_assignment.CREATED_BY := p_CREATED_BY ;
56: l_inv_loc_assignment.CREATION_DATE := p_CREATION_DATE ;

Line 85: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 105: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 207: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 227: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 291: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;

287: p_ATTRIBUTE14 VARCHAR2,
288: p_ATTRIBUTE15 VARCHAR2)
289:
290: IS
291: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;
292: l_return_status varchar2(100);
293: l_msg_count NUMBER;
294: l_msg_data varchar2(1000);
295: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.UPDATE_ROW';

Line 295: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.UPDATE_ROW';

291: l_inv_loc_assignment CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;
292: l_return_status varchar2(100);
293: l_msg_count NUMBER;
294: l_msg_data varchar2(1000);
295: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.UPDATE_ROW';
296: BEGIN
297:
298:
299: l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID := p_CSP_INV_LOC_ASSIGNMENT_ID;

Line 330: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 350: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 418: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 438: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 476: l_api_name_full varchar2(50) := 'CSP_INV_LOC_ASSIGNMENTS_PKG.DELETE_ROW';

472: l_inv_loc_assignment_id NUMBER;
473: l_return_status varchar2(100);
474: l_msg_count NUMBER;
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',

Line 479: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 499: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 535: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 555: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

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 ,

Line 733: End CSP_INV_LOC_ASSIGNMENTS_PKG;

729: APP_EXCEPTION.RAISE_EXCEPTION;
730: End If;
731: END Lock_Row;
732:
733: End CSP_INV_LOC_ASSIGNMENTS_PKG;