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_PKG

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 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 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 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 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 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 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 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 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 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 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 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 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 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;