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 1042: cur_dist := dbms_sql.open_cursor;

1038: END IF;
1039:
1040: d_progress := 70;
1041:
1042: cur_dist := dbms_sql.open_cursor;
1043: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);

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

1039:
1040: d_progress := 70;
1041:
1042: cur_dist := dbms_sql.open_cursor;
1043: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);

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

1040: d_progress := 70;
1041:
1042: cur_dist := dbms_sql.open_cursor;
1043: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);

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

1042: cur_dist := dbms_sql.open_cursor;
1043: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1049: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1050:

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

1043: dbms_sql.parse(cur_dist, sql_dist, dbms_sql.v7);
1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1049: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1050:
1051: num_dist := dbms_sql.execute(cur_dist);

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

1044: dbms_sql.bind_variable(cur_dist, ':b_entity_id', b_entity_id);
1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1049: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1050:
1051: num_dist := dbms_sql.execute(cur_dist);
1052:

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

1045:
1046: dbms_sql.define_column(cur_dist, 1, l_distid);
1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1049: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1050:
1051: num_dist := dbms_sql.execute(cur_dist);
1052:
1053: LOOP

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

1047: dbms_sql.define_column(cur_dist, 2, l_qty);
1048: dbms_sql.define_column(cur_dist, 3, l_uom, 25);
1049: dbms_sql.define_column(cur_dist, 4, l_line_loc_id);
1050:
1051: num_dist := dbms_sql.execute(cur_dist);
1052:
1053: LOOP
1054:
1055: d_progress := 80;

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

1053: LOOP
1054:
1055: d_progress := 80;
1056:
1057: IF (dbms_sql.fetch_rows(cur_dist) > 0) THEN
1058:
1059: d_progress := 90;
1060:
1061: dbms_sql.column_value(cur_dist, 1, l_distid);

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

1057: IF (dbms_sql.fetch_rows(cur_dist) > 0) THEN
1058:
1059: d_progress := 90;
1060:
1061: dbms_sql.column_value(cur_dist, 1, l_distid);
1062: dbms_sql.column_value(cur_dist, 2, l_qty);
1063: dbms_sql.column_value(cur_dist, 3, l_uom);
1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:

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

1058:
1059: d_progress := 90;
1060:
1061: dbms_sql.column_value(cur_dist, 1, l_distid);
1062: dbms_sql.column_value(cur_dist, 2, l_qty);
1063: dbms_sql.column_value(cur_dist, 3, l_uom);
1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:
1066:

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

1059: d_progress := 90;
1060:
1061: dbms_sql.column_value(cur_dist, 1, l_distid);
1062: dbms_sql.column_value(cur_dist, 2, l_qty);
1063: dbms_sql.column_value(cur_dist, 3, l_uom);
1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:
1066:
1067: IF (PO_LOG.d_stmt) THEN

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

1060:
1061: dbms_sql.column_value(cur_dist, 1, l_distid);
1062: dbms_sql.column_value(cur_dist, 2, l_qty);
1063: dbms_sql.column_value(cur_dist, 3, l_uom);
1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:
1066:
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);

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

1342:
1343: -- no rows in distributions cursor
1344: EXIT;
1345:
1346: END IF; -- IF (dbms_sql.fetch_rows(cur_dist) > 0)
1347:
1348: END LOOP; -- dynamic dists cursor
1349:
1350: l_return_value := TRUE;

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

1357: IF supply_lloc%ISOPEN THEN
1358: close supply_lloc;
1359: END IF;
1360:
1361: IF (dbms_sql.is_open(cur_dist)) THEN
1362: dbms_sql.close_cursor(cur_dist);
1363: END IF;
1364:
1365: IF (PO_LOG.d_proc) THEN

Line 1362: dbms_sql.close_cursor(cur_dist);

1358: close supply_lloc;
1359: END IF;
1360:
1361: IF (dbms_sql.is_open(cur_dist)) THEN
1362: dbms_sql.close_cursor(cur_dist);
1363: END IF;
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_return(d_module, l_return_value);

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

1376: IF supply_lloc%ISOPEN THEN
1377: close supply_lloc;
1378: END IF;
1379:
1380: IF (dbms_sql.is_open(cur_dist)) THEN
1381: dbms_sql.close_cursor(cur_dist);
1382: END IF;
1383:
1384: IF (PO_LOG.d_exc) THEN

Line 1381: dbms_sql.close_cursor(cur_dist);

1377: close supply_lloc;
1378: END IF;
1379:
1380: IF (dbms_sql.is_open(cur_dist)) THEN
1381: dbms_sql.close_cursor(cur_dist);
1382: END IF;
1383:
1384: IF (PO_LOG.d_exc) THEN
1385: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);