APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_LIST

Line 301: WHERE pick_slip_batch_id = WSH_PICK_LIST.G_BATCH_ID

297: --
298: CURSOR ps_list IS
299: SELECT pick_slip_number
300: FROM mtl_pick_slip_numbers
301: WHERE pick_slip_batch_id = WSH_PICK_LIST.G_BATCH_ID
302: AND status = 1;
303:
304: BEGIN
305:

Line 307: Stored in WSH_PICK_LIST.G_SEED_DOC_SET. Keeping it for compilation dependency

303:
304: BEGIN
305:
306: /* p_report_set_id is no longer used as we print the seeded Pick Slip report always
307: Stored in WSH_PICK_LIST.G_SEED_DOC_SET. Keeping it for compilation dependency
308: */
309: --
310: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
311: --

Line 357: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN

353: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
354: END IF;
355:
356: -- If report set id is NULL, there is no report to print
357: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
358: x_api_status := FND_API.G_RET_STS_SUCCESS;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');

Line 368: -- Added if condition IF WSH_PICK_LIST.G_PICK_REL_PARALLEL for

364: --
365: RETURN;
366: END IF;
367:
368: -- Added if condition IF WSH_PICK_LIST.G_PICK_REL_PARALLEL for
369: -- parallel pick-release
370:
371: IF (p_pick_slip_number = FND_API.G_MISS_NUM) THEN
372: IF (p_ps_mode = 'I') THEN

Line 374: IF WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN

370:
371: IF (p_pick_slip_number = FND_API.G_MISS_NUM) THEN
372: IF (p_ps_mode = 'I') THEN
373: -- Loop through the pl-sql table to print the remaining pick slips
374: IF WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN
375: OPEN ps_list;
376: LOOP
377: FETCH ps_list into l_pick_slip_number;
378: EXIT WHEN ps_list%NOTFOUND;

Line 379: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

375: OPEN ps_list;
376: LOOP
377: FETCH ps_list into l_pick_slip_number;
378: EXIT WHEN ps_list%NOTFOUND;
379: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
380: p_organization_id => p_organization_id,
381: p_pick_slip_number => l_pick_slip_number,
382: p_order_header_id => p_order_header_id,
383: p_batch_id => NULL,

Line 393: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

389: WHILE l_index IS NOT NULL LOOP
390: l_batch_id := null; /* Since specific P.slip Numbers are used here */
391: --
392: IF WSH_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
393: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
394: p_organization_id => p_organization_id,
395: p_pick_slip_number => INV_PR_PICK_SLIP_NUMBER.g_pskey_table(l_index).pick_slip_number,
396: p_order_header_id => p_order_header_id,
397: p_batch_id => l_batch_id,

Line 404: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

400: -- Remove from table
401: INV_PR_PICK_SLIP_NUMBER.g_pskey_table.delete(l_index);
402: l_index := INV_PR_PICK_SLIP_NUMBER.g_pskey_table.next(l_index);
403: ELSE
404: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
405: p_organization_id => p_organization_id,
406: p_pick_slip_number => g_pskey_table(l_index).pick_slip_number,
407: p_order_header_id => p_order_header_id,
408: p_batch_id => l_batch_id,

Line 421: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

417: END IF;
418: ELSE
419: l_ps_num := null; /* Since this is for an entire Batch and Not for p.Slip No (s) */
420: --
421: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
422: p_organization_id => p_organization_id,
423: p_pick_slip_number => l_ps_num,
424: p_order_header_id => p_order_header_id,
425: p_batch_id => p_batch_id,

Line 435: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

431: END IF;
432: --
433: END IF;
434: ELSE
435: Print_Pvt(p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
436: p_organization_id => p_organization_id,
437: p_pick_slip_number => p_pick_slip_number,
438: p_order_header_id => p_order_header_id,
439: p_batch_id => l_batch_id,

Line 478: p_batch_id := wsh_pick_list.g_batch_id;

474:
475: PROCEDURE delete_pick_slip_numbers(p_batch_id IN NUMBER) IS
476: BEGIN
477: /*if nvl(p_batch_id, -1) = -1 then
478: p_batch_id := wsh_pick_list.g_batch_id;
479: end if; */
480:
481: DELETE FROM mtl_pick_slip_numbers
482: WHERE pick_slip_batch_id = p_batch_id;

Line 823: IF (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL) THEN

819: if customer has applied INV-H and WSH-I, it should still
820: continue to work.
821:
822: */
823: IF (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL) THEN
824: -- Needed for inventory to know whether this API is triggered manually
825: -- or through pick release
826: x_call_mode := 'Y';
827: END IF;