APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_LIST

Line 302: WHERE pick_slip_batch_id = WSH_PICK_LIST.G_BATCH_ID

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

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

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

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

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

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

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

Line 375: IF WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN

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

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

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

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

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

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

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

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

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

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

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

Line 479: p_batch_id := wsh_pick_list.g_batch_id;

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

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

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