DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on OE_ORDER_PUB

Line 3184: l_line_rec OE_ORDER_PUB.line_rec_type;

3180: l_deliver_to_location_id1 number;
3181: l_intmed_ship_to_location_id number;
3182: l_intmed_ship_to_location_id1 number;
3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3181: l_intmed_ship_to_location_id number;
3182: l_intmed_ship_to_location_id1 number;
3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3183: l_location_status varchar2(30);
3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3184: l_line_rec OE_ORDER_PUB.line_rec_type;
3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3185: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;

Line 3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3186: l_control_rec OE_GLOBALS.control_rec_type;
3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3187: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;

Line 3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3188: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;

Line 3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;

3189: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;

Line 3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3190: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;

Line 3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;

3191: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

Line 3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;

3192: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;

Line 3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;

3193: l_action_request_out_tbl OE_Order_PUB.request_Tbl_type;
3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;

Line 3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;

3194: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;

Line 3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

3195: l_header_val_rec OE_Order_PUB.header_val_rec_type;
3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);

Line 3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;

3196: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);
3204: l_details varchar2(3000);

Line 3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;

3197: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_val_Tbl_Type;
3198: l_line_val_tbl OE_ORDER_PUB.Line_val_Tbl_Type;
3199: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
3200: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_val_Tbl_Type;
3201: l_header_Scredit_val_tbl OE_Order_PUB.header_Scredit_val_Tbl_Type;
3202: l_line_index NUMBER := 0;
3203: l_summary varchar2(3000);
3204: l_details varchar2(3000);
3205: l_get_msg_count number;

Line 3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

3453: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3454: dummy_rowid VARCHAR2(30);
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

3454: dummy_rowid VARCHAR2(30);
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:

Line 3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;

Line 3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;
3465: l_wf_source_code VARCHAR2(30);

Line 3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

3458: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
3459: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
3460: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
3461: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
3462: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
3463:
3464: l_wf_source_header_id NUMBER;
3465: l_wf_source_code VARCHAR2(30);
3466: l_wf_order_number NUMBER;