DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on OE_ORDER_PUB

Line 2872: l_line_rec OE_ORDER_PUB.line_rec_type;

2868: l_deliver_to_location_id1 number;
2869: l_intmed_ship_to_location_id number;
2870: l_intmed_ship_to_location_id1 number;
2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2869: l_intmed_ship_to_location_id number;
2870: l_intmed_ship_to_location_id1 number;
2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2871: l_location_status varchar2(30);
2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2872: l_line_rec OE_ORDER_PUB.line_rec_type;
2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2873: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;

Line 2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2874: l_control_rec OE_GLOBALS.control_rec_type;
2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2875: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;

Line 2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2876: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;

Line 2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;

2877: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;

Line 2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2878: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;

Line 2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;

2879: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

Line 2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;

2880: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;

Line 2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;

2881: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;

Line 2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;

2882: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;

Line 2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

2883: l_header_val_rec OE_Order_PUB.header_val_rec_type;
2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);

Line 2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;

2884: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);
2892: l_details varchar2(3000);

Line 2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;

2885: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
2886: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
2887: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
2888: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
2889: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
2890: l_line_index NUMBER := 0;
2891: l_summary varchar2(3000);
2892: l_details varchar2(3000);
2893: l_get_msg_count number;

Line 3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

3141: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3142: dummy_rowid VARCHAR2(30);
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

3142: dummy_rowid VARCHAR2(30);
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:

Line 3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;

Line 3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;
3153: l_wf_source_code VARCHAR2(30);

Line 3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

3146: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3147: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3148: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3149: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3150: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3151:
3152: l_wf_source_header_id NUMBER;
3153: l_wf_source_code VARCHAR2(30);
3154: l_wf_order_number NUMBER;