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.OKC_REPORT_PVT dependencies on OKC_REPORT_PVT

Line 1: package body OKC_REPORT_PVT as

1: package body OKC_REPORT_PVT as
2: /* $Header: OKCRXPKB.pls 120.3 2005/08/16 16:35:18 jkodiyan noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

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 457: x_xml_text := EncodeClob('Error: OKC_REPORT_PVT.get_xml', l_msg_data);

453: x_return_status := 'E';
454: x_msg_count := 1;
455: l_msg_data := profile_check_msg('OKC_WEB_REPORT');
456: x_msg_data := l_msg_data;
457: x_xml_text := EncodeClob('Error: OKC_REPORT_PVT.get_xml', l_msg_data);
458: x_clob_status := 'I';
459: return;
460: elsif (l_cached = 'N' or G_ignore_cache = 'Y') then
461: x_return_status := 'S';

Line 538: x_xml_text := EncodeClob('Error: OKC_REPORT_PVT.get_xml', l_msg_data);

534: x_return_status := 'E';
535: x_msg_count := 1;
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:

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 659: x_htm_text := EncodeClob('Error: OKC_REPORT_PVT.get_htm', l_msg_data);

655: x_return_status := 'E';
656: x_msg_count := 1;
657: l_msg_data := profile_check_msg('OKC_WEB_REPORT');
658: x_msg_data := l_msg_data;
659: x_htm_text := EncodeClob('Error: OKC_REPORT_PVT.get_htm', l_msg_data);
660: x_clob_status := 'I';
661: return;
662: end if;
663: --

Line 753: x_htm_text := EncodeClob('Error: OKC_REPORT_PVT.get_htm', l_msg_data);

749: x_return_status := 'E';
750: x_msg_count := 1;
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:

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 1119: -- site level value sample: 'OKC_REPORT_PVT.prerun'

1115: --
1116: -- PURPOSE
1117: --
1118: -- procedure executes profile option
1119: -- site level value sample: 'OKC_REPORT_PVT.prerun'
1120: -- published only for jsp apps
1121: -- in forms apps call included in get_contract_url
1122: --
1123: -- signature of the procedure defined in profile option

Line 1124: -- should be the same as the sample OKC_REPORT_PVT.prerun

1120: -- published only for jsp apps
1121: -- in forms apps call included in get_contract_url
1122: --
1123: -- signature of the procedure defined in profile option
1124: -- should be the same as the sample OKC_REPORT_PVT.prerun
1125: --
1126: procedure exec_OKC_WEB_PRERUN(
1127: -- standard parameters
1128: p_api_version in NUMBER ,

Line 1145: if (upper(l_value) = 'OKC_REPORT_PVT.PRERUN') then

1141: if (l_value is NULL) then
1142: x_return_status := 'S';
1143: return;
1144: end if;
1145: if (upper(l_value) = 'OKC_REPORT_PVT.PRERUN') then
1146: OKC_REPORT_PVT.prerun(
1147: p_api_version => p_api_version,
1148: p_init_msg_list => p_init_msg_list,
1149: x_return_status => x_return_status,

Line 1146: OKC_REPORT_PVT.prerun(

1142: x_return_status := 'S';
1143: return;
1144: end if;
1145: if (upper(l_value) = 'OKC_REPORT_PVT.PRERUN') then
1146: OKC_REPORT_PVT.prerun(
1147: p_api_version => p_api_version,
1148: p_init_msg_list => p_init_msg_list,
1149: x_return_status => x_return_status,
1150: x_msg_count => x_msg_count,

Line 1195: -- site level value sample: 'OKC_REPORT_PVT.noop'

1191: --
1192: -- PURPOSE
1193: --
1194: -- procedure executes profile option
1195: -- site level value sample: 'OKC_REPORT_PVT.noop'
1196: -- noop means No Operation (knowhow belongs to WF team)
1197: -- called from bean both for FRM and JSP applications
1198: -- when real transformation happens, not just retrieve
1199: -- from cache

Line 1202: -- should be the same as the sample OKC_REPORT_PVT.noop

1198: -- when real transformation happens, not just retrieve
1199: -- from cache
1200: --
1201: -- signature of the procedure defined in profile option
1202: -- should be the same as the sample OKC_REPORT_PVT.noop
1203: --
1204: procedure exec_OKC_WEB_LOG_RUN(
1205: -- standard parameters
1206: p_api_version in NUMBER ,

Line 1223: if (upper(l_value) = 'OKC_REPORT_PVT.NOOP') then

1219: if (l_value is NULL) then
1220: x_return_status := 'S';
1221: return;
1222: end if;
1223: if (upper(l_value) = 'OKC_REPORT_PVT.NOOP') then
1224: OKC_REPORT_PVT.noop(
1225: p_api_version => p_api_version,
1226: p_init_msg_list => p_init_msg_list,
1227: x_return_status => x_return_status,

Line 1224: OKC_REPORT_PVT.noop(

1220: x_return_status := 'S';
1221: return;
1222: end if;
1223: if (upper(l_value) = 'OKC_REPORT_PVT.NOOP') then
1224: OKC_REPORT_PVT.noop(
1225: p_api_version => p_api_version,
1226: p_init_msg_list => p_init_msg_list,
1227: x_return_status => x_return_status,
1228: x_msg_count => x_msg_count,

Line 1274: -- fnd_utilities.open_url(okc_report_pvt.report_url(:p_chr_id));

1270: --
1271: -- PURPOSE
1272: --
1273: -- produces url to print contract from form:
1274: -- fnd_utilities.open_url(okc_report_pvt.report_url(:p_chr_id));
1275: -- takes care this url not reusable
1276: --
1277: procedure get_contract_url(
1278: -- standard parameters

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

Line 2196: p_proc => 'begin OKC_REPORT_PVT.document_link('

2192: x_msg_data => x_msg_data,
2193: p_recipient => P_RECIPIENT,
2194: p_msg_subj => P_SUBJECT,
2195: p_msg_body => P_BODY,
2196: p_proc => 'begin OKC_REPORT_PVT.document_link('
2197: ||'p_kid => '||p_chr_id||','
2198: ||'p_vid => '||NVL(to_char(p_major_version),'NULL')||','
2199: ||'p_xid => '||P_XID||','
2200: ||'p_document => '||':1); end;');

Line 2232: p_proc => 'begin OKC_REPORT_PVT.document_link('

2228: x_msg_data => x_msg_data,
2229: p_recipient => p_recipient,
2230: p_msg_subj => p_subject,
2231: p_msg_body => p_body,
2232: p_proc => 'begin OKC_REPORT_PVT.document_link('
2233: ||'p_kid => '||p_chr_id||','
2234: ||'p_vid => '||NVL(to_char(p_major_version),'NULL')||','
2235: ||'p_xid => '||P_XST_ID||','
2236: ||'p_document => '||':1); end;');

Line 2414: end OKC_REPORT_PVT;

2410: if (not(success)) then return NULL; end if;
2411: return fnd_submit.submit_set(null,FALSE);
2412: end;
2413:
2414: end OKC_REPORT_PVT;