DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_HEADERS_PKG

Line 1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as

1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as
2: /* $Header: csftdbhb.pls 120.6 2008/05/12 06:23:37 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSF_DEBRIEF_HEADERS_PKG

1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as
2: /* $Header: csftdbhb.pls 120.6 2008/05/12 06:23:37 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 49: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.INSERT_ROW';

45: )
46:
47: IS
48: CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;
49: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.INSERT_ROW';
50: l_debrief_header CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
51: l_return_status varchar2(100);
52: l_msg_count NUMBER;
53: l_msg_data varchar2(1000);

Line 93: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

89: l_dml_mode := 'BOTH';
90: END IF;
91:
92: IF l_dml_mode <> 'POST' THEN
93: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
94: 'Insert_Row',
95: 'B', 'C') THEN
96:
97: csf_debrief_headers_cuhk.Create_debrief_header_Pre

Line 116: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

112:
113:
114: -- Pre call to the Vertical Type User Hook
115: --
116: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
117: 'Insert_Row',
118: 'B', 'V') THEN
119: csf_debrief_headers_vuhk.Create_debrief_header_Pre
120: ( px_debrief_header => l_debrief_header,

Line 226: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

222: );
223: END IF;
224:
225: IF l_dml_mode <> 'PRE' THEN
226: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
227: 'Insert_Row',
228: 'A', 'C') THEN
229:
230: csf_debrief_headers_cuhk.Create_debrief_header_post

Line 249: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

245:
246:
247: -- Pre call to the Vertical Type User Hook
248: --
249: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
250: 'Insert_Row',
251: 'A', 'V') THEN
252: csf_debrief_headers_vuhk.Create_debrief_header_post
253: ( px_debrief_header => l_debrief_header,

Line 331: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.UPDATE_ROW';

327: p_DML_mode VARCHAR2
328: )
329:
330: IS
331: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.UPDATE_ROW';
332: l_debrief_header CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
333: l_return_status varchar2(100);
334: l_msg_count NUMBER;
335: l_msg_data varchar2(1000);

Line 374: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

370: l_dml_mode := 'BOTH';
371: end if;
372:
373: if l_dml_mode <> 'POST' then
374: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
375: 'Update_Row',
376: 'B', 'C') THEN
377:
378: csf_debrief_headers_cuhk.update_debrief_header_Pre

Line 397: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

393:
394:
395: -- Pre call to the Vertical Type User Hook
396: --
397: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
398: 'Update_Row',
399: 'B', 'V') THEN
400: csf_debrief_headers_vuhk.update_debrief_header_Pre
401: ( px_debrief_header => l_debrief_header,

Line 470: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

466: End If;
467: end if;
468:
469: if l_dml_mode <> 'PRE' then
470: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
471: 'Update_Row',
472: 'A', 'C') THEN
473:
474: csf_debrief_headers_cuhk.update_debrief_header_post

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

489:
490:
491: -- Pre call to the Vertical Type User Hook
492: --
493: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'V') THEN
496: csf_debrief_headers_vuhk.update_debrief_header_post
497: ( px_debrief_header => l_debrief_header,

Line 531: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.DELETE_ROW';

527: IS
528: l_return_status varchar2(100);
529: l_msg_count NUMBER;
530: l_msg_data varchar2(1000);
531: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.DELETE_ROW';
532: l_dml_mode varchar2(10) := p_DML_mode;
533: BEGIN
534:
535: if l_dml_mode is null then

Line 540: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

536: l_dml_mode := 'BOTH';
537: end if;
538:
539: if l_dml_mode <> 'POST' then
540: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
541: 'Delete_Row',
542: 'B', 'C') THEN
543:
544: csf_debrief_headers_cuhk.delete_debrief_header_Pre

Line 562: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

558: END IF;
559:
560: -- Pre call to the Vertical Type User Hook
561: --
562: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
563: 'Delete_Row',
564: 'B', 'V') THEN
565: csf_debrief_headers_vuhk.delete_debrief_header_Pre
566: ( p_header_id => p_DEBRIEF_HEADER_ID,

Line 602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

598: End If;
599: end if;
600:
601: if l_dml_mode <> 'PRE' then
602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
603: 'Delete_Row',
604: 'A', 'C') THEN
605:
606: csf_debrief_headers_cuhk.delete_debrief_header_Post

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

621:
622:
623: -- Pre call to the Vertical Type User Hook
624: --
625: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'V') THEN
628: csf_debrief_headers_vuhk.delete_debrief_header_post
629: ( p_header_id => p_DEBRIEF_HEADER_ID,

Line 821: END CSF_DEBRIEF_HEADERS_PKG;

817: close resource_name;
818: return l_resource_name;
819: end;
820:
821: END CSF_DEBRIEF_HEADERS_PKG;