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_HEADERS_PKG dependencies on CSP_REQUIREMENT_HEADERS_PKG

Line 1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as

1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as
2: /* $Header: csptrqhb.pls 120.2.12020000.2 2012/07/18 08:04:57 kgambhir ship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG

1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as
2: /* $Header: csptrqhb.pls 120.2.12020000.2 2012/07/18 08:04:57 kgambhir ship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

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

56: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_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_HEADERS_PKG.INSERT_ROW';
61: l_dml_mode varchar2(10) :=p_DML_MODE;
62: BEGIN
63: l_requirement_header.REQUIREMENT_HEADER_ID := px_REQUIREMENT_HEADER_ID;
64: l_requirement_header.CREATED_BY := p_CREATED_BY;

Line 106: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

102: l_dml_mode := 'BOTH';
103: END IF;
104: --Pre hook
105: IF l_dml_mode <> 'POST' THEN
106: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
107: 'Insert_Row',
108: 'B', 'C') THEN
109:
110: csp_requirement_headers_cuhk.Create_requirement_header_Pre

Line 128: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

124:
125:
126: -- Pre call to the Vertical Type User Hook
127: --
128: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
129: 'Insert_Row',
130: 'B', 'V') THEN
131: csp_requirement_headers_vuhk.Create_requirement_header_Pre
132: ( px_requirement_header => l_requirement_header,

Line 247: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

243: END IF;
244:
245: --Post hook
246: IF l_dml_mode <> 'PRE' THEN
247: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
248: 'Insert_Row',
249: 'A', 'C') THEN
250:
251: csp_requirement_headers_cuhk.Create_requirement_header_post

Line 271: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

267:
268:
269: -- Post call to the Vertical Type User Hook
270: --
271: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
272: 'Insert_Row',
273: 'A', 'V') THEN
274:
275: csp_requirement_headers_vuhk.Create_requirement_header_post

Line 347: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';

343: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
344: l_return_status varchar2(100);
345: l_msg_count NUMBER;
346: l_msg_data varchar2(1000);
347: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';
348: l_dml_mode varchar2(10) := p_dml_mode;
349: BEGIN
350: l_requirement_header.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
351: l_requirement_header.CREATED_BY := p_CREATED_BY;

Line 393: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

389: l_dml_mode := 'BOTH';
390: END IF;
391:
392: IF L_dml_mode <> 'POST' THEN
393: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
394: 'Update_Row',
395: 'B', 'C') THEN
396:
397: csp_requirement_headers_cuhk.update_requirement_header_Pre

Line 415: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

411:
412:
413: -- Pre call to the Vertical Type User Hook
414: --
415: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
416: 'Update_Row',
417: 'B', 'V') THEN
418: csp_requirement_headers_vuhk.update_requirement_header_Pre
419: ( px_requirement_header => l_requirement_header,

Line 493: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

489: End If;
490: END IF;
491: --Post hook
492: IF l_dml_mode <> 'PRE' THEN
493: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'C') THEN
496:
497: csp_requirement_headers_cuhk.update_requirement_header_post

Line 515: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

511:
512:
513: -- Pre call to the Vertical Type User Hook
514: --
515: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
516: 'Update_Row',
517: 'A', 'V') THEN
518: csp_requirement_headers_vuhk.update_requirement_header_post
519: ( px_requirement_header => l_requirement_header,

Line 553: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';

549: IS
550: l_return_status varchar2(100);
551: l_msg_count NUMBER;
552: l_msg_data varchar2(1000);
553: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';
554: l_dml_mode varchar2(10) := p_DML_MODE;
555: BEGIN
556: IF l_dml_mode is null THEN
557: l_dml_mode := 'BOTH';

Line 561: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

557: l_dml_mode := 'BOTH';
558: END IF;
559:
560: IF l_dml_mode <> 'POST' THEN
561: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
562: 'Delete_Row',
563: 'B', 'C') THEN
564:
565: csp_requirement_headers_cuhk.Delete_requirement_header_pre

Line 584: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

580:
581:
582: -- Pre call to the Vertical Type User Hook
583: --
584: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
585: 'Delete_Row',
586: 'B', 'V') THEN
587: csp_requirement_headers_vuhk.Delete_requirement_header_pre
588: (

Line 625: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

621: End If;
622: END IF;
623:
624: IF l_dml_mode <> 'PRE' THEN
625: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'C') THEN
628:
629: csp_requirement_headers_cuhk.Delete_requirement_header_post

Line 648: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

644:
645:
646: -- Pre call to the Vertical Type User Hook
647: --
648: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
649: 'Delete_Row',
650: 'A', 'V') THEN
651: csp_requirement_headers_vuhk.Delete_requirement_header_post
652: (

Line 853: End CSP_REQUIREMENT_HEADERS_PKG;

849: APP_EXCEPTION.RAISE_EXCEPTION;
850: End If;
851: END Lock_Row;
852:
853: End CSP_REQUIREMENT_HEADERS_PKG;