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

Line 267: c_Insert_cur := dbms_sql.open_cursor;

263: EC_DEBUG.PL(3, 'cInsert_stmt: ',cInsert_stmt);
264: end if;
265:
266: xProgress := 'EXTUB-20-1080';
267: c_Insert_cur := dbms_sql.open_cursor;
268: if EC_DEBUG.G_debug_level = 3 then
269: EC_DEBUG.PL(3, 'c_Insert_cur: ',c_Insert_cur);
270: end if;
271:

Line 273: dbms_sql.parse(c_Insert_cur, cInsert_stmt, dbms_sql.native);

269: EC_DEBUG.PL(3, 'c_Insert_cur: ',c_Insert_cur);
270: end if;
271:
272: xProgress := 'EXTUB-20-1090';
273: dbms_sql.parse(c_Insert_cur, cInsert_stmt, dbms_sql.native);
274:
275: xProgress := 'EXTUB-20-1100';
276: For i in 1..l_Row_count loop
277:

Line 294: dbms_sql.bind_variable(c_Insert_cur,'b'||i,iRun_id);

290:
291: if p_source_tbl(i).Interface_Column_Name = 'RUN_ID' then
292:
293: xProgress := 'EXTUB-20-1120';
294: dbms_sql.bind_variable(c_Insert_cur,'b'||i,iRun_id);
295: elsif p_source_tbl(i).Interface_Column_Name
296: = 'TRANSACTION_RECORD_ID' then
297:
298: xProgress := 'EXTUB-20-1130';

Line 299: dbms_sql.bind_variable(c_Insert_cur,'b'||i,p_foreign_key);

295: elsif p_source_tbl(i).Interface_Column_Name
296: = 'TRANSACTION_RECORD_ID' then
297:
298: xProgress := 'EXTUB-20-1130';
299: dbms_sql.bind_variable(c_Insert_cur,'b'||i,p_foreign_key);
300: elsif p_source_tbl(i).Interface_Column_Name is not null
301: then
302:
303: -- **************************************

Line 336: dbms_sql.bind_variable(c_Insert_cur,'b'||i,d_date);

332: else
333: xProgress := 'EXTUB-20-1170';
334: d_date := NULL;
335: end if;
336: dbms_sql.bind_variable(c_Insert_cur,'b'||i,d_date);
337: elsif 'NUMBER' = p_source_tbl(i).data_type
338: Then
339: xProgress := 'EXTUB-20-1180';
340: if p_source_tbl(i).value is not NULL

Line 348: dbms_sql.bind_variable(c_Insert_cur,'b'||i,n_number);

344: else
345: xProgress := 'EXTUB-20-1200';
346: n_number:= NULL;
347: end if;
348: dbms_sql.bind_variable(c_Insert_cur,'b'||i,n_number);
349: else
350: xProgress := 'EXTUB-20-1210';
351:
352: dbms_sql.bind_variable(c_Insert_cur,'b'||i,cValue);

Line 352: dbms_sql.bind_variable(c_Insert_cur,'b'||i,cValue);

348: dbms_sql.bind_variable(c_Insert_cur,'b'||i,n_number);
349: else
350: xProgress := 'EXTUB-20-1210';
351:
352: dbms_sql.bind_variable(c_Insert_cur,'b'||i,cValue);
353: END if; -- if DATE
354:
355: end if;
356: End Loop;

Line 467: c_Insert_cur := dbms_sql.open_cursor;

463: if EC_DEBUG.G_debug_level >= 2 then
464: EC_DEBUG.PL(3, 'cInsert_stmt: ',cInsert_stmt);
465: end if;
466: xProgress := 'EXTUB-20-1240';
467: c_Insert_cur := dbms_sql.open_cursor;
468: if EC_DEBUG.G_debug_level >= 2 then
469: EC_DEBUG.PL(3, 'c_Insert_cur: ',c_Insert_cur);
470: end if;
471: xProgress := 'EXTUB-20-1250';

Line 472: dbms_sql.parse(c_Insert_cur, cInsert_stmt, dbms_sql.native);

468: if EC_DEBUG.G_debug_level >= 2 then
469: EC_DEBUG.PL(3, 'c_Insert_cur: ',c_Insert_cur);
470: end if;
471: xProgress := 'EXTUB-20-1250';
472: dbms_sql.parse(c_Insert_cur, cInsert_stmt, dbms_sql.native);
473: */
474:
475: xProgress := 'EXTUB-20-1220';
476: dummy := dbms_sql.execute(c_Insert_cur);

Line 476: dummy := dbms_sql.execute(c_Insert_cur);

472: dbms_sql.parse(c_Insert_cur, cInsert_stmt, dbms_sql.native);
473: */
474:
475: xProgress := 'EXTUB-20-1220';
476: dummy := dbms_sql.execute(c_Insert_cur);
477: if EC_DEBUG.G_debug_level >= 2 then
478: EC_DEBUG.PL(3, 'dummy: ',dummy);
479: end if;
480: if (debug_mode_on_insert)

Line 506: dbms_sql.close_cursor(c_Insert_cur);

502: --commit;
503: end if;
504:
505: xProgress := 'EXTUB-20-1230';
506: dbms_sql.close_cursor(c_Insert_cur);
507:
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_interface_tbl');
510: end if;

Line 605: p_Insert_cur := dbms_sql.open_cursor;

601: xProgress := 'EXTUB-30-1110';
602: cInsert_stmt := cInsert_stmt || cValue_stmt;
603:
604: xProgress := 'EXTUB-30-1110';
605: p_Insert_cur := dbms_sql.open_cursor;
606:
607: xProgress := 'EXTUB-30-1120';
608: if (debug_mode_on_prod)
609: then

Line 628: dbms_sql.parse(p_Insert_cur, cInsert_stmt, dbms_sql.native);

624: end if;
625:
626:
627: xProgress := 'EXTUB-30-1130';
628: dbms_sql.parse(p_Insert_cur, cInsert_stmt, dbms_sql.native);
629: end if;
630:
631: --if 1 =0
632: xProgress := 'EXTUB-30-1140';

Line 661: dbms_sql.bind_variable(p_Insert_cur,

657: xProgress := 'EXTUB-30-1210';
658: d_date := NULL;
659: end if;
660: xProgress := 'EXTUB-30-1220';
661: dbms_sql.bind_variable(p_Insert_cur,
662: 'b'||k,
663: d_date);
664:
665: if (debug_mode_on_prod)

Line 682: dbms_sql.bind_variable(p_Insert_cur,

678: xProgress := 'EXTUB-30-1250';
679: n_number := NULL;
680: end if;
681: xProgress := 'EXTUB-30-1260';
682: dbms_sql.bind_variable(p_Insert_cur,
683: 'b'||k,
684: n_number);
685: if (debug_mode_on_prod)
686: then

Line 692: dbms_sql.bind_variable(p_Insert_cur,

688: ( 88, ece_error_s.nextval, 'b'||k|| ' ='||n_number);
689: end if;
690: else
691: xProgress := 'EXTUB-30-1270';
692: dbms_sql.bind_variable(p_Insert_cur,
693: 'b'||k,
694: substrb(p_apps_tbl(k).value,
695: 1,
696: p_apps_tbl(k).data_length));

Line 709: dummy := dbms_sql.execute(p_Insert_cur);

705:
706: end loop;
707:
708: xProgress := 'EXTUB-30-1280';
709: dummy := dbms_sql.execute(p_Insert_cur);
710: exception
711: when others then
712: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface');
713: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

Line 872: p_Insert_cur := dbms_sql.open_cursor;

868: if EC_DEBUG.G_debug_level >= 2 then
869: EC_DEBUG.PL(3, 'cInsert_stmt: ',cInsert_stmt);
870: end if;
871: xProgress := 'EXTUB-30-1110';
872: p_Insert_cur := dbms_sql.open_cursor;
873: if EC_DEBUG.G_debug_level >= 2 then
874: EC_DEBUG.PL(3, 'p_Insert_cur: ',p_Insert_cur);
875: end if;
876: xProgress := 'EXTUB-30-1120';

Line 905: dbms_sql.parse(p_Insert_cur,cInsert_stmt,dbms_sql.native);

901:
902: xProgress := 'EXTUB-30-1130';
903: BEGIN
904: xProgress := 'EXTUB-30-1131';
905: dbms_sql.parse(p_Insert_cur,cInsert_stmt,dbms_sql.native);
906:
907: EXCEPTION
908: WHEN OTHERS THEN
909: ROLLBACK TO insert_into_prod_interface_pvt;

Line 911: dbms_sql.last_error_position,

907: EXCEPTION
908: WHEN OTHERS THEN
909: ROLLBACK TO insert_into_prod_interface_pvt;
910: ece_error_handling_pvt.print_parse_error(
911: dbms_sql.last_error_position,
912: cInsert_stmt);
913: fnd_msg_pub.count_and_get(
914: p_count => x_msg_count,
915: p_data => x_msg_data);

Line 947: dbms_sql.bind_variable(p_Insert_cur,'b'|| k,d_date);

943: d_date := NULL;
944: END IF;
945:
946: xProgress := 'EXTUB-30-1220';
947: dbms_sql.bind_variable(p_Insert_cur,'b'|| k,d_date);
948:
949: IF debug_mode_on_prod THEN
950: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' = ' || d_date);
951: END IF;

Line 966: dbms_sql.bind_variable(p_Insert_cur,'b' || k,n_number);

962: n_number := NULL;
963: END IF;
964:
965: xProgress := 'EXTUB-30-1260';
966: dbms_sql.bind_variable(p_Insert_cur,'b' || k,n_number);
967:
968: IF debug_mode_on_prod THEN
969: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || n_number);
970: END IF;

Line 973: dbms_sql.bind_variable(p_Insert_cur,'b' || k,SUBSTR(p_apps_tbl(k).value,1,p_apps_tbl(k).data_length));

969: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || n_number);
970: END IF;
971: ELSE
972: xProgress := 'EXTUB-30-1270';
973: dbms_sql.bind_variable(p_Insert_cur,'b' || k,SUBSTR(p_apps_tbl(k).value,1,p_apps_tbl(k).data_length));
974:
975: IF debug_mode_on_prod THEN
976: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || p_apps_tbl(k).value);
977: END IF;

Line 985: dummy := dbms_sql.execute(p_Insert_cur);

981: END IF;
982: END LOOP;
983:
984: xProgress := 'EXTUB-30-1280';
985: dummy := dbms_sql.execute(p_Insert_cur);
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface_pvt');

Line 1050: dbms_sql.last_error_position,

1046: p_count => x_msg_count,
1047: p_data => x_msg_data);
1048: WHEN OTHERS THEN
1049: ece_error_handling_pvt.print_parse_error(
1050: dbms_sql.last_error_position,
1051: '');
1052: ROLLBACK TO insert_into_prod_interface_pvt;
1053: x_return_status := fnd_api.g_ret_sts_error;
1054: