DBA Data[Home] [Help]

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: --RTV changes
89: IF (p_input_info.customer_id is not null) THEN

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: --RTV changes
89: IF (p_input_info.customer_id is not null) THEN
90: IF SubStr(p_input_info.customer_id,1,1) = 'V' THEN
91: l_sc_WHERE := l_sc_WHERE || 'AND wnd.consignee_flag = ''V'' ';

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

1894: -- Name
1895: -- PROCEDURE Confirm_Delivery_SRS
1896: --
1897: -- Purpose
1898: -- This is ship confirm concurrent program launched using standard report submisstion.
1899: -- It takes users defined criteria and construct a dynamic select statement to
1900: -- get a list of delivery IDs to be ship confirmed then call Ship_Confirm_Batch.
1901: -- The actual ship confirm operation is done in Ship_Cofirm_Batch procedure
1902: --

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

1927: -- p_log_level - Log Level
1928: -- p_actual_departure_date - Actual Departure Date for stop
1929: --
1930: -- Output Parameters:
1931: -- errbug - standard output parameter for a concurrent program
1932: -- retcode - standard output parameter for a concurrent program
1933: -- ----------------------------------------------------------------------
1934:
1935:

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

1928: -- p_actual_departure_date - Actual Departure Date for stop
1929: --
1930: -- Output Parameters:
1931: -- errbug - standard output parameter for a concurrent program
1932: -- retcode - standard output parameter for a concurrent program
1933: -- ----------------------------------------------------------------------
1934:
1935:
1936: procedure Confirm_Delivery_SRS(

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

2382: -- Name
2383: -- PROCEDURE Auto_Pack_Deliveries_SRS
2384: --
2385: -- Purpose
2386: -- This is auto pack deliveries concurrent program launched using standard
2387: -- report submisstion.
2388: -- It takes users defined criteria and construct a dynamic select statement to
2389: -- get a list of delivery IDs to be auto packed then call Auto_Pack_Deliveries_Batch.
2390: -- The actual auto pack operation is done in Auto_Pack_Deliveries_Batch procedure

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

2412: -- p_dropoff_date_hi - Drop off Date (High)
2413: -- p_log_level - Log Level
2414: --
2415: -- Output Parameters:
2416: -- errbug - standard output parameter for a concurrent program
2417: -- retcode - standard output parameter for a concurrent program
2418: -- ----------------------------------------------------------------------
2419:
2420:

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

2413: -- p_log_level - Log Level
2414: --
2415: -- Output Parameters:
2416: -- errbug - standard output parameter for a concurrent program
2417: -- retcode - standard output parameter for a concurrent program
2418: -- ----------------------------------------------------------------------
2419:
2420:
2421: procedure Auto_Pack_Deliveries_SRS(