DBA Data[Home] [Help]

APPS.INV_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_LIST

Line 372: IF (wsh_pick_list.g_batch_id IS NOT NULL) THEN

368: l_hash_value NUMBER;
369: l_rule_index NUMBER;
370: l_found BOOLEAN;
371: BEGIN
372: IF (wsh_pick_list.g_batch_id IS NOT NULL) THEN
373: -- Needed for inventory to know whether this API is triggered Manually or thru Pick Release
374: x_call_mode := 'Y';
375: END IF;
376:

Line 1087: l_batch_id NUMBER := WSH_PICK_LIST.G_BATCH_ID;

1083: , p_dest_locator_id IN NUMBER DEFAULT NULL
1084: , p_project_id IN NUMBER DEFAULT NULL
1085: , p_task_id IN NUMBER DEFAULT NULL
1086: ) IS
1087: l_batch_id NUMBER := WSH_PICK_LIST.G_BATCH_ID;
1088: l_hash_string VARCHAR2(2000);
1089: BEGIN
1090:
1091: l_hash_string := TO_CHAR(l_batch_id) || '-' || TO_CHAR(g_rule_table(p_rule_index).grouping_rule_id);

Line 1190: l_batch_id NUMBER := WSH_PICK_LIST.G_BATCH_ID;

1186:
1187: PRAGMA AUTONOMOUS_TRANSACTION;
1188:
1189: l_debug NUMBER;
1190: l_batch_id NUMBER := WSH_PICK_LIST.G_BATCH_ID;
1191: l_pick_slip_status NUMBER;
1192: l_pick_slip_count NUMBER;
1193: l_pick_slip_number NUMBER;
1194: l_num_attempts NUMBER;

Line 1464: IF (wsh_pick_list.g_batch_id IS NOT NULL) THEN

1460: l_rule_index NUMBER;
1461: l_found BOOLEAN;
1462: l_pick_slip_status NUMBER;
1463: BEGIN
1464: IF (wsh_pick_list.g_batch_id IS NOT NULL) THEN
1465: -- Needed for inventory to know whether this API is triggered Manually or thru Pick Release
1466: x_call_mode := 'Y';
1467: END IF;
1468: