APPS.OKS_UPGRADE_PRECHECK dependencies on DBMS_SQL

Line 998: l_var := dbms_sql.open_cursor;

994: l_string := 'CREATE INDEX COV_SCH_ID_N10 ON MTL_SYSTEM_ITEMS_B(COVERAGE_SCHEDULE_ID)';
995:
996: BEGIN
997:
998: l_var := dbms_sql.open_cursor;
999: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1000: rc := dbms_sql.execute(l_var);
1001: dbms_sql.close_cursor(l_var);
1002: END;

Line 999: dbms_sql.parse(l_var ,l_string,dbms_sql.native);

995:
996: BEGIN
997:
998: l_var := dbms_sql.open_cursor;
999: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1000: rc := dbms_sql.execute(l_var);
1001: dbms_sql.close_cursor(l_var);
1002: END;
1003:

Line 1000: rc := dbms_sql.execute(l_var);

996: BEGIN
997:
998: l_var := dbms_sql.open_cursor;
999: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1000: rc := dbms_sql.execute(l_var);
1001: dbms_sql.close_cursor(l_var);
1002: END;
1003:
1004:

Line 1001: dbms_sql.close_cursor(l_var);

997:
998: l_var := dbms_sql.open_cursor;
999: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1000: rc := dbms_sql.execute(l_var);
1001: dbms_sql.close_cursor(l_var);
1002: END;
1003:
1004:
1005: End if;

Line 1017: l_var := dbms_sql.open_cursor;

1013:
1014: l_string := 'create index okc_k_lines_b_upg on okc_k_lines_b(upg_orig_system_ref,upg_orig_system_ref_id)';
1015:
1016: BEGIN
1017: l_var := dbms_sql.open_cursor;
1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1019: rc := dbms_sql.execute(l_var);
1020: dbms_sql.close_cursor(l_var);
1021: END;

Line 1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);

1014: l_string := 'create index okc_k_lines_b_upg on okc_k_lines_b(upg_orig_system_ref,upg_orig_system_ref_id)';
1015:
1016: BEGIN
1017: l_var := dbms_sql.open_cursor;
1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1019: rc := dbms_sql.execute(l_var);
1020: dbms_sql.close_cursor(l_var);
1021: END;
1022:

Line 1019: rc := dbms_sql.execute(l_var);

1015:
1016: BEGIN
1017: l_var := dbms_sql.open_cursor;
1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1019: rc := dbms_sql.execute(l_var);
1020: dbms_sql.close_cursor(l_var);
1021: END;
1022:
1023: end if;

Line 1020: dbms_sql.close_cursor(l_var);

1016: BEGIN
1017: l_var := dbms_sql.open_cursor;
1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);
1019: rc := dbms_sql.execute(l_var);
1020: dbms_sql.close_cursor(l_var);
1021: END;
1022:
1023: end if;
1024: