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

Line 1032: l_query_handle := DBMS_SQL.open_cursor;

1028: DEBUG ('select string ' || l_select_str, l_module_name, 9);
1029: l_query_str := l_insert_str || l_select_str;
1030: DEBUG ('final query string ' || l_query_str, l_module_name, 9);
1031: DEBUG ('handling and parsing the query', l_module_name, 9);
1032: l_query_handle := DBMS_SQL.open_cursor;
1033: DBMS_SQL.parse (l_query_handle, l_query_str, DBMS_SQL.native);
1034: DEBUG ('after parsing -- enw ', l_module_name, 9);
1035: DEBUG ('parsing ', l_module_name, 9);
1036:

Line 1033: DBMS_SQL.parse (l_query_handle, l_query_str, DBMS_SQL.native);

1029: l_query_str := l_insert_str || l_select_str;
1030: DEBUG ('final query string ' || l_query_str, l_module_name, 9);
1031: DEBUG ('handling and parsing the query', l_module_name, 9);
1032: l_query_handle := DBMS_SQL.open_cursor;
1033: DBMS_SQL.parse (l_query_handle, l_query_str, DBMS_SQL.native);
1034: DEBUG ('after parsing -- enw ', l_module_name, 9);
1035: DEBUG ('parsing ', l_module_name, 9);
1036:
1037: IF p_organization_id IS NOT NULL

Line 1043: DBMS_SQL.bind_variable (l_query_handle,

1039: DEBUG ('Assigning Organization' || p_organization_id,
1040: l_module_name,
1041: 9
1042: );
1043: DBMS_SQL.bind_variable (l_query_handle,
1044: ':organization_id',
1045: p_organization_id
1046: );
1047: END IF;

Line 1053: DBMS_SQL.bind_variable (l_query_handle,

1049: -- Zone enhancement
1050: -- It's a bug fix: no matter what, we need to restrict locators returned
1051: -- based on locators belonging to the current zone.
1052: DEBUG ('80-3', 'add_locators_grid', 9);
1053: DBMS_SQL.bind_variable (l_query_handle,
1054: 'cur_zone_id',
1055: p_current_zone_id
1056: );
1057: DEBUG ('60', 'add_locators_grid', 9);

Line 1062: DBMS_SQL.bind_variable (l_query_handle,

1058:
1059: IF l_is_all_locators
1060: THEN
1061: DEBUG ('assigning locators: ' || g_all_locators_message, l_module_name, 9);
1062: DBMS_SQL.bind_variable (l_query_handle,
1063: 'all_locators',
1064: g_all_locators_message
1065: );
1066: DEBUG ('150', 'add_locators_grid', 9);

Line 1072: DBMS_SQL.bind_variable (l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062

1068:
1069: IF p_fm_loc_id IS NOT NULL AND p_fm_loc_id <> -999
1070: THEN
1071: DEBUG ('fm locid is not null', 'add_locators_grid', 9);
1072: DBMS_SQL.bind_variable (l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062
1073:
1074: DEBUG ('90-1', 'add_locators_grid', 9);
1075: END IF;
1076:

Line 1080: DBMS_SQL.bind_variable (l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062

1076:
1077: IF p_to_loc_id IS NOT NULL AND p_to_loc_id <> -999
1078: THEN
1079: DEBUG ('to locid is not null', 'add_locators_grid', 9);
1080: DBMS_SQL.bind_variable (l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062
1081:
1082: DEBUG ('90-2', 'add_locators_grid', 9);
1083: END IF;
1084:

Line 1091: DBMS_SQL.bind_variable (l_query_handle,

1087: DEBUG ('assigning substatus ' || p_subinventory_status,
1088: l_module_name,
1089: 9
1090: );
1091: DBMS_SQL.bind_variable (l_query_handle,
1092: 'sub_status',
1093: p_subinventory_status
1094: );
1095: DEBUG ('70', 'add_locators_grid', 9);

Line 1104: DBMS_SQL.bind_variable (l_query_handle,

1100: DEBUG ('assigning locator status ' || p_locator_status,
1101: 'add_locators_grid',
1102: 9
1103: );
1104: DBMS_SQL.bind_variable (l_query_handle,
1105: 'locator_status',
1106: p_locator_status
1107: );
1108: DEBUG ('80', 'add_locators_grid', 9);

Line 1114: DBMS_SQL.bind_variable (l_query_handle, 'fm_sub_code',

1110:
1111: IF p_fm_sub_code IS NOT NULL
1112: THEN
1113: DEBUG ('Assigning fm_sub_code' || p_fm_sub_code, l_module_name, 9);
1114: DBMS_SQL.bind_variable (l_query_handle, 'fm_sub_code',
1115: p_fm_sub_code);
1116: DEBUG ('40', 'add_locators_grid', 9);
1117: END IF;
1118:

Line 1122: DBMS_SQL.bind_variable (l_query_handle, 'to_sub_code',

1118:
1119: IF p_to_sub_code IS NOT NULL
1120: THEN
1121: DEBUG ('Assigning to_sub_code' || p_to_sub_code, l_module_name, 9);
1122: DBMS_SQL.bind_variable (l_query_handle, 'to_sub_code',
1123: p_to_sub_code);
1124: DEBUG ('50', 'add_locators_grid', 9);
1125: END IF;
1126:

Line 1132: DBMS_SQL.bind_variable (l_query_handle, 'fm_zone_id', p_fm_zone_id);

1128:
1129: IF p_fm_zone_id IS NOT NULL
1130: THEN
1131: DEBUG ('assigning fmzone ' || p_fm_zone_id, l_module_name, 9);
1132: DBMS_SQL.bind_variable (l_query_handle, 'fm_zone_id', p_fm_zone_id);
1133: DEBUG ('10', 'add_locators_grid', 9);
1134: --END IF;
1135:
1136: -- IF p_to_zone_id IS NOT NULL THEN

Line 1138: DBMS_SQL.bind_variable (l_query_handle, 'to_zone_id', p_to_zone_id);

1134: --END IF;
1135:
1136: -- IF p_to_zone_id IS NOT NULL THEN
1137: DEBUG ('assigning to zone ' || p_to_zone_id, l_module_name, 9);
1138: DBMS_SQL.bind_variable (l_query_handle, 'to_zone_id', p_to_zone_id);
1139: DEBUG ('20', 'add_locators_grid', 9);
1140: END IF;
1141:
1142: IF p_subinventory_type IS NOT NULL

Line 1148: DBMS_SQL.bind_variable (l_query_handle,

1144: DEBUG ('assigning sub type ' || p_subinventory_type,
1145: l_module_name,
1146: 9
1147: );
1148: DBMS_SQL.bind_variable (l_query_handle,
1149: 'subinventory_type',
1150: p_subinventory_type
1151: );
1152: DEBUG ('400', 'add_locators_grid', 9);

Line 1158: DBMS_SQL.bind_variable (l_query_handle,

1154:
1155: IF p_locator_type IS NOT NULL
1156: THEN
1157: DEBUG ('assigning loc type ' || p_locator_type, l_module_name, 9);
1158: DBMS_SQL.bind_variable (l_query_handle,
1159: 'locator_type',
1160: p_locator_type
1161: );
1162: DEBUG ('410', 'add_locators_grid', 9);

Line 1171: DBMS_SQL.bind_variable (l_query_handle,

1167: DEBUG (' assigning fm picking order ' || p_fm_picking_order,
1168: l_module_name,
1169: 9
1170: );
1171: DBMS_SQL.bind_variable (l_query_handle,
1172: 'fm_picking_order',
1173: p_fm_picking_order
1174: );
1175: DEBUG ('110', 'add_locators_grid', 9);

Line 1184: DBMS_SQL.bind_variable (l_query_handle,

1180: DEBUG (' assigning to picking order ' || p_to_picking_order,
1181: l_module_name,
1182: 9
1183: );
1184: DBMS_SQL.bind_variable (l_query_handle,
1185: 'to_picking_order',
1186: p_to_picking_order
1187: );
1188: DEBUG ('120', 'add_locators_grid', 9);

Line 1197: DBMS_SQL.bind_variable (l_query_handle,

1193: DEBUG (' assigning fm dropping order ' || p_fm_dropping_order,
1194: l_module_name,
1195: 9
1196: );
1197: DBMS_SQL.bind_variable (l_query_handle,
1198: 'fm_dropping_order',
1199: p_fm_dropping_order
1200: );
1201: DEBUG ('130', 'add_locators_grid', 9);

Line 1210: DBMS_SQL.bind_variable (l_query_handle,

1206: DEBUG (' assigning to dropping order ' || p_to_dropping_order,
1207: l_module_name,
1208: 9
1209: );
1210: DBMS_SQL.bind_variable (l_query_handle,
1211: 'to_dropping_order',
1212: p_to_dropping_order
1213: );
1214: DEBUG ('140', 'add_locators_grid', 9);

Line 1220: DBMS_SQL.bind_variable(l_query_handle, 'fm_zone_id', p_fm_zone_id);

1216:
1217: /* Parse, bind and execute the dynamic query */
1218: /*
1219: IF p_fm_zone_id IS NOT NULL THEN
1220: DBMS_SQL.bind_variable(l_query_handle, 'fm_zone_id', p_fm_zone_id);
1221: DEBUG('10', 'add_locators_grid', 9);
1222: END IF;
1223:
1224: IF p_to_zone_id IS NOT NULL THEN

Line 1225: DBMS_SQL.bind_variable(l_query_handle, 'to_zone_id', p_to_zone_id);

1221: DEBUG('10', 'add_locators_grid', 9);
1222: END IF;
1223:
1224: IF p_to_zone_id IS NOT NULL THEN
1225: DBMS_SQL.bind_variable(l_query_handle, 'to_zone_id', p_to_zone_id);
1226: DEBUG('20', 'add_locators_grid', 9);
1227: END IF;
1228:
1229: IF p_current_zone_id IS NOT NULL THEN

Line 1230: DBMS_SQL.bind_variable(

1226: DEBUG('20', 'add_locators_grid', 9);
1227: END IF;
1228:
1229: IF p_current_zone_id IS NOT NULL THEN
1230: DBMS_SQL.bind_variable(
1231: l_query_handle
1232: , 'current_zone_id'
1233: , p_current_zone_id
1234: );

Line 1239: DBMS_SQL.bind_variable(l_query_handle, 'fm_sub_code', p_fm_sub_code);

1235: DEBUG('30', 'add_locators_grid', 9);
1236: END IF;
1237:
1238: IF p_fm_sub_code IS NOT NULL THEN
1239: DBMS_SQL.bind_variable(l_query_handle, 'fm_sub_code', p_fm_sub_code);
1240: DEBUG('40', 'add_locators_grid', 9);
1241: END IF;
1242:
1243: IF p_to_sub_code IS NOT NULL THEN

Line 1244: DBMS_SQL.bind_variable(l_query_handle, 'to_sub_code', p_to_sub_code);

1240: DEBUG('40', 'add_locators_grid', 9);
1241: END IF;
1242:
1243: IF p_to_sub_code IS NOT NULL THEN
1244: DBMS_SQL.bind_variable(l_query_handle, 'to_sub_code', p_to_sub_code);
1245: DEBUG('50', 'add_locators_grid', 9);
1246: END IF;
1247:
1248: IF p_fm_loc_id IS NOT NULL THEN

Line 1249: DBMS_SQL.bind_variable(l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062

1245: DEBUG('50', 'add_locators_grid', 9);
1246: END IF;
1247:
1248: IF p_fm_loc_id IS NOT NULL THEN
1249: DBMS_SQL.bind_variable(l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062
1250:
1251: DEBUG('60', 'add_locators_grid', 9);
1252: END IF;
1253:

Line 1255: DBMS_SQL.bind_variable(l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062

1251: DEBUG('60', 'add_locators_grid', 9);
1252: END IF;
1253:
1254: IF p_to_loc_id IS NOT NULL THEN
1255: DBMS_SQL.bind_variable(l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062
1256:
1257: DEBUG('70', 'add_locators_grid', 9);
1258: END IF;
1259:

Line 1261: DBMS_SQL.bind_variable(l_query_handle, 'locator_status', p_locator_status);

1257: DEBUG('70', 'add_locators_grid', 9);
1258: END IF;
1259:
1260: IF p_locator_status IS NOT NULL THEN
1261: DBMS_SQL.bind_variable(l_query_handle, 'locator_status', p_locator_status);
1262: DEBUG('90', 'add_locators_grid', 9);
1263: END IF;
1264:
1265: IF p_subinventory_type IS NOT NULL THEN

Line 1266: DBMS_SQL.bind_variable(

1262: DEBUG('90', 'add_locators_grid', 9);
1263: END IF;
1264:
1265: IF p_subinventory_type IS NOT NULL THEN
1266: DBMS_SQL.bind_variable(
1267: l_query_handle
1268: , 'subinventory_type'
1269: , p_subinventory_type
1270: );

Line 1275: DBMS_SQL.bind_variable(l_query_handle, ':sub_status', 1);

1271: DEBUG('100', 'add_locators_grid', 9);
1272: END IF;
1273:
1274: --IF p_subinventory_status IS NOT NULL THEN
1275: DBMS_SQL.bind_variable(l_query_handle, ':sub_status', 1);
1276: DEBUG('70', 'add_locators_grid', 9);
1277: -- END IF;
1278:
1279: IF p_fm_picking_order IS NOT NULL THEN

Line 1280: DBMS_SQL.bind_variable(

1276: DEBUG('70', 'add_locators_grid', 9);
1277: -- END IF;
1278:
1279: IF p_fm_picking_order IS NOT NULL THEN
1280: DBMS_SQL.bind_variable(
1281: l_query_handle
1282: , 'fm_picking_order'
1283: , p_fm_picking_order
1284: );

Line 1289: DBMS_SQL.bind_variable(

1285: DEBUG('110', 'add_locators_grid', 9);
1286: END IF;
1287:
1288: IF p_to_picking_order IS NOT NULL THEN
1289: DBMS_SQL.bind_variable(
1290: l_query_handle
1291: , 'to_picking_order'
1292: , p_to_picking_order
1293: );

Line 1298: DBMS_SQL.bind_variable(

1294: DEBUG('120', 'add_locators_grid', 9);
1295: END IF;
1296:
1297: IF p_fm_dropping_order IS NOT NULL THEN
1298: DBMS_SQL.bind_variable(
1299: l_query_handle
1300: , 'fm_dropping_order'
1301: , p_fm_dropping_order
1302: );

Line 1307: DBMS_SQL.bind_variable(

1303: DEBUG('130', 'add_locators_grid', 9);
1304: END IF;
1305:
1306: IF p_to_dropping_order IS NOT NULL THEN
1307: DBMS_SQL.bind_variable(
1308: l_query_handle
1309: , 'to_dropping_order'
1310: , p_to_dropping_order
1311: );

Line 1316: DBMS_SQL.bind_variable(l_query_handle, 'all_locators', p_all_locators);

1312: DEBUG('140', 'add_locators_grid', 9);
1313: END IF;
1314:
1315: IF p_all_locators IS NOT NULL THEN
1316: DBMS_SQL.bind_variable(l_query_handle, 'all_locators', p_all_locators);
1317: DEBUG('150', 'add_locators_grid', 9);
1318: END IF; */
1319: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
1320: COMMIT;

Line 1319: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

1315: IF p_all_locators IS NOT NULL THEN
1316: DBMS_SQL.bind_variable(l_query_handle, 'all_locators', p_all_locators);
1317: DEBUG('150', 'add_locators_grid', 9);
1318: END IF; */
1319: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
1320: COMMIT;
1321: DEBUG ('l_query_count ' || l_query_count, 'add_locators_grid', 9);
1322: END add_locators_to_grid;
1323: