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.WSH_PICK_LIST dependencies on WSH_INV_INTEGRATION_GRP

Line 645: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;

641: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
642: END IF;
643: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
644:
645: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
646: FOR crec in c_get_printers LOOP
647: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1) := crec.printer_name;
648: END LOOP;
649:

Line 647: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1) := crec.printer_name;

643: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
644:
645: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
646: FOR crec in c_get_printers LOOP
647: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1) := crec.printer_name;
648: END LOOP;
649:
650: IF p_print_ps = 'Y' THEN
651: --{

Line 685: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;

681:
682: -- Bug 7347232 Deleting the Printer (set at Subinv or Org level) which was selected by INV for Seeded Pick Slip Report
683: -- Printer selected by INV should not be used for Document set other than Seeded Pick Slip Report
684:
685: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
686:
687: IF (p_doc_set_id <> -1 ) THEN
688: --{
689: IF l_debug_on THEN

Line 2519: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;

2515: ' Move Order Header Id '||BATCH_REC.MO_HEADER_ID||' ****');
2516: END IF;
2517:
2518: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2519: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2520: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2521: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2522:
2523: -- Set count for release rows to 0

Line 2520: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;

2516: END IF;
2517:
2518: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2519: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2520: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2521: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2522:
2523: -- Set count for release rows to 0
2524: l_curr_count := 0;

Line 2521: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;

2517:
2518: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2519: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2520: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2521: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2522:
2523: -- Set count for release rows to 0
2524: l_curr_count := 0;
2525: l_done_flag := FND_API.G_FALSE;

Line 3200: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN

3196: --}
3197:
3198: -- Insert printer record into worker table for pick slip printing on specific printers
3199: --{
3200: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3201: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3202: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) IS NOT null THEN
3203: INSERT INTO WSH_PR_WORKERS (
3204: batch_id,

Line 3201: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP

3197:
3198: -- Insert printer record into worker table for pick slip printing on specific printers
3199: --{
3200: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3201: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3202: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) IS NOT null THEN
3203: INSERT INTO WSH_PR_WORKERS (
3204: batch_id,
3205: type,

Line 3202: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) IS NOT null THEN

3198: -- Insert printer record into worker table for pick slip printing on specific printers
3199: --{
3200: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3201: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3202: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) IS NOT null THEN
3203: INSERT INTO WSH_PR_WORKERS (
3204: batch_id,
3205: type,
3206: organization_id,

Line 3213: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i)

3209: SELECT
3210: WSH_PICK_LIST.G_BATCH_ID,
3211: 'PRINTER',
3212: batch_rec.organization_id,
3213: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i)
3214: FROM dual
3215: WHERE NOT EXISTS (
3216: SELECT 'x'
3217: FROM wsh_pr_workers

Line 3221: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i));

3217: FROM wsh_pr_workers
3218: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3219: AND type = 'PRINTER'
3220: AND organization_id = batch_rec.organization_id
3221: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i));
3222: END IF;
3223: END LOOP;
3224: END IF;
3225: --}

Line 4391: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;

4387:
4388: l_organization_id := l_organization_tab(idx);
4389:
4390: -- 90.1 Clear the Global PL/SQL Tables for printers.
4391: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4392: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4393: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4394:
4395: IF l_debug_on THEN

Line 4392: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;

4388: l_organization_id := l_organization_tab(idx);
4389:
4390: -- 90.1 Clear the Global PL/SQL Tables for printers.
4391: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4392: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4393: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4394:
4395: IF l_debug_on THEN
4396: WSH_DEBUG_SV.logmsg(l_module_name, '********************************************');

Line 4393: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;

4389:
4390: -- 90.1 Clear the Global PL/SQL Tables for printers.
4391: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4392: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4393: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4394:
4395: IF l_debug_on THEN
4396: WSH_DEBUG_SV.logmsg(l_module_name, '********************************************');
4397: WSH_DEBUG_SV.logmsg(l_module_name, 'Processing Org ' || l_organization_id);