81: l_payment_type VARCHAR2(50);
82: l_item_type_code VARCHAR2(30);
83: l_ato_line_id NUMBER;
84: -- For Process Order
85: l_line_rec OE_ORDER_PUB.line_rec_type;
86: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
87: l_line_tbl OE_ORDER_PUB.line_tbl_type;
88: l_control_rec OE_GLOBALS.control_rec_type;
89:
82: l_item_type_code VARCHAR2(30);
83: l_ato_line_id NUMBER;
84: -- For Process Order
85: l_line_rec OE_ORDER_PUB.line_rec_type;
86: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
87: l_line_tbl OE_ORDER_PUB.line_tbl_type;
88: l_control_rec OE_GLOBALS.control_rec_type;
89:
90: l_valid_employee VARCHAR2(25);
83: l_ato_line_id NUMBER;
84: -- For Process Order
85: l_line_rec OE_ORDER_PUB.line_rec_type;
86: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
87: l_line_tbl OE_ORDER_PUB.line_tbl_type;
88: l_control_rec OE_GLOBALS.control_rec_type;
89:
90: l_valid_employee VARCHAR2(25);
91: l_temp_employee_Id NUMBER; -- Temp ID got from profile option
1209: END Get_Shipto_Location_Id;
1210:
1211:
1212: Procedure Process_DropShip_CMS_Requests
1213: (p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.Request_Tbl_Type
1214: ,x_return_status OUT NOCOPY VARCHAR2
1215: )
1216: IS
1217: I NUMBER;