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_REQUIREMENT_LINES_PKG dependencies on CSP_REQUIREMENT_LINES

Line 1: PACKAGE BODY CSP_REQUIREMENT_LINES_PKG as

1: PACKAGE BODY CSP_REQUIREMENT_LINES_PKG as
2: /* $Header: csptrqlb.pls 115.13 2004/03/24 22:57:57 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_LINES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_REQUIREMENT_LINES_PKG

1: PACKAGE BODY CSP_REQUIREMENT_LINES_PKG as
2: /* $Header: csptrqlb.pls 115.13 2004/03/24 22:57:57 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_LINES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQUIREMENT_LINES_PKG';

5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQUIREMENT_LINES_PKG';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptrqlb.pls';
11: PROCEDURE Insert_Row(
12: px_REQUIREMENT_LINE_ID IN OUT NOCOPY NUMBER,
13: p_CREATED_BY NUMBER,

Line 54: CURSOR C2 IS SELECT CSP_REQUIREMENT_LINES_S1.nextval FROM sys.dual;

50: p_SHIPPING_METHOD_CODE VARCHAR2,
51: p_LOCAL_RESERVATION_ID NUMBER,
52: p_SOURCED_FROM VARCHAR2)
53: IS
54: CURSOR C2 IS SELECT CSP_REQUIREMENT_LINES_S1.nextval FROM sys.dual;
55: l_requirement_line CSP_REQUIREMENT_LINES_PVT.Requirement_line_Rec_Type;
56: l_return_status varchar2(100);
57: l_msg_count NUMBER;
58: l_msg_data varchar2(1000);

Line 55: l_requirement_line CSP_REQUIREMENT_LINES_PVT.Requirement_line_Rec_Type;

51: p_LOCAL_RESERVATION_ID NUMBER,
52: p_SOURCED_FROM VARCHAR2)
53: IS
54: CURSOR C2 IS SELECT CSP_REQUIREMENT_LINES_S1.nextval FROM sys.dual;
55: l_requirement_line CSP_REQUIREMENT_LINES_PVT.Requirement_line_Rec_Type;
56: l_return_status varchar2(100);
57: l_msg_count NUMBER;
58: l_msg_data varchar2(1000);
59: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.INSERT_ROW';

Line 59: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.INSERT_ROW';

55: l_requirement_line CSP_REQUIREMENT_LINES_PVT.Requirement_line_Rec_Type;
56: l_return_status varchar2(100);
57: l_msg_count NUMBER;
58: l_msg_data varchar2(1000);
59: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.INSERT_ROW';
60: BEGIN
61: l_requirement_line.REQUIREMENT_LINE_ID := px_REQUIREMENT_LINE_ID ;
62: l_requirement_line.CREATED_BY := p_CREATED_BY;
63: l_requirement_line.CREATION_DATE := p_CREATION_DATE;

Line 103: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

99: l_requirement_line.SHIPPING_METHOD_CODE :=p_SHIPPING_METHOD_CODE;
100: l_requirement_line.LOCAL_RESERVATION_ID :=p_LOCAL_RESERVATION_ID;
101: l_requirement_line.SOURCED_FROM :=p_SOURCED_FROM;
102:
103: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
104: 'Insert_Row',
105: 'B', 'C') THEN
106:
107: csp_requirement_lines_cuhk.Create_requirement_line_Pre

Line 107: csp_requirement_lines_cuhk.Create_requirement_line_Pre

103: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
104: 'Insert_Row',
105: 'B', 'C') THEN
106:
107: csp_requirement_lines_cuhk.Create_requirement_line_Pre
108: ( px_requirement_line => l_requirement_line,
109: x_return_status => l_return_status,
110: x_msg_count => l_msg_count,
111: x_msg_data => l_msg_data

Line 125: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

121:
122:
123: -- Pre call to the Vertical Type User Hook
124: --
125: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
126: 'Insert_Row',
127: 'B', 'V') THEN
128: csp_requirement_lines_vuhk.Create_requirement_line_Pre
129: ( px_requirement_line => l_requirement_line,

Line 128: csp_requirement_lines_vuhk.Create_requirement_line_Pre

124: --
125: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
126: 'Insert_Row',
127: 'B', 'V') THEN
128: csp_requirement_lines_vuhk.Create_requirement_line_Pre
129: ( px_requirement_line => l_requirement_line,
130: x_return_status => l_return_status,
131: x_msg_count => l_msg_count,
132: x_msg_data => l_msg_data

Line 143: csp_requirement_lines_iuhk.Create_requirement_line_Pre

139: FND_MSG_PUB.Add;
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END IF;
143: csp_requirement_lines_iuhk.Create_requirement_line_Pre
144: ( x_return_status => l_return_status
145: ) ;
146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 160: INSERT INTO CSP_REQUIREMENT_LINES(

156: CLOSE C2;
157: End If;
158: l_requirement_line.REQUIREMENT_LINE_ID := px_REQUIREMENT_LINE_ID ;
159: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
160: INSERT INTO CSP_REQUIREMENT_LINES(
161: REQUIREMENT_LINE_ID,
162: CREATED_BY,
163: CREATION_DATE,
164: LAST_UPDATED_BY,

Line 246: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

242: decode( l_requirement_line.LOCAL_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_line.LOCAL_RESERVATION_ID),
243: decode( l_requirement_line.SOURCED_FROM, FND_API.G_MISS_CHAR, NULL, l_requirement_line.SOURCED_FROM)
244: );
245:
246: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
247: 'Insert_Row',
248: 'A', 'C') THEN
249:
250: csp_requirement_lines_cuhk.Create_requirement_line_post

Line 250: csp_requirement_lines_cuhk.Create_requirement_line_post

246: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
247: 'Insert_Row',
248: 'A', 'C') THEN
249:
250: csp_requirement_lines_cuhk.Create_requirement_line_post
251: ( px_requirement_line => l_requirement_line,
252: x_return_status => l_return_status,
253: x_msg_count => l_msg_count,
254: x_msg_data => l_msg_data

Line 270: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

266:
267:
268: -- Post call to the Vertical Type User Hook
269: --
270: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
271: 'Insert_Row',
272: 'A', 'V') THEN
273:
274: csp_requirement_lines_vuhk.Create_requirement_line_post

Line 274: csp_requirement_lines_vuhk.Create_requirement_line_post

270: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
271: 'Insert_Row',
272: 'A', 'V') THEN
273:
274: csp_requirement_lines_vuhk.Create_requirement_line_post
275: ( px_requirement_line => l_requirement_line,
276: x_return_status => l_return_status,
277: x_msg_count => l_msg_count,
278: x_msg_data => l_msg_data

Line 289: csp_requirement_lines_iuhk.Create_requirement_line_post

285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287: END IF;
288: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
289: csp_requirement_lines_iuhk.Create_requirement_line_post
290: ( x_return_status => l_return_status
291: ) ;
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
293: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 344: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;

340: p_SHIPPING_METHOD_CODE VARCHAR2,
341: p_LOCAL_RESERVATION_ID NUMBER,
342: p_SOURCED_FROM VARCHAR2)
343: IS
344: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;
345: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.UPDATE_ROW';
346: l_return_status varchar2(100);
347: l_msg_count NUMBER;
348: l_msg_data varchar2(1000);

Line 345: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.UPDATE_ROW';

341: p_LOCAL_RESERVATION_ID NUMBER,
342: p_SOURCED_FROM VARCHAR2)
343: IS
344: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;
345: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.UPDATE_ROW';
346: l_return_status varchar2(100);
347: l_msg_count NUMBER;
348: l_msg_data varchar2(1000);
349: BEGIN

Line 392: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

388: l_requirement_line.SHIPPING_METHOD_CODE :=p_SHIPPING_METHOD_CODE;
389: l_requirement_line.LOCAL_RESERVATION_ID :=p_LOCAL_RESERVATION_ID;
390: l_requirement_line.SOURCED_FROM :=p_SOURCED_FROM;
391:
392: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
393: 'Update_Row',
394: 'B', 'C') THEN
395:
396: csp_requirement_lines_cuhk.update_requirement_line_Pre

Line 396: csp_requirement_lines_cuhk.update_requirement_line_Pre

392: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
393: 'Update_Row',
394: 'B', 'C') THEN
395:
396: csp_requirement_lines_cuhk.update_requirement_line_Pre
397: ( px_requirement_line => l_requirement_line,
398: x_return_status => l_return_status,
399: x_msg_count => l_msg_count,
400: x_msg_data => l_msg_data

Line 414: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

410:
411:
412: -- Pre call to the Vertical Type User Hook
413: --
414: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
415: 'Update_Row',
416: 'B', 'V') THEN
417: csp_requirement_lines_vuhk.update_requirement_line_Pre
418: ( px_requirement_line => l_requirement_line,

Line 417: csp_requirement_lines_vuhk.update_requirement_line_Pre

413: --
414: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
415: 'Update_Row',
416: 'B', 'V') THEN
417: csp_requirement_lines_vuhk.update_requirement_line_Pre
418: ( px_requirement_line => l_requirement_line,
419: x_return_status => l_return_status,
420: x_msg_count => l_msg_count,
421: x_msg_data => l_msg_data

Line 433: csp_requirement_lines_iuhk.update_requirement_line_Pre

429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: END IF;
432: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
433: csp_requirement_lines_iuhk.update_requirement_line_Pre
434: ( x_return_status => l_return_status
435: ) ;
436: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
437: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 444: Update CSP_REQUIREMENT_LINES

440: FND_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: Update CSP_REQUIREMENT_LINES
445: SET
446: CREATED_BY = decode( l_requirement_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_line.CREATED_BY),
447: CREATION_DATE = decode( l_requirement_line.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_line.CREATION_DATE),
448: LAST_UPDATED_BY = decode( l_requirement_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_line.LAST_UPDATED_BY),

Line 490: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

486: where REQUIREMENT_LINE_ID = l_requirement_line.REQUIREMENT_LINE_ID;
487: If (SQL%NOTFOUND) then
488: RAISE NO_DATA_FOUND;
489: End If;
490: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
491: 'Update_Row',
492: 'A', 'C') THEN
493:
494: csp_requirement_lines_cuhk.update_requirement_line_post

Line 494: csp_requirement_lines_cuhk.update_requirement_line_post

490: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
491: 'Update_Row',
492: 'A', 'C') THEN
493:
494: csp_requirement_lines_cuhk.update_requirement_line_post
495: ( px_requirement_line => l_requirement_line,
496: x_return_status => l_return_status,
497: x_msg_count => l_msg_count,
498: x_msg_data => l_msg_data

Line 512: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

508:
509:
510: -- Pre call to the Vertical Type User Hook
511: --
512: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
513: 'Update_Row',
514: 'A', 'V') THEN
515: csp_requirement_lines_vuhk.update_requirement_line_post
516: ( px_requirement_line => l_requirement_line,

Line 515: csp_requirement_lines_vuhk.update_requirement_line_post

511: --
512: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
513: 'Update_Row',
514: 'A', 'V') THEN
515: csp_requirement_lines_vuhk.update_requirement_line_post
516: ( px_requirement_line => l_requirement_line,
517: x_return_status => l_return_status,
518: x_msg_count => l_msg_count,
519: x_msg_data => l_msg_data

Line 529: csp_requirement_lines_iuhk.update_requirement_line_post

525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: END IF;
529: csp_requirement_lines_iuhk.update_requirement_line_post
530: ( x_return_status => l_return_status
531: ) ;
532: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
533: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 547: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.DELETE_ROW';

543: IS
544: l_return_status varchar2(100);
545: l_msg_count NUMBER;
546: l_msg_data varchar2(1000);
547: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.DELETE_ROW';
548:
549: BEGIN
550: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
551: 'Delete_Row',

Line 550: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

546: l_msg_data varchar2(1000);
547: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.DELETE_ROW';
548:
549: BEGIN
550: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
551: 'Delete_Row',
552: 'B', 'C') THEN
553:
554: csp_requirement_lines_cuhk.delete_requirement_line_Pre

Line 554: csp_requirement_lines_cuhk.delete_requirement_line_Pre

550: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
551: 'Delete_Row',
552: 'B', 'C') THEN
553:
554: csp_requirement_lines_cuhk.delete_requirement_line_Pre
555: ( p_line_id => p_REQUIREMENT_LINE_ID,
556: x_return_status => l_return_status,
557: x_msg_count => l_msg_count,
558: x_msg_data => l_msg_data

Line 572: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

568:
569:
570: -- Pre call to the Vertical Type User Hook
571: --
572: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
573: 'Delete_Row',
574: 'B', 'V') THEN
575: csp_requirement_lines_vuhk.delete_requirement_line_Pre
576: ( p_line_id => p_REQUIREMENT_LINE_ID,

Line 575: csp_requirement_lines_vuhk.delete_requirement_line_Pre

571: --
572: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
573: 'Delete_Row',
574: 'B', 'V') THEN
575: csp_requirement_lines_vuhk.delete_requirement_line_Pre
576: ( p_line_id => p_REQUIREMENT_LINE_ID,
577: x_return_status => l_return_status,
578: x_msg_count => l_msg_count,
579: x_msg_data => l_msg_data

Line 591: csp_requirement_lines_iuhk.delete_requirement_line_Pre

587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: END IF;
589: END IF;
590: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
591: csp_requirement_lines_iuhk.delete_requirement_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 602: DELETE FROM CSP_REQUIREMENT_LINES

598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601:
602: DELETE FROM CSP_REQUIREMENT_LINES
603: WHERE REQUIREMENT_LINE_ID = p_REQUIREMENT_LINE_ID;
604: If (SQL%NOTFOUND) then
605: RAISE NO_DATA_FOUND;
606: End If;

Line 607: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

603: WHERE REQUIREMENT_LINE_ID = p_REQUIREMENT_LINE_ID;
604: If (SQL%NOTFOUND) then
605: RAISE NO_DATA_FOUND;
606: End If;
607: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
608: 'Delete_Row',
609: 'A', 'C') THEN
610:
611: csp_requirement_lines_cuhk.delete_requirement_line_Post

Line 611: csp_requirement_lines_cuhk.delete_requirement_line_Post

607: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
608: 'Delete_Row',
609: 'A', 'C') THEN
610:
611: csp_requirement_lines_cuhk.delete_requirement_line_Post
612: ( p_line_id => p_REQUIREMENT_LINE_ID,
613: x_return_status => l_return_status,
614: x_msg_count => l_msg_count,
615: x_msg_data => l_msg_data

Line 629: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

625:
626:
627: -- Pre call to the Vertical Type User Hook
628: --
629: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
630: 'Delete_Row',
631: 'A', 'V') THEN
632: csp_requirement_lines_vuhk.delete_requirement_line_post
633: ( p_line_id => p_REQUIREMENT_LINE_ID,

Line 632: csp_requirement_lines_vuhk.delete_requirement_line_post

628: --
629: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
630: 'Delete_Row',
631: 'A', 'V') THEN
632: csp_requirement_lines_vuhk.delete_requirement_line_post
633: ( p_line_id => p_REQUIREMENT_LINE_ID,
634: x_return_status => l_return_status,
635: x_msg_count => l_msg_count,
636: x_msg_data => l_msg_data

Line 648: csp_requirement_lines_iuhk.delete_requirement_line_post

644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: END IF;
646: END IF;
647: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
648: csp_requirement_lines_iuhk.delete_requirement_line_post
649: ( x_return_status => l_return_status
650: ) ;
651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 706: FROM CSP_REQUIREMENT_LINES

702: p_SOURCE_LINE_ID NUMBER)
703: IS
704: CURSOR C IS
705: SELECT *
706: FROM CSP_REQUIREMENT_LINES
707: WHERE REQUIREMENT_LINE_ID = p_REQUIREMENT_LINE_ID
708: FOR UPDATE of REQUIREMENT_LINE_ID NOWAIT;
709: Recinfo C%ROWTYPE;
710: BEGIN

Line 855: End CSP_REQUIREMENT_LINES_PKG;

851: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
852: APP_EXCEPTION.RAISE_EXCEPTION;
853: End If;
854: END Lock_Row;
855: End CSP_REQUIREMENT_LINES_PKG;