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 1049: l_query_handle := DBMS_SQL.open_cursor;

1045: DEBUG ('select string ' || l_select_str, l_module_name, 9);
1046: l_query_str := l_insert_str || l_select_str;
1047: DEBUG ('final query string ' || l_query_str, l_module_name, 9);
1048: DEBUG ('handling and parsing the query', l_module_name, 9);
1049: l_query_handle := DBMS_SQL.open_cursor;
1050: DBMS_SQL.parse (l_query_handle, l_query_str, DBMS_SQL.native);
1051: DEBUG ('after parsing -- enw ', l_module_name, 9);
1052: DEBUG ('parsing ', l_module_name, 9);
1053:

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

1046: l_query_str := l_insert_str || l_select_str;
1047: DEBUG ('final query string ' || l_query_str, l_module_name, 9);
1048: DEBUG ('handling and parsing the query', l_module_name, 9);
1049: l_query_handle := DBMS_SQL.open_cursor;
1050: DBMS_SQL.parse (l_query_handle, l_query_str, DBMS_SQL.native);
1051: DEBUG ('after parsing -- enw ', l_module_name, 9);
1052: DEBUG ('parsing ', l_module_name, 9);
1053:
1054: IF p_organization_id IS NOT NULL

Line 1060: DBMS_SQL.bind_variable (l_query_handle,

1056: DEBUG ('Assigning Organization' || p_organization_id,
1057: l_module_name,
1058: 9
1059: );
1060: DBMS_SQL.bind_variable (l_query_handle,
1061: ':organization_id',
1062: p_organization_id
1063: );
1064: END IF;

Line 1070: DBMS_SQL.bind_variable (l_query_handle,

1066: -- Zone enhancement
1067: -- It's a bug fix: no matter what, we need to restrict locators returned
1068: -- based on locators belonging to the current zone.
1069: DEBUG ('80-3', 'add_locators_grid', 9);
1070: DBMS_SQL.bind_variable (l_query_handle,
1071: 'cur_zone_id',
1072: p_current_zone_id
1073: );
1074: DEBUG ('60', 'add_locators_grid', 9);

Line 1079: DBMS_SQL.bind_variable (l_query_handle,

1075:
1076: IF l_is_all_locators
1077: THEN
1078: DEBUG ('assigning locators: ' || g_all_locators_message, l_module_name, 9);
1079: DBMS_SQL.bind_variable (l_query_handle,
1080: 'all_locators',
1081: g_all_locators_message
1082: );
1083: DEBUG ('150', 'add_locators_grid', 9);

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

1085:
1086: IF p_fm_loc_id IS NOT NULL AND p_fm_loc_id <> -999
1087: THEN
1088: DEBUG ('fm locid is not null', 'add_locators_grid', 9);
1089: DBMS_SQL.bind_variable (l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062
1090:
1091: DEBUG ('90-1', 'add_locators_grid', 9);
1092: END IF;
1093:

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

1093:
1094: IF p_to_loc_id IS NOT NULL AND p_to_loc_id <> -999
1095: THEN
1096: DEBUG ('to locid is not null', 'add_locators_grid', 9);
1097: DBMS_SQL.bind_variable (l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062
1098:
1099: DEBUG ('90-2', 'add_locators_grid', 9);
1100: END IF;
1101:

Line 1108: DBMS_SQL.bind_variable (l_query_handle,

1104: DEBUG ('assigning substatus ' || p_subinventory_status,
1105: l_module_name,
1106: 9
1107: );
1108: DBMS_SQL.bind_variable (l_query_handle,
1109: 'sub_status',
1110: p_subinventory_status
1111: );
1112: DEBUG ('70', 'add_locators_grid', 9);

Line 1121: DBMS_SQL.bind_variable (l_query_handle,

1117: DEBUG ('assigning locator status ' || p_locator_status,
1118: 'add_locators_grid',
1119: 9
1120: );
1121: DBMS_SQL.bind_variable (l_query_handle,
1122: 'locator_status',
1123: p_locator_status
1124: );
1125: DEBUG ('80', 'add_locators_grid', 9);

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

1127:
1128: IF p_fm_sub_code IS NOT NULL
1129: THEN
1130: DEBUG ('Assigning fm_sub_code' || p_fm_sub_code, l_module_name, 9);
1131: DBMS_SQL.bind_variable (l_query_handle, 'fm_sub_code',
1132: p_fm_sub_code);
1133: DEBUG ('40', 'add_locators_grid', 9);
1134: END IF;
1135:

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

1135:
1136: IF p_to_sub_code IS NOT NULL
1137: THEN
1138: DEBUG ('Assigning to_sub_code' || p_to_sub_code, l_module_name, 9);
1139: DBMS_SQL.bind_variable (l_query_handle, 'to_sub_code',
1140: p_to_sub_code);
1141: DEBUG ('50', 'add_locators_grid', 9);
1142: END IF;
1143:

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

1145:
1146: IF p_fm_zone_id IS NOT NULL
1147: THEN
1148: DEBUG ('assigning fmzone ' || p_fm_zone_id, l_module_name, 9);
1149: DBMS_SQL.bind_variable (l_query_handle, 'fm_zone_id', p_fm_zone_id);
1150: DEBUG ('10', 'add_locators_grid', 9);
1151: --END IF;
1152:
1153: -- IF p_to_zone_id IS NOT NULL THEN

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

1151: --END IF;
1152:
1153: -- IF p_to_zone_id IS NOT NULL THEN
1154: DEBUG ('assigning to zone ' || p_to_zone_id, l_module_name, 9);
1155: DBMS_SQL.bind_variable (l_query_handle, 'to_zone_id', p_to_zone_id);
1156: DEBUG ('20', 'add_locators_grid', 9);
1157: END IF;
1158:
1159: IF p_subinventory_type IS NOT NULL

Line 1165: DBMS_SQL.bind_variable (l_query_handle,

1161: DEBUG ('assigning sub type ' || p_subinventory_type,
1162: l_module_name,
1163: 9
1164: );
1165: DBMS_SQL.bind_variable (l_query_handle,
1166: 'subinventory_type',
1167: p_subinventory_type
1168: );
1169: DEBUG ('400', 'add_locators_grid', 9);

Line 1175: DBMS_SQL.bind_variable (l_query_handle,

1171:
1172: IF p_locator_type IS NOT NULL
1173: THEN
1174: DEBUG ('assigning loc type ' || p_locator_type, l_module_name, 9);
1175: DBMS_SQL.bind_variable (l_query_handle,
1176: 'locator_type',
1177: p_locator_type
1178: );
1179: DEBUG ('410', 'add_locators_grid', 9);

Line 1188: DBMS_SQL.bind_variable (l_query_handle,

1184: DEBUG (' assigning fm picking order ' || p_fm_picking_order,
1185: l_module_name,
1186: 9
1187: );
1188: DBMS_SQL.bind_variable (l_query_handle,
1189: 'fm_picking_order',
1190: p_fm_picking_order
1191: );
1192: DEBUG ('110', 'add_locators_grid', 9);

Line 1201: DBMS_SQL.bind_variable (l_query_handle,

1197: DEBUG (' assigning to picking order ' || p_to_picking_order,
1198: l_module_name,
1199: 9
1200: );
1201: DBMS_SQL.bind_variable (l_query_handle,
1202: 'to_picking_order',
1203: p_to_picking_order
1204: );
1205: DEBUG ('120', 'add_locators_grid', 9);

Line 1214: DBMS_SQL.bind_variable (l_query_handle,

1210: DEBUG (' assigning fm dropping order ' || p_fm_dropping_order,
1211: l_module_name,
1212: 9
1213: );
1214: DBMS_SQL.bind_variable (l_query_handle,
1215: 'fm_dropping_order',
1216: p_fm_dropping_order
1217: );
1218: DEBUG ('130', 'add_locators_grid', 9);

Line 1227: DBMS_SQL.bind_variable (l_query_handle,

1223: DEBUG (' assigning to dropping order ' || p_to_dropping_order,
1224: l_module_name,
1225: 9
1226: );
1227: DBMS_SQL.bind_variable (l_query_handle,
1228: 'to_dropping_order',
1229: p_to_dropping_order
1230: );
1231: DEBUG ('140', 'add_locators_grid', 9);

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

1233:
1234: /* Parse, bind and execute the dynamic query */
1235: /*
1236: IF p_fm_zone_id IS NOT NULL THEN
1237: DBMS_SQL.bind_variable(l_query_handle, 'fm_zone_id', p_fm_zone_id);
1238: DEBUG('10', 'add_locators_grid', 9);
1239: END IF;
1240:
1241: IF p_to_zone_id IS NOT NULL THEN

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

1238: DEBUG('10', 'add_locators_grid', 9);
1239: END IF;
1240:
1241: IF p_to_zone_id IS NOT NULL THEN
1242: DBMS_SQL.bind_variable(l_query_handle, 'to_zone_id', p_to_zone_id);
1243: DEBUG('20', 'add_locators_grid', 9);
1244: END IF;
1245:
1246: IF p_current_zone_id IS NOT NULL THEN

Line 1247: DBMS_SQL.bind_variable(

1243: DEBUG('20', 'add_locators_grid', 9);
1244: END IF;
1245:
1246: IF p_current_zone_id IS NOT NULL THEN
1247: DBMS_SQL.bind_variable(
1248: l_query_handle
1249: , 'current_zone_id'
1250: , p_current_zone_id
1251: );

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

1252: DEBUG('30', 'add_locators_grid', 9);
1253: END IF;
1254:
1255: IF p_fm_sub_code IS NOT NULL THEN
1256: DBMS_SQL.bind_variable(l_query_handle, 'fm_sub_code', p_fm_sub_code);
1257: DEBUG('40', 'add_locators_grid', 9);
1258: END IF;
1259:
1260: IF p_to_sub_code IS NOT NULL THEN

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

1257: DEBUG('40', 'add_locators_grid', 9);
1258: END IF;
1259:
1260: IF p_to_sub_code IS NOT NULL THEN
1261: DBMS_SQL.bind_variable(l_query_handle, 'to_sub_code', p_to_sub_code);
1262: DEBUG('50', 'add_locators_grid', 9);
1263: END IF;
1264:
1265: IF p_fm_loc_id IS NOT NULL THEN

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

1262: DEBUG('50', 'add_locators_grid', 9);
1263: END IF;
1264:
1265: IF p_fm_loc_id IS NOT NULL THEN
1266: DBMS_SQL.bind_variable(l_query_handle, 'fm_loc_name', l_fm_loc_name); -- bug 3659062
1267:
1268: DEBUG('60', 'add_locators_grid', 9);
1269: END IF;
1270:

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

1268: DEBUG('60', 'add_locators_grid', 9);
1269: END IF;
1270:
1271: IF p_to_loc_id IS NOT NULL THEN
1272: DBMS_SQL.bind_variable(l_query_handle, 'to_loc_name', l_to_loc_name); -- bug 3659062
1273:
1274: DEBUG('70', 'add_locators_grid', 9);
1275: END IF;
1276:

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

1274: DEBUG('70', 'add_locators_grid', 9);
1275: END IF;
1276:
1277: IF p_locator_status IS NOT NULL THEN
1278: DBMS_SQL.bind_variable(l_query_handle, 'locator_status', p_locator_status);
1279: DEBUG('90', 'add_locators_grid', 9);
1280: END IF;
1281:
1282: IF p_subinventory_type IS NOT NULL THEN

Line 1283: DBMS_SQL.bind_variable(

1279: DEBUG('90', 'add_locators_grid', 9);
1280: END IF;
1281:
1282: IF p_subinventory_type IS NOT NULL THEN
1283: DBMS_SQL.bind_variable(
1284: l_query_handle
1285: , 'subinventory_type'
1286: , p_subinventory_type
1287: );

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

1288: DEBUG('100', 'add_locators_grid', 9);
1289: END IF;
1290:
1291: --IF p_subinventory_status IS NOT NULL THEN
1292: DBMS_SQL.bind_variable(l_query_handle, ':sub_status', 1);
1293: DEBUG('70', 'add_locators_grid', 9);
1294: -- END IF;
1295:
1296: IF p_fm_picking_order IS NOT NULL THEN

Line 1297: DBMS_SQL.bind_variable(

1293: DEBUG('70', 'add_locators_grid', 9);
1294: -- END IF;
1295:
1296: IF p_fm_picking_order IS NOT NULL THEN
1297: DBMS_SQL.bind_variable(
1298: l_query_handle
1299: , 'fm_picking_order'
1300: , p_fm_picking_order
1301: );

Line 1306: DBMS_SQL.bind_variable(

1302: DEBUG('110', 'add_locators_grid', 9);
1303: END IF;
1304:
1305: IF p_to_picking_order IS NOT NULL THEN
1306: DBMS_SQL.bind_variable(
1307: l_query_handle
1308: , 'to_picking_order'
1309: , p_to_picking_order
1310: );

Line 1315: DBMS_SQL.bind_variable(

1311: DEBUG('120', 'add_locators_grid', 9);
1312: END IF;
1313:
1314: IF p_fm_dropping_order IS NOT NULL THEN
1315: DBMS_SQL.bind_variable(
1316: l_query_handle
1317: , 'fm_dropping_order'
1318: , p_fm_dropping_order
1319: );

Line 1324: DBMS_SQL.bind_variable(

1320: DEBUG('130', 'add_locators_grid', 9);
1321: END IF;
1322:
1323: IF p_to_dropping_order IS NOT NULL THEN
1324: DBMS_SQL.bind_variable(
1325: l_query_handle
1326: , 'to_dropping_order'
1327: , p_to_dropping_order
1328: );

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

1329: DEBUG('140', 'add_locators_grid', 9);
1330: END IF;
1331:
1332: IF p_all_locators IS NOT NULL THEN
1333: DBMS_SQL.bind_variable(l_query_handle, 'all_locators', p_all_locators);
1334: DEBUG('150', 'add_locators_grid', 9);
1335: END IF; */
1336: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
1337: COMMIT;

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

1332: IF p_all_locators IS NOT NULL THEN
1333: DBMS_SQL.bind_variable(l_query_handle, 'all_locators', p_all_locators);
1334: DEBUG('150', 'add_locators_grid', 9);
1335: END IF; */
1336: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
1337: COMMIT;
1338: DEBUG ('l_query_count ' || l_query_count, 'add_locators_grid', 9);
1339: END add_locators_to_grid;
1340: