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 120.1 2011/06/02 13:05:35 vmandava ship $ */
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 120.1 2011/06/02 13:05:35 vmandava ship $ */
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 55: CURSOR C2 IS SELECT CSP_REQUIREMENT_LINES_S1.nextval FROM sys.dual;

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

Line 56: l_requirement_line CSP_REQUIREMENT_LINES_PVT.Requirement_line_Rec_Type;

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

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

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

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

107: END IF;
108:
109: --Pre hook
110: IF l_dml_mode <> 'POST' THEN
111: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
112: 'Insert_Row',
113: 'B', 'C') THEN
114:
115: csp_requirement_lines_cuhk.Create_requirement_line_Pre

Line 115: csp_requirement_lines_cuhk.Create_requirement_line_Pre

111: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
112: 'Insert_Row',
113: 'B', 'C') THEN
114:
115: csp_requirement_lines_cuhk.Create_requirement_line_Pre
116: ( px_requirement_line => l_requirement_line,
117: x_return_status => l_return_status,
118: x_msg_count => l_msg_count,
119: x_msg_data => l_msg_data

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

129:
130:
131: -- Pre call to the Vertical Type User Hook
132: --
133: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
134: 'Insert_Row',
135: 'B', 'V') THEN
136: csp_requirement_lines_vuhk.Create_requirement_line_Pre
137: ( px_requirement_line => l_requirement_line,

Line 136: csp_requirement_lines_vuhk.Create_requirement_line_Pre

132: --
133: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
134: 'Insert_Row',
135: 'B', 'V') THEN
136: csp_requirement_lines_vuhk.Create_requirement_line_Pre
137: ( px_requirement_line => l_requirement_line,
138: x_return_status => l_return_status,
139: x_msg_count => l_msg_count,
140: x_msg_data => l_msg_data

Line 151: csp_requirement_lines_iuhk.Create_requirement_line_Pre

147: FND_MSG_PUB.Add;
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150: END IF;
151: csp_requirement_lines_iuhk.Create_requirement_line_Pre
152: ( x_return_status => l_return_status
153: ) ;
154: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 170: INSERT INTO CSP_REQUIREMENT_LINES(

166: END IF;
167: l_requirement_line.REQUIREMENT_LINE_ID := px_REQUIREMENT_LINE_ID ;
168: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
169: IF l_dml_mode = 'BOTH' THEN
170: INSERT INTO CSP_REQUIREMENT_LINES(
171: REQUIREMENT_LINE_ID,
172: CREATED_BY,
173: CREATION_DATE,
174: LAST_UPDATED_BY,

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

255: END IF;
256:
257: --Post hooks
258: IF l_dml_mode <> 'PRE' THEN
259: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
260: 'Insert_Row',
261: 'A', 'C') THEN
262:
263: csp_requirement_lines_cuhk.Create_requirement_line_post

Line 263: csp_requirement_lines_cuhk.Create_requirement_line_post

259: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
260: 'Insert_Row',
261: 'A', 'C') THEN
262:
263: csp_requirement_lines_cuhk.Create_requirement_line_post
264: ( px_requirement_line => l_requirement_line,
265: x_return_status => l_return_status,
266: x_msg_count => l_msg_count,
267: x_msg_data => l_msg_data

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

279:
280:
281: -- Post call to the Vertical Type User Hook
282: --
283: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
284: 'Insert_Row',
285: 'A', 'V') THEN
286:
287: csp_requirement_lines_vuhk.Create_requirement_line_post

Line 287: csp_requirement_lines_vuhk.Create_requirement_line_post

283: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
284: 'Insert_Row',
285: 'A', 'V') THEN
286:
287: csp_requirement_lines_vuhk.Create_requirement_line_post
288: ( px_requirement_line => l_requirement_line,
289: x_return_status => l_return_status,
290: x_msg_count => l_msg_count,
291: x_msg_data => l_msg_data

Line 302: csp_requirement_lines_iuhk.Create_requirement_line_post

298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300: END IF;
301: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
302: csp_requirement_lines_iuhk.Create_requirement_line_post
303: ( x_return_status => l_return_status
304: ) ;
305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
306: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 358: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;

354: p_LOCAL_RESERVATION_ID NUMBER,
355: p_SOURCED_FROM VARCHAR2,
356: p_DML_MODE VARCHAR2)
357: IS
358: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;
359: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.UPDATE_ROW';
360: l_return_status varchar2(100);
361: l_msg_count NUMBER;
362: l_msg_data varchar2(1000);

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

355: p_SOURCED_FROM VARCHAR2,
356: p_DML_MODE VARCHAR2)
357: IS
358: l_requirement_line CSP_REQUIREMENT_lines_PVT.Requirement_LINE_Rec_Type;
359: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.UPDATE_ROW';
360: l_return_status varchar2(100);
361: l_msg_count NUMBER;
362: l_msg_data varchar2(1000);
363: l_dml_mode varchar2(10) := p_dml_mode;

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

407: l_dml_mode :='BOTH';
408: END IF;
409:
410: IF l_dml_mode <> 'POST' THEN
411: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
412: 'Update_Row',
413: 'B', 'C') THEN
414:
415: csp_requirement_lines_cuhk.update_requirement_line_Pre

Line 415: csp_requirement_lines_cuhk.update_requirement_line_Pre

411: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
412: 'Update_Row',
413: 'B', 'C') THEN
414:
415: csp_requirement_lines_cuhk.update_requirement_line_Pre
416: ( px_requirement_line => l_requirement_line,
417: x_return_status => l_return_status,
418: x_msg_count => l_msg_count,
419: x_msg_data => l_msg_data

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

429:
430:
431: -- Pre call to the Vertical Type User Hook
432: --
433: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
434: 'Update_Row',
435: 'B', 'V') THEN
436: csp_requirement_lines_vuhk.update_requirement_line_Pre
437: ( px_requirement_line => l_requirement_line,

Line 436: csp_requirement_lines_vuhk.update_requirement_line_Pre

432: --
433: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
434: 'Update_Row',
435: 'B', 'V') THEN
436: csp_requirement_lines_vuhk.update_requirement_line_Pre
437: ( px_requirement_line => l_requirement_line,
438: x_return_status => l_return_status,
439: x_msg_count => l_msg_count,
440: x_msg_data => l_msg_data

Line 452: csp_requirement_lines_iuhk.update_requirement_line_Pre

448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450: END IF;
451: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
452: csp_requirement_lines_iuhk.update_requirement_line_Pre
453: ( x_return_status => l_return_status
454: ) ;
455: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
456: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 464: Update CSP_REQUIREMENT_LINES

460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: END IF;
463: IF l_dml_mode = 'BOTH' THEN
464: Update CSP_REQUIREMENT_LINES
465: SET
466: CREATED_BY = decode( l_requirement_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_line.CREATED_BY),
467: CREATION_DATE = decode( l_requirement_line.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_line.CREATION_DATE),
468: 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 513: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',

509: End If;
510: END IF;
511:
512: IF l_dml_mode <> 'PRE' THEN
513: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
514: 'Update_Row',
515: 'A', 'C') THEN
516:
517: csp_requirement_lines_cuhk.update_requirement_line_post

Line 517: csp_requirement_lines_cuhk.update_requirement_line_post

513: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
514: 'Update_Row',
515: 'A', 'C') THEN
516:
517: csp_requirement_lines_cuhk.update_requirement_line_post
518: ( px_requirement_line => l_requirement_line,
519: x_return_status => l_return_status,
520: x_msg_count => l_msg_count,
521: x_msg_data => l_msg_data

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

531:
532:
533: -- Pre call to the Vertical Type User Hook
534: --
535: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
536: 'Update_Row',
537: 'A', 'V') THEN
538: csp_requirement_lines_vuhk.update_requirement_line_post
539: ( px_requirement_line => l_requirement_line,

Line 538: csp_requirement_lines_vuhk.update_requirement_line_post

534: --
535: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
536: 'Update_Row',
537: 'A', 'V') THEN
538: csp_requirement_lines_vuhk.update_requirement_line_post
539: ( px_requirement_line => l_requirement_line,
540: x_return_status => l_return_status,
541: x_msg_count => l_msg_count,
542: x_msg_data => l_msg_data

Line 552: csp_requirement_lines_iuhk.update_requirement_line_post

548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: END IF;
551: END IF;
552: csp_requirement_lines_iuhk.update_requirement_line_post
553: ( x_return_status => l_return_status
554: ) ;
555: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
556: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

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

567: IS
568: l_return_status varchar2(100);
569: l_msg_count NUMBER;
570: l_msg_data varchar2(1000);
571: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_LINES_PKG.DELETE_ROW';
572: l_dml_mode varchar2(10) :=p_dml_mode;
573: BEGIN
574: IF l_dml_mode is null THEN
575: l_dml_mode :='BOTH';

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

575: l_dml_mode :='BOTH';
576: END IF;
577:
578: IF l_dml_mode <> 'POST' THEN
579: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
580: 'Delete_Row',
581: 'B', 'C') THEN
582:
583: csp_requirement_lines_cuhk.delete_requirement_line_Pre

Line 583: csp_requirement_lines_cuhk.delete_requirement_line_Pre

579: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
580: 'Delete_Row',
581: 'B', 'C') THEN
582:
583: csp_requirement_lines_cuhk.delete_requirement_line_Pre
584: ( p_line_id => p_REQUIREMENT_LINE_ID,
585: x_return_status => l_return_status,
586: x_msg_count => l_msg_count,
587: x_msg_data => l_msg_data

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

597:
598:
599: -- Pre call to the Vertical Type User Hook
600: --
601: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
602: 'Delete_Row',
603: 'B', 'V') THEN
604: csp_requirement_lines_vuhk.delete_requirement_line_Pre
605: ( p_line_id => p_REQUIREMENT_LINE_ID,

Line 604: csp_requirement_lines_vuhk.delete_requirement_line_Pre

600: --
601: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
602: 'Delete_Row',
603: 'B', 'V') THEN
604: csp_requirement_lines_vuhk.delete_requirement_line_Pre
605: ( p_line_id => p_REQUIREMENT_LINE_ID,
606: x_return_status => l_return_status,
607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data

Line 620: csp_requirement_lines_iuhk.delete_requirement_line_Pre

616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618: END IF;
619: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
620: csp_requirement_lines_iuhk.delete_requirement_line_Pre
621: ( x_return_status => l_return_status
622: ) ;
623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
624: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 632: DELETE FROM CSP_REQUIREMENT_LINES

628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630: END IF;
631: IF l_dml_mode = 'BOTH' THEN
632: DELETE FROM CSP_REQUIREMENT_LINES
633: WHERE REQUIREMENT_LINE_ID = p_REQUIREMENT_LINE_ID;
634: If (SQL%NOTFOUND) then
635: RAISE NO_DATA_FOUND;
636: End If;

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

636: End If;
637: END IF;
638:
639: IF l_dml_mode <> 'PRE' THEN
640: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
641: 'Delete_Row',
642: 'A', 'C') THEN
643:
644: csp_requirement_lines_cuhk.delete_requirement_line_Post

Line 644: csp_requirement_lines_cuhk.delete_requirement_line_Post

640: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
641: 'Delete_Row',
642: 'A', 'C') THEN
643:
644: csp_requirement_lines_cuhk.delete_requirement_line_Post
645: ( p_line_id => p_REQUIREMENT_LINE_ID,
646: x_return_status => l_return_status,
647: x_msg_count => l_msg_count,
648: x_msg_data => l_msg_data

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

658:
659:
660: -- Pre call to the Vertical Type User Hook
661: --
662: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
663: 'Delete_Row',
664: 'A', 'V') THEN
665: csp_requirement_lines_vuhk.delete_requirement_line_post
666: ( p_line_id => p_REQUIREMENT_LINE_ID,

Line 665: csp_requirement_lines_vuhk.delete_requirement_line_post

661: --
662: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_LINES_PKG',
663: 'Delete_Row',
664: 'A', 'V') THEN
665: csp_requirement_lines_vuhk.delete_requirement_line_post
666: ( p_line_id => p_REQUIREMENT_LINE_ID,
667: x_return_status => l_return_status,
668: x_msg_count => l_msg_count,
669: x_msg_data => l_msg_data

Line 681: csp_requirement_lines_iuhk.delete_requirement_line_post

677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679: END IF;
680: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
681: csp_requirement_lines_iuhk.delete_requirement_line_post
682: ( x_return_status => l_return_status
683: ) ;
684: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
685: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 739: FROM CSP_REQUIREMENT_LINES

735: p_SOURCE_LINE_ID NUMBER)
736: IS
737: CURSOR C IS
738: SELECT *
739: FROM CSP_REQUIREMENT_LINES
740: WHERE REQUIREMENT_LINE_ID = p_REQUIREMENT_LINE_ID
741: FOR UPDATE of REQUIREMENT_LINE_ID NOWAIT;
742: Recinfo C%ROWTYPE;
743: BEGIN

Line 888: End CSP_REQUIREMENT_LINES_PKG;

884: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
885: APP_EXCEPTION.RAISE_EXCEPTION;
886: End If;
887: END Lock_Row;
888: End CSP_REQUIREMENT_LINES_PKG;