APPS.WSH_BATCH_PROCESS dependencies on STANDARD

Line 85: -- R12 MDC changes. Do not select consolidation deliveries. Only standard deliveries to be included

81: -- J Inbound Logistics jckwok
82: l_sc_WHERE := l_sc_WHERE || 'AND nvl(wnd.SHIPMENT_DIRECTION , ''O'') IN (''O'', ''IO'') ';
83: -- end of Inbound Logistics changes
84:
85: -- R12 MDC changes. Do not select consolidation deliveries. Only standard deliveries to be included
86:
87: l_sc_WHERE := l_sc_WHERE || 'AND wnd.DELIVERY_TYPE = ''STANDARD'' ';
88:
89: l_sc_EXISTS := l_sc_EXISTS ||' SELECT wdd.delivery_detail_id ';

Line 87: l_sc_WHERE := l_sc_WHERE || 'AND wnd.DELIVERY_TYPE = ''STANDARD'' ';

83: -- end of Inbound Logistics changes
84:
85: -- R12 MDC changes. Do not select consolidation deliveries. Only standard deliveries to be included
86:
87: l_sc_WHERE := l_sc_WHERE || 'AND wnd.DELIVERY_TYPE = ''STANDARD'' ';
88:
89: l_sc_EXISTS := l_sc_EXISTS ||' SELECT wdd.delivery_detail_id ';
90: l_sc_EXISTS := l_sc_EXISTS ||' FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda ';
91: l_sc_EXISTS := l_sc_EXISTS ||' WHERE wda.delivery_detail_id = wdd.delivery_detail_id ';

Line 1874: -- This is ship confirm concurrent program launched using standard report submisstion.

1870: -- Name
1871: -- PROCEDURE Confirm_Delivery_SRS
1872: --
1873: -- Purpose
1874: -- This is ship confirm concurrent program launched using standard report submisstion.
1875: -- It takes users defined criteria and construct a dynamic select statement to
1876: -- get a list of delivery IDs to be ship confirmed then call Ship_Confirm_Batch.
1877: -- The actual ship confirm operation is done in Ship_Cofirm_Batch procedure
1878: --

Line 1906: -- errbug - standard output parameter for a concurrent program

1902: -- p_log_level - Log Level
1903: -- p_actual_departure_date - Actual Departure Date for stop
1904: --
1905: -- Output Parameters:
1906: -- errbug - standard output parameter for a concurrent program
1907: -- retcode - standard output parameter for a concurrent program
1908: -- ----------------------------------------------------------------------
1909:
1910:

Line 1907: -- retcode - standard output parameter for a concurrent program

1903: -- p_actual_departure_date - Actual Departure Date for stop
1904: --
1905: -- Output Parameters:
1906: -- errbug - standard output parameter for a concurrent program
1907: -- retcode - standard output parameter for a concurrent program
1908: -- ----------------------------------------------------------------------
1909:
1910:
1911: procedure Confirm_Delivery_SRS(

Line 2356: -- This is auto pack deliveries concurrent program launched using standard

2352: -- Name
2353: -- PROCEDURE Auto_Pack_Deliveries_SRS
2354: --
2355: -- Purpose
2356: -- This is auto pack deliveries concurrent program launched using standard
2357: -- report submisstion.
2358: -- It takes users defined criteria and construct a dynamic select statement to
2359: -- get a list of delivery IDs to be auto packed then call Auto_Pack_Deliveries_Batch.
2360: -- The actual auto pack operation is done in Auto_Pack_Deliveries_Batch procedure

Line 2386: -- errbug - standard output parameter for a concurrent program

2382: -- p_dropoff_date_hi - Drop off Date (High)
2383: -- p_log_level - Log Level
2384: --
2385: -- Output Parameters:
2386: -- errbug - standard output parameter for a concurrent program
2387: -- retcode - standard output parameter for a concurrent program
2388: -- ----------------------------------------------------------------------
2389:
2390:

Line 2387: -- retcode - standard output parameter for a concurrent program

2383: -- p_log_level - Log Level
2384: --
2385: -- Output Parameters:
2386: -- errbug - standard output parameter for a concurrent program
2387: -- retcode - standard output parameter for a concurrent program
2388: -- ----------------------------------------------------------------------
2389:
2390:
2391: procedure Auto_Pack_Deliveries_SRS(