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.OKS_RULE_MIGRATE dependencies on DBMS_SQL

Line 412: trunc_curs := DBMS_SQL.OPEN_CURSOR;

408: -- Code to validate the Header rule. --
409: -------------------------------------------------------------------------------------------
410: IF (FND_CONC_GLOBAL.request_data is null) THEN
411:
412: trunc_curs := DBMS_SQL.OPEN_CURSOR;
413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
414: rc := dbms_sql.execute(trunc_curs);
415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
416:

Line 413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

409: -------------------------------------------------------------------------------------------
410: IF (FND_CONC_GLOBAL.request_data is null) THEN
411:
412: trunc_curs := DBMS_SQL.OPEN_CURSOR;
413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
414: rc := dbms_sql.execute(trunc_curs);
415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
416:
417:

Line 414: rc := dbms_sql.execute(trunc_curs);

410: IF (FND_CONC_GLOBAL.request_data is null) THEN
411:
412: trunc_curs := DBMS_SQL.OPEN_CURSOR;
413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
414: rc := dbms_sql.execute(trunc_curs);
415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
416:
417:
418: If (p_status is null and p_org_id is null ) then

Line 415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

411:
412: trunc_curs := DBMS_SQL.OPEN_CURSOR;
413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
414: rc := dbms_sql.execute(trunc_curs);
415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
416:
417:
418: If (p_status is null and p_org_id is null ) then
419: -- The following csr is on OKC_RULE_GROUPS_B

Line 502: trunc_curs := DBMS_SQL.OPEN_CURSOR;

498: -- Code to validate the Header History rule. --
499: -------------------------------------------------------------------------------------------
500: IF (FND_CONC_GLOBAL.request_data is null) THEN
501:
502: trunc_curs := DBMS_SQL.OPEN_CURSOR;
503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:

Line 503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

499: -------------------------------------------------------------------------------------------
500: IF (FND_CONC_GLOBAL.request_data is null) THEN
501:
502: trunc_curs := DBMS_SQL.OPEN_CURSOR;
503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:
507: If (p_status is null and p_org_id is null ) then

Line 504: rc := dbms_sql.execute(trunc_curs);

500: IF (FND_CONC_GLOBAL.request_data is null) THEN
501:
502: trunc_curs := DBMS_SQL.OPEN_CURSOR;
503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:
507: If (p_status is null and p_org_id is null ) then
508: -- The following csr is on OKC_RULE_GROUPS_BH

Line 505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

501:
502: trunc_curs := DBMS_SQL.OPEN_CURSOR;
503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:
507: If (p_status is null and p_org_id is null ) then
508: -- The following csr is on OKC_RULE_GROUPS_BH
509: open l_hdr_agg_csr3;

Line 591: trunc_curs := DBMS_SQL.OPEN_CURSOR;

587: -- Code to validate the Line rule. --
588: -------------------------------------------------------------------------------------------
589: IF (FND_CONC_GLOBAL.request_data is null) THEN
590:
591: trunc_curs := DBMS_SQL.OPEN_CURSOR;
592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
593: rc := dbms_sql.execute(trunc_curs);
594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
595:

Line 592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

588: -------------------------------------------------------------------------------------------
589: IF (FND_CONC_GLOBAL.request_data is null) THEN
590:
591: trunc_curs := DBMS_SQL.OPEN_CURSOR;
592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
593: rc := dbms_sql.execute(trunc_curs);
594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
595:
596: If (p_status is null and p_org_id is null ) then

Line 593: rc := dbms_sql.execute(trunc_curs);

589: IF (FND_CONC_GLOBAL.request_data is null) THEN
590:
591: trunc_curs := DBMS_SQL.OPEN_CURSOR;
592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
593: rc := dbms_sql.execute(trunc_curs);
594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
595:
596: If (p_status is null and p_org_id is null ) then
597: -- The following csr is on OKC_RULE_GROUPS_B

Line 594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

590:
591: trunc_curs := DBMS_SQL.OPEN_CURSOR;
592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
593: rc := dbms_sql.execute(trunc_curs);
594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
595:
596: If (p_status is null and p_org_id is null ) then
597: -- The following csr is on OKC_RULE_GROUPS_B
598: open l_hdr_agg_csr1;

Line 676: trunc_curs := DBMS_SQL.OPEN_CURSOR;

672: -- Code to validate the Line History rule. --
673: -------------------------------------------------------------------------------------------
674: IF (FND_CONC_GLOBAL.request_data is null) THEN
675:
676: trunc_curs := DBMS_SQL.OPEN_CURSOR;
677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
678: rc := dbms_sql.execute(trunc_curs);
679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
680:

Line 677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

673: -------------------------------------------------------------------------------------------
674: IF (FND_CONC_GLOBAL.request_data is null) THEN
675:
676: trunc_curs := DBMS_SQL.OPEN_CURSOR;
677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
678: rc := dbms_sql.execute(trunc_curs);
679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
680:
681: If (p_status is null and p_org_id is null ) then

Line 678: rc := dbms_sql.execute(trunc_curs);

674: IF (FND_CONC_GLOBAL.request_data is null) THEN
675:
676: trunc_curs := DBMS_SQL.OPEN_CURSOR;
677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
678: rc := dbms_sql.execute(trunc_curs);
679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
680:
681: If (p_status is null and p_org_id is null ) then
682: -- The following csr is on OKC_RULE_GROUPS_B

Line 679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

675:
676: trunc_curs := DBMS_SQL.OPEN_CURSOR;
677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
678: rc := dbms_sql.execute(trunc_curs);
679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
680:
681: If (p_status is null and p_org_id is null ) then
682: -- The following csr is on OKC_RULE_GROUPS_B
683: open l_hdr_agg_csr3;

Line 763: trunc_curs := DBMS_SQL.OPEN_CURSOR;

759: -- Code to validate the ALL rules. --
760: -------------------------------------------------------------------------------------------
761: IF (FND_CONC_GLOBAL.request_data is null) THEN
762:
763: trunc_curs := DBMS_SQL.OPEN_CURSOR;
764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
765: rc := dbms_sql.execute(trunc_curs);
766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:

Line 764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

760: -------------------------------------------------------------------------------------------
761: IF (FND_CONC_GLOBAL.request_data is null) THEN
762:
763: trunc_curs := DBMS_SQL.OPEN_CURSOR;
764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
765: rc := dbms_sql.execute(trunc_curs);
766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:
768:

Line 765: rc := dbms_sql.execute(trunc_curs);

761: IF (FND_CONC_GLOBAL.request_data is null) THEN
762:
763: trunc_curs := DBMS_SQL.OPEN_CURSOR;
764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
765: rc := dbms_sql.execute(trunc_curs);
766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:
768:
769: If (p_status is null and p_org_id is null ) then

Line 766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

762:
763: trunc_curs := DBMS_SQL.OPEN_CURSOR;
764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
765: rc := dbms_sql.execute(trunc_curs);
766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:
768:
769: If (p_status is null and p_org_id is null ) then
770: -- The following csr is on OKC_RULE_GROUPS_BH

Line 39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;

38997: -------------------------------------------------------------------------------------
38998: -- Code for Synchronization phase --
38999: -------------------------------------------------------------------------------------
39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;
39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
39003: rc := dbms_sql.execute(trunc_curs);
39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
39005:

Line 39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);

38998: -- Code for Synchronization phase --
38999: -------------------------------------------------------------------------------------
39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;
39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
39003: rc := dbms_sql.execute(trunc_curs);
39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
39005:
39006: OPEN L_UPGRADE_CNT_CSR;

Line 39003: rc := dbms_sql.execute(trunc_curs);

38999: -------------------------------------------------------------------------------------
39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;
39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
39003: rc := dbms_sql.execute(trunc_curs);
39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
39005:
39006: OPEN L_UPGRADE_CNT_CSR;
39007: FETCH L_UPGRADE_CNT_CSR INTO L_UPGRD_CNT;

Line 39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;
39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
39003: rc := dbms_sql.execute(trunc_curs);
39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
39005:
39006: OPEN L_UPGRADE_CNT_CSR;
39007: FETCH L_UPGRADE_CNT_CSR INTO L_UPGRD_CNT;
39008: CLOSE L_UPGRADE_CNT_CSR;