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

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 447: CURSOR C2 IS SELECT CSF_DEBRIEF_LINES_S.nextval FROM sys.dual;

443: p_project_task_id number
444: )
445:
446: IS
447: CURSOR C2 IS SELECT CSF_DEBRIEF_LINES_S.nextval FROM sys.dual;
448:
449: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
450: l_return_status varchar2(100);
451: l_msg_count NUMBER;

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 548: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');

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
550: ( px_debrief_line => l_debrief_line,
551: x_return_status => l_return_status,
552: x_msg_count => l_msg_count,

Line 549: csf_debrief_lines_cuhk.Create_debrief_line_Pre

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
550: ( px_debrief_line => l_debrief_line,
551: x_return_status => l_return_status,
552: x_msg_count => l_msg_count,
553: x_msg_data => l_msg_data

Line 555: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);

551: x_return_status => l_return_status,
552: x_msg_count => l_msg_count,
553: x_msg_data => l_msg_data
554: ) ;
555: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);
556: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
557: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
558: --FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
559: --FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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 573: csf_debrief_lines_vuhk.Create_debrief_line_Pre

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
574: ( px_debrief_line => l_debrief_line,
575: x_return_status => l_return_status,
576: x_msg_count => l_msg_count,
577: x_msg_data => l_msg_data

Line 589: --dbms_output.put_line('csf_debrief_lines_iuhk ');

585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: END IF;
589: --dbms_output.put_line('csf_debrief_lines_iuhk ');
590:
591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;

Line 591: csf_debrief_lines_iuhk.Create_debrief_line_Pre

587: END IF;
588: END IF;
589: --dbms_output.put_line('csf_debrief_lines_iuhk ');
590:
591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
594:
595: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);

Line 595: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);

591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
594:
595: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
596: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
597: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
598: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
599: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 620: INSERT INTO CSF_DEBRIEF_LINES(

616: l_debrief_line.DEBRIEF_LINE_ID:= px_DEBRIEF_LINE_ID ;
617: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
618:
619: if l_dml_mode = 'BOTH' then
620: INSERT INTO CSF_DEBRIEF_LINES(
621: DEBRIEF_LINE_ID,
622: DEBRIEF_HEADER_ID,
623: DEBRIEF_LINE_NUMBER,
624: SERVICE_DATE,

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 821: csf_debrief_lines_cuhk.Create_debrief_line_post

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
822: ( px_debrief_line => l_debrief_line,
823: x_return_status => l_return_status,
824: x_msg_count => l_msg_count,
825: x_msg_data => l_msg_data

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 843: csf_debrief_lines_vuhk.Create_debrief_line_post

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,
845: x_return_status => l_return_status,
846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data

Line 859: csf_debrief_lines_iuhk.Create_debrief_line_post

855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857: END IF;
858:
859: csf_debrief_lines_iuhk.Create_debrief_line_post
860: ( x_return_status => l_return_status
861: ) ;
862:
863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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 1212: csf_debrief_lines_cuhk.update_debrief_line_Pre

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
1213: ( px_debrief_line => l_debrief_line,
1214: x_return_status => l_return_status,
1215: x_msg_count => l_msg_count,
1216: x_msg_data => l_msg_data

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 1233: csf_debrief_lines_vuhk.update_debrief_line_Pre

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,
1235: x_return_status => l_return_status,
1236: x_msg_count => l_msg_count,
1237: x_msg_data => l_msg_data

Line 1249: csf_debrief_lines_iuhk.update_debrief_line_Pre

1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247: END IF;
1248: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
1249: csf_debrief_lines_iuhk.update_debrief_line_Pre
1250: ( x_return_status => l_return_status
1251: ) ;
1252:
1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1265: Update CSF_DEBRIEF_LINES

1261: end if;
1262:
1263: if l_dml_mode = 'BOTH' then
1264:
1265: Update CSF_DEBRIEF_LINES
1266: SET
1267: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
1268: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
1269: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),

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 1363: csf_debrief_lines_cuhk.update_debrief_line_Post

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
1364: ( px_debrief_line => l_debrief_line,
1365: x_return_status => l_return_status,
1366: x_msg_count => l_msg_count,
1367: x_msg_data => l_msg_data

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 1384: csf_debrief_lines_vuhk.update_debrief_line_post

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,
1386: x_return_status => l_return_status,
1387: x_msg_count => l_msg_count,
1388: x_msg_data => l_msg_data

Line 1400: csf_debrief_lines_iuhk.update_debrief_line_post

1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398: END IF;
1399:
1400: csf_debrief_lines_iuhk.update_debrief_line_post
1401: ( x_return_status => l_return_status
1402: ) ;
1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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 1436: csf_debrief_lines_cuhk.delete_debrief_line_Pre

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
1437: ( p_line_id => p_DEBRIEF_LINE_ID,
1438: x_return_status => l_return_status,
1439: x_msg_count => l_msg_count,
1440: x_msg_data => l_msg_data

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 1457: csf_debrief_lines_vuhk.delete_debrief_line_Pre

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,
1459: x_return_status => l_return_status,
1460: x_msg_count => l_msg_count,
1461: x_msg_data => l_msg_data

Line 1473: csf_debrief_lines_iuhk.delete_debrief_line_Pre

1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;
1473: csf_debrief_lines_iuhk.delete_debrief_line_Pre
1474: ( x_return_status => l_return_status
1475: ) ;
1476:
1477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1489: DELETE FROM CSF_DEBRIEF_LINES

1485: end if;
1486:
1487: if l_dml_mode = 'BOTH' then
1488:
1489: DELETE FROM CSF_DEBRIEF_LINES
1490: WHERE DEBRIEF_LINE_ID = p_DEBRIEF_LINE_ID;
1491: If (SQL%NOTFOUND) then
1492: RAISE NO_DATA_FOUND;
1493: End If;

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 1502: csf_debrief_lines_cuhk.delete_debrief_line_post

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
1503: ( p_line_id => p_DEBRIEF_LINE_ID,
1504: x_return_status => l_return_status,
1505: x_msg_count => l_msg_count,
1506: x_msg_data => l_msg_data

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 1523: csf_debrief_lines_vuhk.delete_debrief_line_post

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,
1525: x_return_status => l_return_status,
1526: x_msg_count => l_msg_count,
1527: x_msg_data => l_msg_data

Line 1539: csf_debrief_lines_iuhk.delete_debrief_line_post

1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1536: END IF;
1537: END IF;
1538:
1539: csf_debrief_lines_iuhk.delete_debrief_line_post
1540: ( x_return_status => l_return_status
1541: ) ;
1542:
1543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1627: FROM CSF_DEBRIEF_LINES

1623: )
1624: IS
1625: CURSOR C IS
1626: SELECT *
1627: FROM CSF_DEBRIEF_LINES
1628: WHERE DEBRIEF_LINE_ID = p_DEBRIEF_LINE_ID
1629: FOR UPDATE of DEBRIEF_LINE_ID NOWAIT;
1630: Recinfo C%ROWTYPE;
1631: BEGIN

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: