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.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.9.12020000.8 2013/04/26 10:29:00 shadas 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.9.12020000.8 2013/04/26 10:29:00 shadas 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 log(p_procedure in varchar2,p_message in varchar2) as
14: begin

Line 19: 'csf.plsql.csf_debrief_lines_pkg.'||p_procedure,

15: --dbms_output.put_line(p_procedure||' - '||p_message);
16: --insert into temp_log values(sysdate, p_procedure, p_message);
17: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
18: fnd_log.string(fnd_log.level_statement,
19: 'csf.plsql.csf_debrief_lines_pkg.'||p_procedure,
20: p_message);
21: end if;
22: end;
23:

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

449: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
450: l_return_status varchar2(100);
451: l_msg_count NUMBER;
452: l_msg_data varchar2(1000);
453: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.INSERT_ROW';
454: l_dml_mode varchar2(10) := p_DML_mode;
455: BEGIN
456: --dbms_output.put_line('Inserting Row ');
457: l_debrief_line.DEBRIEF_LINE_ID:= px_DEBRIEF_LINE_ID ;

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

541: l_dml_mode := 'BOTH';
542: end if;
543:
544: if l_dml_mode <> 'POST' then
545: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
546: 'Insert_Row',
547: 'B', 'C') THEN
548: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');
549: csf_debrief_lines_cuhk.Create_debrief_line_Pre

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

565:
566: --dbms_output.put_line('Again Hook ');
567: -- Pre call to the Vertical Type User Hook
568: --
569: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
570: 'Insert_Row',
571: 'B', 'V') THEN
572: --dbms_output.put_line('Pre Called ');
573: csf_debrief_lines_vuhk.Create_debrief_line_Pre

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

813: end if;
814: end if;
815: */
816:
817: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
818: 'Insert_Row',
819: 'B', 'C') THEN
820: --dbms_output.put_line('CREATE LINE POST ');
821: csf_debrief_lines_cuhk.Create_debrief_line_post

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

836:
837:
838: -- Pre call to the Vertical Type User Hook
839: --
840: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
841: 'Insert_Row',
842: 'B', 'V') THEN
843: csf_debrief_lines_vuhk.Create_debrief_line_post
844: ( px_debrief_line => l_debrief_line,

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

1112: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1113: l_return_status varchar2(100);
1114: l_msg_count NUMBER;
1115: l_msg_data varchar2(1000);
1116: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.UPDATE_ROW';
1117: l_dml_mode varchar2(10) := p_DML_mode;
1118: BEGIN
1119: l_debrief_line.DEBRIEF_LINE_ID:= p_DEBRIEF_LINE_ID ;
1120: l_debrief_line.DEBRIEF_HEADER_ID:= p_DEBRIEF_HEADER_ID ;

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

1204: l_debrief_line.project_task_id := p_project_task_id;
1205:
1206: if l_dml_mode <> 'POST' then
1207:
1208: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1209: 'Update_Row',
1210: 'B', 'C') THEN
1211:
1212: csf_debrief_lines_cuhk.update_debrief_line_Pre

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

1226:
1227:
1228: -- Pre call to the Vertical Type User Hook
1229: --
1230: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1231: 'Insert_Row',
1232: 'B', 'V') THEN
1233: csf_debrief_lines_vuhk.update_debrief_line_Pre
1234: ( px_debrief_line => l_debrief_line,

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

1355: end if;
1356:
1357: if l_dml_mode <> 'PRE' then
1358:
1359: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1360: 'Insert_Row',
1361: 'A', 'C') THEN
1362:
1363: csf_debrief_lines_cuhk.update_debrief_line_Post

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

1377:
1378:
1379: -- Pre call to the Vertical Type User Hook
1380: --
1381: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1382: 'Insert_Row',
1383: 'A', 'V') THEN
1384: csf_debrief_lines_vuhk.update_debrief_line_post
1385: ( px_debrief_line => l_debrief_line,

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

1420: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1421: l_return_status varchar2(100);
1422: l_msg_count NUMBER;
1423: l_msg_data varchar2(1000);
1424: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.DELETE_ROW';
1425: l_dml_mode varchar2(10) := p_DML_mode;
1426: BEGIN
1427: if l_dml_mode is null then
1428: l_dml_mode := 'BOTH';

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

1428: l_dml_mode := 'BOTH';
1429: end if;
1430:
1431: if l_dml_mode <> 'POST' then
1432: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1433: 'Delete_Row',
1434: 'B', 'C') THEN
1435:
1436: csf_debrief_lines_cuhk.delete_debrief_line_Pre

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

1450:
1451:
1452: -- Pre call to the Vertical Type User Hook
1453: --
1454: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1455: 'Delete_Row',
1456: 'B', 'V') THEN
1457: csf_debrief_lines_vuhk.delete_debrief_line_Pre
1458: ( p_line_id => p_DEBRIEF_LINE_ID,

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

1494: end if;
1495:
1496: if l_dml_mode <> 'PRE' then
1497:
1498: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',
1499: 'Delete_Row',
1500: 'A', 'C') THEN
1501:
1502: csf_debrief_lines_cuhk.delete_debrief_line_post

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

1516:
1517:
1518: -- Pre call to the Vertical Type User Hook
1519: --
1520: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
1521: 'Insert_Row',
1522: 'A', 'V') THEN
1523: csf_debrief_lines_vuhk.delete_debrief_line_post
1524: ( p_line_id => p_DEBRIEF_LINE_ID,

Line 1870: End CSF_DEBRIEF_LINES_PKG;

1866: close resource_name;
1867: return l_resource_name;
1868: end;
1869:
1870: End CSF_DEBRIEF_LINES_PKG;
1871: