APPS.OKC_REPORT_PVT dependencies on DBMS_TRANSACTION

Line 447: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');

443: and M.LAST_UPDATE_DATE > pp_sql_date
444: and M.XML_TEXT is not NULL
445: ;
446: begin
447: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');
448:
449: open sql_csr(G_xid);
450: fetch sql_csr into l_cached, l_sql_date, l_sql_id;
451: close sql_csr;

Line 540: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');

536: l_msg_data := cache_locked_msg('XML');
537: x_msg_data := l_msg_data;
538: x_xml_text := EncodeClob('Error: OKC_REPORT_PVT.get_xml', l_msg_data);
539: x_clob_status := 'I';
540: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');
541: end;
542:
543: --
544: -- PROCEDURE/Function

Line 649: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');

645: and H.LAST_UPDATE_DATE > pp_xst_date
646: and H.HTM_TEXT is not NULL
647: ;
648: begin
649: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');
650:
651: open xst_csr(G_xid);
652: fetch xst_csr into l_cached;
653: close xst_csr;

Line 755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');

751: l_msg_data := cache_locked_msg('HTM');
752: x_msg_data := l_msg_data;
753: x_htm_text := EncodeClob('Error: OKC_REPORT_PVT.get_htm', l_msg_data);
754: x_clob_status := 'I';
755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');
756: end;
757:
758:
759: --

Line 1304: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');

1300: for update of last_update_date, last_updated_by
1301: nowait;
1302: l_dummy varchar2(1) := '?';
1303: begin
1304: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');
1305:
1306: exec_OKC_WEB_PRERUN(
1307: p_api_version,
1308: p_init_msg_list,

Line 1317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');

1313: -- p_major_version,
1314: -- p_scn_id
1315: );
1316: if (x_return_status<>'S') then
1317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');
1318: return;
1319: end if;
1320:
1321: --

Line 1345: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');

1341: exception when others then
1342: x_return_status := 'E';
1343: x_msg_count := 1;
1344: x_msg_data := failed_lock;
1345: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');
1346: end;
1347:
1348: --
1349: -- PROCEDURE/Function

Line 1378: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');

1374: for update of last_update_date
1375: nowait;
1376: l_dummy varchar2(1) := '?';
1377: begin
1378: DBMS_TRANSACTION.SAVEPOINT('OKC_REPORT_PVT');
1379: open k_header_csr;
1380: fetch k_header_csr into l_dummy;
1381: close k_header_csr;
1382: if l_dummy = '?' then

Line 1397: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');

1393: exception when others then
1394: x_return_status := 'E';
1395: x_msg_count := 1;
1396: x_msg_data := failed_session;
1397: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('OKC_REPORT_PVT');
1398: end;
1399:
1400: --
1401: -- PROCEDURE/Function