DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on OE_SHIP_CONFIRMATION_PUB

Line 5778: p_ship_line IN OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

5774: --
5775: --========================================================================
5776:
5777: PROCEDURE print_ship_line (p_bulk_mode IN varchar2,
5778: p_ship_line IN OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5779: p_start_index IN number default null,
5780: p_end_index IN number default null) IS
5781:
5782: l_debug_on BOOLEAN;

Line 5917: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

5913: --========================================================================
5914:
5915: PROCEDURE Process_Stop_To_OM (
5916: p_batch_id IN NUMBER,
5917: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5918: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5919: p_bulk_mode IN varchar2,
5920: p_org_id IN NUMBER DEFAULT NULL,
5921: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,

Line 5918: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

5914:
5915: PROCEDURE Process_Stop_To_OM (
5916: p_batch_id IN NUMBER,
5917: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5918: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5919: p_bulk_mode IN varchar2,
5920: p_org_id IN NUMBER DEFAULT NULL,
5921: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,
5922: x_charges_are_calculated IN OUT NOCOPY BOOLEAN ,

Line 5921: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,

5917: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5918: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
5919: p_bulk_mode IN varchar2,
5920: p_org_id IN NUMBER DEFAULT NULL,
5921: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,
5922: x_charges_are_calculated IN OUT NOCOPY BOOLEAN ,
5923: x_return_status IN OUT NOCOPY varchar2) IS
5924:
5925: l_debug_on BOOLEAN;

Line 5936: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

5932: x_msg_count number;
5933: x_msg_data VARCHAR2(3000);
5934:
5935: l_freight_costs_all WSH_FC_INTERFACE_PKG.OMInterfaceCostTabType;
5936: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
5937: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
5938:
5939: l_total_count NUMBER:=0;
5940: l_start_index NUMBER;

Line 5937: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

5933: x_msg_data VARCHAR2(3000);
5934:
5935: l_freight_costs_all WSH_FC_INTERFACE_PKG.OMInterfaceCostTabType;
5936: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
5937: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
5938:
5939: l_total_count NUMBER:=0;
5940: l_start_index NUMBER;
5941: l_end_index NUMBER;

Line 6268: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);

6264: IF l_debug_on THEN
6265: WSH_DEBUG_SV.logmsg(l_module_name,'After Forall Update');
6266: WSH_DEBUG_SV.logmsg(l_module_name,'Printing P_ship_line_rec');
6267: print_ship_line(p_bulk_mode,p_bulk_ship_line,l_start_index,l_end_index);
6268: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
6269: END IF;
6270: OE_Ship_Confirmation_Pub.Ship_Confirm_New(
6271: P_ship_line_rec => p_bulk_ship_line,
6272: P_requested_line_rec => p_bulk_req_line,

Line 6270: OE_Ship_Confirmation_Pub.Ship_Confirm_New(

6266: WSH_DEBUG_SV.logmsg(l_module_name,'Printing P_ship_line_rec');
6267: print_ship_line(p_bulk_mode,p_bulk_ship_line,l_start_index,l_end_index);
6268: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
6269: END IF;
6270: OE_Ship_Confirmation_Pub.Ship_Confirm_New(
6271: P_ship_line_rec => p_bulk_ship_line,
6272: P_requested_line_rec => p_bulk_req_line,
6273: P_line_adj_rec => l_ship_adj_line,
6274: P_bulk_mode => p_bulk_mode,

Line 6696: p_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

6692: --
6693: --========================================================================
6694:
6695: PROCEDURE extend_om_ship_line (
6696: p_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
6697: x_return_status OUT NOCOPY VARCHAR2) IS
6698:
6699: l_debug_on BOOLEAN;
6700: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'extend_om_ship_line';

Line 6950: l_line_qtys OE_SHIP_CONFIRMATION_PUB.Req_Quantity_Tbl_Type;

6946: PRAGMA EXCEPTION_INIT(line_locked, -54);
6947:
6948:
6949: -- OM bug 2022029
6950: l_line_qtys OE_SHIP_CONFIRMATION_PUB.Req_Quantity_Tbl_Type;
6951:
6952: -- anxsharm for Load Tender
6953: l_trip_id_tab wsh_util_core.id_tab_type;
6954:

Line 7202: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

7198: dd.organization_id,
7199: NVL(dd.oe_interfaced_flag, 'N') ,
7200: dl.initial_pickup_date ;
7201:
7202: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7203: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7204: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7205: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7206:

Line 7203: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

7199: NVL(dd.oe_interfaced_flag, 'N') ,
7200: dl.initial_pickup_date ;
7201:
7202: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7203: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7204: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7205: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7206:
7207: l_check_bulk VARCHAR2(1);

Line 7204: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

7200: dl.initial_pickup_date ;
7201:
7202: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7203: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7204: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7205: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7206:
7207: l_check_bulk VARCHAR2(1);
7208: l_prev_source_header_number VARCHAR2(150);

Line 7205: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

7201:
7202: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7203: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7204: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7205: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
7206:
7207: l_check_bulk VARCHAR2(1);
7208: l_prev_source_header_number VARCHAR2(150);
7209: l_bulk_count NUMBER:=0;

Line 7225: l_freight_costs OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

7221:
7222: l_org_id number;
7223: l_prev_org_id number;
7224: --HVOP heali
7225: l_freight_costs OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
7226: l_charges_are_calculated BOOLEAN DEFAULT FALSE;
7227: l_setsmc_input_rec OE_Shipping_Integration_PUB.Setsmc_Input_Rec_Type;
7228:
7229: oe_interface_rec c_oe_interface%ROWTYPE ;