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 651: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;

647: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
648: END IF;
649: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
650:
651: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
652:
653: FOR crec in c_get_printers LOOP
654: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1).printer_name := crec.printer_name;
655: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT).conc_program_name := crec.conc_program_name;

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

650:
651: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
652:
653: FOR crec in c_get_printers LOOP
654: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1).printer_name := crec.printer_name;
655: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT).conc_program_name := crec.conc_program_name;
656: --
657: IF l_debug_on THEN
658: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_Document_sets for crec.printer_name ' || crec.printer_name );

Line 655: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT).conc_program_name := crec.conc_program_name;

651: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
652:
653: FOR crec in c_get_printers LOOP
654: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT+1).printer_name := crec.printer_name;
655: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT).conc_program_name := crec.conc_program_name;
656: --
657: IF l_debug_on THEN
658: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_Document_sets for crec.printer_name ' || crec.printer_name );
659: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_Document_sets for crec.conc_program_name ' || crec.conc_program_name );

Line 699: --WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;

695:
696: -- Bug 7347232 Deleting the Printer (set at Subinv or Org level) which was selected by INV for Seeded Pick Slip Report
697: -- Printer selected by INV should not be used for Document set other than Seeded Pick Slip Report
698: -- bugfix 13384185
699: --WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete;
700:
701: IF (p_doc_set_id <> -1 ) THEN
702: --{
703: IF l_debug_on THEN

Line 2581: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;

2577: ' Move Order Header Id '||BATCH_REC.MO_HEADER_ID||' ****');
2578: END IF;
2579:
2580: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2581: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2582: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2583: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2584:
2585: -- Set count for release rows to 0

Line 2582: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;

2578: END IF;
2579:
2580: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2581: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2582: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2583: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2584:
2585: -- Set count for release rows to 0
2586: l_curr_count := 0;

Line 2583: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;

2579:
2580: -- 10.20.10 Clear the Global PL/SQL Tables for printers.
2581: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
2582: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
2583: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2584:
2585: -- Set count for release rows to 0
2586: l_curr_count := 0;
2587: l_done_flag := FND_API.G_FALSE;

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

3282: --}
3283:
3284: -- Insert printer record into worker table for pick slip printing on specific printers
3285: --{
3286: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3287: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3288: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name IS NOT null THEN
3289: INSERT INTO WSH_PR_WORKERS (
3290: batch_id,

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

3283:
3284: -- Insert printer record into worker table for pick slip printing on specific printers
3285: --{
3286: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3287: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3288: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name IS NOT null THEN
3289: INSERT INTO WSH_PR_WORKERS (
3290: batch_id,
3291: type,

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

3284: -- Insert printer record into worker table for pick slip printing on specific printers
3285: --{
3286: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3287: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3288: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name IS NOT null THEN
3289: INSERT INTO WSH_PR_WORKERS (
3290: batch_id,
3291: type,
3292: organization_id,

Line 3300: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name,

3296: SELECT
3297: WSH_PICK_LIST.G_BATCH_ID,
3298: 'PRINTER',
3299: batch_rec.organization_id,
3300: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name,
3301: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name
3302: FROM dual
3303: WHERE NOT EXISTS (
3304: SELECT 'x'

Line 3301: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name

3297: WSH_PICK_LIST.G_BATCH_ID,
3298: 'PRINTER',
3299: batch_rec.organization_id,
3300: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name,
3301: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name
3302: FROM dual
3303: WHERE NOT EXISTS (
3304: SELECT 'x'
3305: FROM wsh_pr_workers

Line 3309: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name

3305: FROM wsh_pr_workers
3306: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3307: AND type = 'PRINTER'
3308: AND organization_id = batch_rec.organization_id
3309: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name
3310: AND conc_program_name=WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
3311: END IF;
3312: END LOOP;
3313: END IF;

Line 3310: AND conc_program_name=WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);

3306: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3307: AND type = 'PRINTER'
3308: AND organization_id = batch_rec.organization_id
3309: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name
3310: AND conc_program_name=WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
3311: END IF;
3312: END LOOP;
3313: END IF;
3314: --}

Line 4483: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;

4479:
4480: l_organization_id := l_organization_tab(idx);
4481:
4482: -- 90.1 Clear the Global PL/SQL Tables for printers.
4483: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4484: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4485: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4486:
4487: IF l_debug_on THEN

Line 4484: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;

4480: l_organization_id := l_organization_tab(idx);
4481:
4482: -- 90.1 Clear the Global PL/SQL Tables for printers.
4483: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4484: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4485: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4486:
4487: IF l_debug_on THEN
4488: WSH_DEBUG_SV.logmsg(l_module_name, '********************************************');

Line 4485: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;

4481:
4482: -- 90.1 Clear the Global PL/SQL Tables for printers.
4483: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.delete ;
4484: WSH_INV_INTEGRATION_GRP.G_ORGTAB.delete ;
4485: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
4486:
4487: IF l_debug_on THEN
4488: WSH_DEBUG_SV.logmsg(l_module_name, '********************************************');
4489: WSH_DEBUG_SV.logmsg(l_module_name, 'Processing Org ' || l_organization_id);