DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_LINES_PKG dependencies on CSF_DEBRIEF_LINES_PKG

Line 1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as

1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as
2: /* $Header: csftdblb.pls 120.2.12010000.2 2008/08/05 18:21:24 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_LINES_PKG
5: -- Purpose :

Line 4: -- Package name : CSF_DEBRIEF_LINES_PKG

1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as
2: /* $Header: csftdblb.pls 120.2.12010000.2 2008/08/05 18:21:24 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_LINES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_LINES_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_LINES_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csftdblb.pls';
12:
13: PROCEDURE Insert_Row(
14: px_DEBRIEF_LINE_ID IN OUT NOCOPY NUMBER,

Line 91: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.INSERT_ROW';

87: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
88: l_return_status varchar2(100);
89: l_msg_count NUMBER;
90: l_msg_data varchar2(1000);
91: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.INSERT_ROW';
92: l_dml_mode varchar2(10) := p_DML_mode;
93: BEGIN
94: --dbms_output.put_line('Inserting Row ');
95: l_debrief_line.DEBRIEF_LINE_ID:= px_DEBRIEF_LINE_ID ;

Line 170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

166: l_dml_mode := 'BOTH';
167: end if;
168:
169: if l_dml_mode <> 'POST' then
170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
171: 'Insert_Row',
172: 'B', 'C') THEN
173: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');
174: csf_debrief_lines_cuhk.Create_debrief_line_Pre

Line 194: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

190:
191: --dbms_output.put_line('Again Hook ');
192: -- Pre call to the Vertical Type User Hook
193: --
194: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
195: 'Insert_Row',
196: 'B', 'V') THEN
197: --dbms_output.put_line('Pre Called ');
198: csf_debrief_lines_vuhk.Create_debrief_line_Pre

Line 388: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

384: end if;
385:
386: -- dbms_output.put_line('INSERTED ');
387: if l_dml_mode <> 'PRE' then
388: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
389: 'Insert_Row',
390: 'B', 'C') THEN
391: --dbms_output.put_line('CREATE LINE POST ');
392: csf_debrief_lines_cuhk.Create_debrief_line_post

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

407:
408:
409: -- Pre call to the Vertical Type User Hook
410: --
411: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
412: 'Insert_Row',
413: 'B', 'V') THEN
414: csf_debrief_lines_vuhk.Create_debrief_line_post
415: ( px_debrief_line => l_debrief_line,

Line 522: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.UPDATE_ROW';

518: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
519: l_return_status varchar2(100);
520: l_msg_count NUMBER;
521: l_msg_data varchar2(1000);
522: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.UPDATE_ROW';
523: l_dml_mode varchar2(10) := p_DML_mode;
524: BEGIN
525: l_debrief_line.DEBRIEF_LINE_ID:= p_DEBRIEF_LINE_ID ;
526: l_debrief_line.DEBRIEF_HEADER_ID:= p_DEBRIEF_HEADER_ID ;

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

598:
599:
600: if l_dml_mode <> 'POST' then
601:
602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
603: 'Update_Row',
604: 'B', 'C') THEN
605:
606: csf_debrief_lines_cuhk.update_debrief_line_Pre

Line 624: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

620:
621:
622: -- Pre call to the Vertical Type User Hook
623: --
624: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
625: 'Insert_Row',
626: 'B', 'V') THEN
627: csf_debrief_lines_vuhk.update_debrief_line_Pre
628: ( px_debrief_line => l_debrief_line,

Line 740: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

736: end if;
737:
738: if l_dml_mode <> 'PRE' then
739:
740: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
741: 'Insert_Row',
742: 'A', 'C') THEN
743:
744: csf_debrief_lines_cuhk.update_debrief_line_Post

Line 762: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

758:
759:
760: -- Pre call to the Vertical Type User Hook
761: --
762: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
763: 'Insert_Row',
764: 'A', 'V') THEN
765: csf_debrief_lines_vuhk.update_debrief_line_post
766: ( px_debrief_line => l_debrief_line,

Line 805: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.DELETE_ROW';

801: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
802: l_return_status varchar2(100);
803: l_msg_count NUMBER;
804: l_msg_data varchar2(1000);
805: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.DELETE_ROW';
806: l_dml_mode varchar2(10) := p_DML_mode;
807: BEGIN
808: if l_dml_mode is null then
809: l_dml_mode := 'BOTH';

Line 813: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

809: l_dml_mode := 'BOTH';
810: end if;
811:
812: if l_dml_mode <> 'POST' then
813: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
814: 'Delete_Row',
815: 'B', 'C') THEN
816:
817: csf_debrief_lines_cuhk.delete_debrief_line_Pre

Line 835: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

831:
832:
833: -- Pre call to the Vertical Type User Hook
834: --
835: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
836: 'Delete_Row',
837: 'B', 'V') THEN
838: csf_debrief_lines_vuhk.delete_debrief_line_Pre
839: ( p_line_id => p_DEBRIEF_LINE_ID,

Line 879: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',

875: end if;
876:
877: if l_dml_mode <> 'PRE' then
878:
879: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',
880: 'Delete_Row',
881: 'A', 'C') THEN
882:
883: csf_debrief_lines_cuhk.delete_debrief_line_post

Line 901: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

897:
898:
899: -- Pre call to the Vertical Type User Hook
900: --
901: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
902: 'Insert_Row',
903: 'A', 'V') THEN
904: csf_debrief_lines_vuhk.delete_debrief_line_post
905: ( p_line_id => p_DEBRIEF_LINE_ID,

Line 1253: End CSF_DEBRIEF_LINES_PKG;

1249: return l_resource_name;
1250: end;
1251:
1252:
1253: End CSF_DEBRIEF_LINES_PKG;
1254: