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

Line 1011: cur_dist := dbms_sql.open_cursor;

1007: END IF;
1008:
1009: d_progress := 70;
1010:
1011: cur_dist := dbms_sql.open_cursor;
1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);

Line 1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);

1008:
1009: d_progress := 70;
1010:
1011: cur_dist := dbms_sql.open_cursor;
1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);

Line 1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);

1009: d_progress := 70;
1010:
1011: cur_dist := dbms_sql.open_cursor;
1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);

Line 1015: dbms_sql.define_column(cur_dist, 1, l_distid);

1011: cur_dist := dbms_sql.open_cursor;
1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1019:

Line 1016: dbms_sql.define_column(cur_dist, 2, l_qty);

1012: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1019:
1020: num_dist := dbms_sql.execute(cur_dist);

Line 1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);

1013: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1019:
1020: num_dist := dbms_sql.execute(cur_dist);
1021:

Line 1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);

1014:
1015: dbms_sql.define_column(cur_dist, 1, l_distid);
1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1019:
1020: num_dist := dbms_sql.execute(cur_dist);
1021:
1022: LOOP

Line 1020: num_dist := dbms_sql.execute(cur_dist);

1016: dbms_sql.define_column(cur_dist, 2, l_qty);
1017: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1018: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1019:
1020: num_dist := dbms_sql.execute(cur_dist);
1021:
1022: LOOP
1023:
1024: d_progress := 80;

Line 1026: IF (dbms_sql.fetch_rows(cur_dist) > 0) THEN

1022: LOOP
1023:
1024: d_progress := 80;
1025:
1026: IF (dbms_sql.fetch_rows(cur_dist) > 0) THEN
1027:
1028: d_progress := 90;
1029:
1030: dbms_sql.column_value(cur_dist, 1, l_distid);

Line 1030: dbms_sql.column_value(cur_dist, 1, l_distid);

1026: IF (dbms_sql.fetch_rows(cur_dist) > 0) THEN
1027:
1028: d_progress := 90;
1029:
1030: dbms_sql.column_value(cur_dist, 1, l_distid);
1031: dbms_sql.column_value(cur_dist, 2, l_qty);
1032: dbms_sql.column_value(cur_dist, 3, l_uom);
1033: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1034:

Line 1031: dbms_sql.column_value(cur_dist, 2, l_qty);

1027:
1028: d_progress := 90;
1029:
1030: dbms_sql.column_value(cur_dist, 1, l_distid);
1031: dbms_sql.column_value(cur_dist, 2, l_qty);
1032: dbms_sql.column_value(cur_dist, 3, l_uom);
1033: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1034:
1035:

Line 1032: dbms_sql.column_value(cur_dist, 3, l_uom);

1028: d_progress := 90;
1029:
1030: dbms_sql.column_value(cur_dist, 1, l_distid);
1031: dbms_sql.column_value(cur_dist, 2, l_qty);
1032: dbms_sql.column_value(cur_dist, 3, l_uom);
1033: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1034:
1035:
1036: IF (PO_LOG.d_stmt) THEN

Line 1033: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);

1029:
1030: dbms_sql.column_value(cur_dist, 1, l_distid);
1031: dbms_sql.column_value(cur_dist, 2, l_qty);
1032: dbms_sql.column_value(cur_dist, 3, l_uom);
1033: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1034:
1035:
1036: IF (PO_LOG.d_stmt) THEN
1037: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);

Line 1232: END IF; -- IF (dbms_sql.fetch_rows(cur_dist) > 0)

1228:
1229: -- no rows in distributions cursor
1230: EXIT;
1231:
1232: END IF; -- IF (dbms_sql.fetch_rows(cur_dist) > 0)
1233:
1234: END LOOP; -- dynamic dists cursor
1235:
1236: l_return_value := TRUE;

Line 1247: IF (dbms_sql.is_open(cur_dist)) THEN

1243: IF supply_lloc%ISOPEN THEN
1244: close supply_lloc;
1245: END IF;
1246:
1247: IF (dbms_sql.is_open(cur_dist)) THEN
1248: dbms_sql.close_cursor(cur_dist);
1249: END IF;
1250:
1251: IF (PO_LOG.d_proc) THEN

Line 1248: dbms_sql.close_cursor(cur_dist);

1244: close supply_lloc;
1245: END IF;
1246:
1247: IF (dbms_sql.is_open(cur_dist)) THEN
1248: dbms_sql.close_cursor(cur_dist);
1249: END IF;
1250:
1251: IF (PO_LOG.d_proc) THEN
1252: PO_LOG.proc_return(d_module, l_return_value);

Line 1266: IF (dbms_sql.is_open(cur_dist)) THEN

1262: IF supply_lloc%ISOPEN THEN
1263: close supply_lloc;
1264: END IF;
1265:
1266: IF (dbms_sql.is_open(cur_dist)) THEN
1267: dbms_sql.close_cursor(cur_dist);
1268: END IF;
1269:
1270: IF (PO_LOG.d_exc) THEN

Line 1267: dbms_sql.close_cursor(cur_dist);

1263: close supply_lloc;
1264: END IF;
1265:
1266: IF (dbms_sql.is_open(cur_dist)) THEN
1267: dbms_sql.close_cursor(cur_dist);
1268: END IF;
1269:
1270: IF (PO_LOG.d_exc) THEN
1271: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);