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

Line 26: cid := DBMS_SQL.open_cursor;

22: return true if entry does not exist */
23:
24: begin
25: edw_misc_util.globalNamesOff;
26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then

Line 27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);

23:
24: begin
25: edw_misc_util.globalNamesOff;
26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);

Line 28: dbms_sql.define_column(cid, 1, dummy);

24: begin
25: edw_misc_util.globalNamesOff;
26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
32: if (dummy > 0) then /* throw error message */

Line 29: l_dummy:=dbms_sql.execute(cid);

25: edw_misc_util.globalNamesOff;
26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
32: if (dummy > 0) then /* throw error message */
33: /*fnd_message.set_name('BIS', 'EDW_SOURCE_ALREADY_PRESENT');

Line 30: if dbms_sql.fetch_rows(cid)<>0 then

26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
32: if (dummy > 0) then /* throw error message */
33: /*fnd_message.set_name('BIS', 'EDW_SOURCE_ALREADY_PRESENT');
34: fnd_message.set_token('NAME',

Line 31: dbms_sql.column_value(cid, 1, dummy);

27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);
32: if (dummy > 0) then /* throw error message */
33: /*fnd_message.set_name('BIS', 'EDW_SOURCE_ALREADY_PRESENT');
34: fnd_message.set_token('NAME',
35: X_WAREHOUSE_TO_INSTANCE_LINK, FALSE);

Line 500: cid := DBMS_SQL.open_cursor;

496:
497: BEGIN
498: edw_misc_util.globalNamesOff;
499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then

Line 501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);

497: BEGIN
498: edw_misc_util.globalNamesOff;
499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);

Line 502: dbms_sql.define_column(cid, 1, remote_date);

498: edw_misc_util.globalNamesOff;
499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);
506: end if;

Line 503: v_ret_code:=dbms_sql.execute(cid);

499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);
506: end if;
507: DBMS_SQL.close_cursor(cid);

Line 504: if dbms_sql.fetch_rows(cid)<>0 then

500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);
506: end if;
507: DBMS_SQL.close_cursor(cid);
508:

Line 505: dbms_sql.column_value(cid, 1, remote_date);

501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);
506: end if;
507: DBMS_SQL.close_cursor(cid);
508:
509: delete_row_remote(x_instance_code, X_WAREHOUSE_TO_INSTANCE_LINK);

Line 507: DBMS_SQL.close_cursor(cid);

503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);
506: end if;
507: DBMS_SQL.close_cursor(cid);
508:
509: delete_row_remote(x_instance_code, X_WAREHOUSE_TO_INSTANCE_LINK);
510:
511: v_sql_stmt := 'INSERT INTO edw_local_instance@' ||

Line 517: v_cursor_id := dbms_sql.open_cursor;

513: '(instance_code, enabled_flag, creation_date, created_by,
514: last_update_date, last_updated_by, last_update_login,
515: warehouse_to_instance_link)
516: values (:x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8)';
517: v_cursor_id := dbms_sql.open_cursor;
518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);

Line 518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

514: last_update_date, last_updated_by, last_update_login,
515: warehouse_to_instance_link)
516: values (:x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8)';
517: v_cursor_id := dbms_sql.open_cursor;
518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);

Line 519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);

515: warehouse_to_instance_link)
516: values (:x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8)';
517: v_cursor_id := dbms_sql.open_cursor;
518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);

Line 520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);

516: values (:x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8)';
517: v_cursor_id := dbms_sql.open_cursor;
518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);

Line 521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);

517: v_cursor_id := dbms_sql.open_cursor;
518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);

Line 522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);

518: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);

Line 523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);

519: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);

Line 524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);

520: dbms_sql.bind_variable(v_cursor_id, ':x2', x_enabled_flag);
521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);

Line 525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);

521: dbms_sql.bind_variable(v_cursor_id, ':x3', remote_date);
522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);
529:

Line 526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);

522: dbms_sql.bind_variable(v_cursor_id, ':x4', x_created_by);
523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);
529:
530: SELECT userenv('LANG') INTO v_source_lang

Line 527: v_ret_code := dbms_sql.execute(v_cursor_id);

523: dbms_sql.bind_variable(v_cursor_id, ':x5', remote_date);
524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);
529:
530: SELECT userenv('LANG') INTO v_source_lang
531: FROM dual;

Line 528: dbms_sql.close_cursor(v_cursor_id);

524: dbms_sql.bind_variable(v_cursor_id, ':x6', x_last_updated_by);
525: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_update_login);
526: dbms_sql.bind_variable(v_cursor_id, ':x8', x_warehouse_to_instance_link);
527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);
529:
530: SELECT userenv('LANG') INTO v_source_lang
531: FROM dual;
532:

Line 545: v_cursor_id := dbms_sql.open_cursor;

541: and not exists (select NULL from EDW_LOCAL_INSTANCE_TL@' ||
542: x_warehouse_to_instance_link ||
543: ' T where T.INSTANCE_CODE = :x1 and T.LANGUAGE = L.LANGUAGE_CODE)';
544:
545: v_cursor_id := dbms_sql.open_cursor;
546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);

Line 546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

542: x_warehouse_to_instance_link ||
543: ' T where T.INSTANCE_CODE = :x1 and T.LANGUAGE = L.LANGUAGE_CODE)';
544:
545: v_cursor_id := dbms_sql.open_cursor;
546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);

Line 547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);

543: ' T where T.INSTANCE_CODE = :x1 and T.LANGUAGE = L.LANGUAGE_CODE)';
544:
545: v_cursor_id := dbms_sql.open_cursor;
546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);

Line 548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);

544:
545: v_cursor_id := dbms_sql.open_cursor;
546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);

Line 549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);

545: v_cursor_id := dbms_sql.open_cursor;
546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);

Line 550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);

546: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);

Line 551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);

547: dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);

Line 552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);

548: dbms_sql.bind_variable(v_cursor_id, ':x2', x_name);
549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);

Line 553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);

549: dbms_sql.bind_variable(v_cursor_id, ':x3', x_description);
550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);
557: dbms_sql.close_cursor(v_cursor_id);

Line 554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);

550: dbms_sql.bind_variable(v_cursor_id, ':x4', remote_date);
551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);
557: dbms_sql.close_cursor(v_cursor_id);
558:

Line 555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);

551: dbms_sql.bind_variable(v_cursor_id, ':x5', x_created_by);
552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);
557: dbms_sql.close_cursor(v_cursor_id);
558:
559: EXCEPTION

Line 556: v_ret_code := dbms_sql.execute(v_cursor_id);

552: dbms_sql.bind_variable(v_cursor_id, ':x6', remote_date);
553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);
557: dbms_sql.close_cursor(v_cursor_id);
558:
559: EXCEPTION
560: WHEN e_too_many_local_instances THEN

Line 557: dbms_sql.close_cursor(v_cursor_id);

553: dbms_sql.bind_variable(v_cursor_id, ':x7', x_last_updated_by);
554: dbms_sql.bind_variable(v_cursor_id, ':x8', x_last_update_login);
555: dbms_sql.bind_variable(v_cursor_id, ':x9', v_source_lang);
556: v_ret_code := dbms_sql.execute(v_cursor_id);
557: dbms_sql.close_cursor(v_cursor_id);
558:
559: EXCEPTION
560: WHEN e_too_many_local_instances THEN
561: fnd_message.set_name('BIS', 'EDW_TOO_MANY_LOCAL_INSTANCES');

Line 584: v_cursor_id := dbms_sql.open_cursor;

580:
581: edw_misc_util.globalNamesOff;
582: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE@' ||
583: x_warehouse_to_instance_link;
584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);

Line 585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

581: edw_misc_util.globalNamesOff;
582: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE@' ||
583: x_warehouse_to_instance_link;
584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);
589:

Line 586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);

582: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE@' ||
583: x_warehouse_to_instance_link;
584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);
589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||

Line 587: v_ret_code := dbms_sql.execute(v_cursor_id);

583: x_warehouse_to_instance_link;
584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);
589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;

Line 588: dbms_sql.close_cursor(v_cursor_id);

584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);
589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;

Line 592: v_cursor_id := dbms_sql.open_cursor;

588: dbms_sql.close_cursor(v_cursor_id);
589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
595: v_ret_code := dbms_sql.execute(v_cursor_id);
596: dbms_sql.close_cursor(v_cursor_id);

Line 593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
595: v_ret_code := dbms_sql.execute(v_cursor_id);
596: dbms_sql.close_cursor(v_cursor_id);
597: END DELETE_ROW_REMOTE;

Line 594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);

590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
595: v_ret_code := dbms_sql.execute(v_cursor_id);
596: dbms_sql.close_cursor(v_cursor_id);
597: END DELETE_ROW_REMOTE;
598:

Line 595: v_ret_code := dbms_sql.execute(v_cursor_id);

591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
595: v_ret_code := dbms_sql.execute(v_cursor_id);
596: dbms_sql.close_cursor(v_cursor_id);
597: END DELETE_ROW_REMOTE;
598:
599: END EDW_SOURCE_INSTANCES_PKG;

Line 596: dbms_sql.close_cursor(v_cursor_id);

592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
595: v_ret_code := dbms_sql.execute(v_cursor_id);
596: dbms_sql.close_cursor(v_cursor_id);
597: END DELETE_ROW_REMOTE;
598:
599: END EDW_SOURCE_INSTANCES_PKG;