eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_ORDER_PUB

Line 24: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

20: --FORWARD Declaration
21: PROCEDURE Populate_OM_Common_Attr(
22: p_om_header_rec IN OM_Header_Rec_Type,
23: p_del_interface_rec IN Del_Interface_Rec_Type,
24: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
25: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
27: x_return_status OUT NOCOPY VARCHAR2 );
28:

Line 25: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

21: PROCEDURE Populate_OM_Common_Attr(
22: p_om_header_rec IN OM_Header_Rec_Type,
23: p_del_interface_rec IN Del_Interface_Rec_Type,
24: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
25: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
27: x_return_status OUT NOCOPY VARCHAR2 );
28:
29: PROCEDURE Print_OE_Header_Record(

Line 26: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,

22: p_om_header_rec IN OM_Header_Rec_Type,
23: p_del_interface_rec IN Del_Interface_Rec_Type,
24: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
25: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
27: x_return_status OUT NOCOPY VARCHAR2 );
28:
29: PROCEDURE Print_OE_Header_Record(
30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,

Line 30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,

26: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
27: x_return_status OUT NOCOPY VARCHAR2 );
28:
29: PROCEDURE Print_OE_Header_Record(
30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
31: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:

Line 31: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,

27: x_return_status OUT NOCOPY VARCHAR2 );
28:
29: PROCEDURE Print_OE_Header_Record(
30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
31: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:
35: PROCEDURE Print_OE_Line_Record(

Line 32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,

28:
29: PROCEDURE Print_OE_Header_Record(
30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
31: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:
35: PROCEDURE Print_OE_Line_Record(
36: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

Line 33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );

29: PROCEDURE Print_OE_Header_Record(
30: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
31: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:
35: PROCEDURE Print_OE_Line_Record(
36: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
37: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type );

Line 36: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

32: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:
35: PROCEDURE Print_OE_Line_Record(
36: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
37: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type );
38:
39: PROCEDURE Populate_Error_Records(
40: p_interface_id IN NUMBER,

Line 37: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type );

33: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type );
34:
35: PROCEDURE Print_OE_Line_Record(
36: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
37: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type );
38:
39: PROCEDURE Populate_Error_Records(
40: p_interface_id IN NUMBER,
41: p_interface_table_name IN VARCHAR2,

Line 834: l_currency_code VARCHAR2(15); -- as per transactional_curr_code in OE_Order_PUB.Header_Rec_Type

830:
831: l_return_status VARCHAR2(1);
832: l_tmp VARCHAR2(10);
833: l_standalone_mode VARCHAR2(1);
834: l_currency_code VARCHAR2(15); -- as per transactional_curr_code in OE_Order_PUB.Header_Rec_Type
835: l_temp_currency_code VARCHAR2(15);
836: l_temp_status VARCHAR2(15);
837: l_error_msg VARCHAR2(4000);
838: l_msg_data VARCHAR2(4000);

Line 874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

870: l_om_line_tbl_type OM_Line_Tbl_Type;
871: l_new_del_rec Del_Interface_Rec_Type;
872: l_details_interface_tab Del_Details_Interface_Rec_Tab;
873:
874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

Line 875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

871: l_new_del_rec Del_Interface_Rec_Type;
872: l_details_interface_tab Del_Details_Interface_Rec_Tab;
873:
874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

872: l_details_interface_tab Del_Details_Interface_Rec_Tab;
873:
874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

873:
874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

874: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;

Line 879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

875: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;

Line 880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

876: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:

Line 881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

877: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;

Line 882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;

878: l_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

Line 883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;

879: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
880: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

Line 885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;

881: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;

882: l_header_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;

883: l_line_customer_info_tbl OE_ORDER_PUB.Customer_Info_Table_Type;
884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;

884:
885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

Line 889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

885: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

Line 890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

886: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

Line 891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

887: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

Line 892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;

888: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;

889: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

Line 894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

890: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;

891: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

Line 896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

892: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

893: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

894: x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;

895: x_Header_Payment_val_tbl OE_ORDER_PUB.Header_Payment_Val_Tbl_Type;
896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

Line 900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

896: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

Line 901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

897: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

Line 902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

898: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

Line 903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;

899: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

Line 904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;

900: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

Line 905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

901: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

Line 906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;

902: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
910: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;

903: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
910: l_control_rec OE_GLOBALS.Control_Rec_Type;
911:

Line 908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;

904: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
910: l_control_rec OE_GLOBALS.Control_Rec_Type;
911:
912: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

Line 909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

905: x_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
906: x_Line_Payment_val_tbl OE_ORDER_PUB.Line_Payment_Val_Tbl_Type;
907: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
908: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
909: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
910: l_control_rec OE_GLOBALS.Control_Rec_Type;
911:
912: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
913: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 1735: l_line_val_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_VAL_REC;

1731: goto loop_end;
1732: ELSE
1733: FOR i in l_line_tbl.first..l_line_tbl.last
1734: LOOP
1735: l_line_val_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_VAL_REC;
1736: END LOOP;
1737: END IF;
1738: END IF; -- } Action Add/Change
1739:

Line 1747: l_header_val_rec := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;

1743: -- Process Order Public API does not accecpt l_control_rec parameter,
1744: -- so Shipping has to call Process Order Group API(which acceps p_control_rec parameter)
1745: l_control_rec.controlled_operation := TRUE;
1746: l_control_rec.process_partial := TRUE;
1747: l_header_val_rec := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1748:
1749: l_line_doc_ref := 'SHIPMENT_REQUEST_LINE';
1750:
1751: --

Line 3790: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,

3786: -- Shipping debug is enabled.
3787: --=============================================================================
3788: --
3789: PROCEDURE Print_OE_Header_Record(
3790: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
3791: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
3792: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
3793: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type )
3794: IS

Line 3791: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,

3787: --=============================================================================
3788: --
3789: PROCEDURE Print_OE_Header_Record(
3790: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
3791: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
3792: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
3793: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type )
3794: IS
3795: --

Line 3792: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,

3788: --
3789: PROCEDURE Print_OE_Header_Record(
3790: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
3791: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
3792: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
3793: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type )
3794: IS
3795: --
3796: l_debug_on BOOLEAN;

Line 3793: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type )

3789: PROCEDURE Print_OE_Header_Record(
3790: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
3791: p_header_val_rec IN OE_ORDER_PUB.Header_Val_Rec_Type,
3792: p_customer_info IN OE_ORDER_PUB.Customer_Info_Table_Type,
3793: p_action_request_tbl IN OE_ORDER_PUB.Request_Tbl_Type )
3794: IS
3795: --
3796: l_debug_on BOOLEAN;
3797: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Print_OE_Header_Record';

Line 4002: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

3998: -- API to print order line attributes, If Shipping debug is enabled.
3999: --=============================================================================
4000: --
4001: PROCEDURE Print_OE_Line_Record(
4002: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
4003: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type )
4004: IS
4005: --
4006: l_debug_on BOOLEAN;

Line 4003: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type )

3999: --=============================================================================
4000: --
4001: PROCEDURE Print_OE_Line_Record(
4002: p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
4003: p_line_val_tbl IN OE_ORDER_PUB.Line_Val_Tbl_Type )
4004: IS
4005: --
4006: l_debug_on BOOLEAN;
4007: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Print_OE_Line_Record';

Line 4866: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

4862: --
4863: PROCEDURE Populate_OM_Common_Attr(
4864: p_om_header_rec IN OM_Header_Rec_Type,
4865: p_del_interface_rec IN Del_Interface_Rec_Type,
4866: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
4867: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
4868: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
4869: x_return_status OUT NOCOPY VARCHAR2 )
4870: IS

Line 4867: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

4863: PROCEDURE Populate_OM_Common_Attr(
4864: p_om_header_rec IN OM_Header_Rec_Type,
4865: p_del_interface_rec IN Del_Interface_Rec_Type,
4866: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
4867: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
4868: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
4869: x_return_status OUT NOCOPY VARCHAR2 )
4870: IS
4871:

Line 4868: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,

4864: p_om_header_rec IN OM_Header_Rec_Type,
4865: p_del_interface_rec IN Del_Interface_Rec_Type,
4866: x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
4867: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
4868: x_customer_info OUT NOCOPY OE_ORDER_PUB.Customer_Info_Table_Type,
4869: x_return_status OUT NOCOPY VARCHAR2 )
4870: IS
4871:
4872: l_index NUMBER;

Line 4900: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

4896: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Sold-To-Customer Information');
4897: END IF;
4898: --
4899: l_index := x_customer_info.count + 1;
4900: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
4901: x_header_rec.sold_to_customer_ref := g_sold_to_ref;
4902:
4903: x_customer_info(l_index).customer_info_ref := g_sold_to_ref;
4904: x_customer_info(l_index).customer_info_type_code := 'CUSTOMER';

Line 4928: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

4924: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Ship-To-Customer Information');
4925: END IF;
4926: --
4927: l_index := x_customer_info.count + 1;
4928: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
4929: x_header_rec.ship_to_customer_ref := g_ship_to_ref;
4930:
4931: x_customer_info(l_index).customer_info_ref := g_ship_to_ref;
4932: x_customer_info(l_index).customer_info_type_code := 'CUSTOMER';

Line 4957: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

4953: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Invoice-To-Customer Information');
4954: END IF;
4955: --
4956: l_index := x_customer_info.count + 1;
4957: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
4958: x_header_rec.invoice_to_customer_ref := g_invoice_to_ref;
4959:
4960: x_customer_info(l_index).customer_info_ref := g_invoice_to_ref;
4961: x_customer_info(l_index).customer_info_type_code := 'CUSTOMER';

Line 4988: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

4984: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Deliver-To-Customer Information');
4985: END IF;
4986: --
4987: l_index := x_customer_info.count + 1;
4988: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
4989: x_header_rec.deliver_to_customer_ref := g_deliver_to_ref;
4990:
4991: x_customer_info(l_index).customer_info_ref := g_deliver_to_ref;
4992: x_customer_info(l_index).customer_info_type_code := 'CUSTOMER';

Line 5013: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5009: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Ship-To-Address Information');
5010: END IF;
5011: --
5012: l_index := x_customer_info.count + 1;
5013: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5014: x_header_rec.ship_to_address_ref := g_ship_to_address_ref;
5015:
5016: x_customer_info(l_index).customer_info_type_code := 'ADDRESS';
5017: x_customer_info(l_index).customer_info_ref := g_ship_to_address_ref;

Line 5045: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5041: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Invoice-To-Address Information');
5042: END IF;
5043: --
5044: l_index := x_customer_info.count + 1;
5045: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5046: x_header_rec.invoice_to_address_ref := g_invoice_to_address_ref;
5047:
5048: x_customer_info(l_index).customer_info_type_code := 'ADDRESS';
5049: x_customer_info(l_index).customer_info_ref := g_invoice_to_address_ref;

Line 5080: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5076: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Deliver-To-Address Information');
5077: END IF;
5078: --
5079: l_index := x_customer_info.count + 1;
5080: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5081: x_header_rec.deliver_to_address_ref := g_deliver_to_address_ref;
5082:
5083: x_customer_info(l_index).customer_info_type_code := 'ADDRESS';
5084: x_customer_info(l_index).customer_info_ref := g_deliver_to_address_ref;

Line 5121: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5117: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Ship-To Contact Information');
5118: END IF;
5119: --
5120: l_index := x_customer_info.count + 1;
5121: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5122: x_header_rec.ship_to_contact_ref := g_ship_to_contact_ref;
5123:
5124: x_customer_info(l_index).customer_info_type_code := 'CONTACT';
5125: x_customer_info(l_index).customer_info_ref := g_ship_to_contact_ref;

Line 5159: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5155: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Invoice-To Contact Information');
5156: END IF;
5157: --
5158: l_index := x_customer_info.count + 1;
5159: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5160: x_header_rec.invoice_to_contact_ref := g_invoice_to_contact_ref;
5161:
5162: x_customer_info(l_index).customer_info_type_code := 'CONTACT';
5163: x_customer_info(l_index).customer_info_ref := g_invoice_to_contact_ref;

Line 5197: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;

5193: WSH_DEBUG_SV.logmsg(l_module_name, 'Adding Deliver-To Contact Information');
5194: END IF;
5195: --
5196: l_index := x_customer_info.count + 1;
5197: x_customer_info(l_index) := OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_REC;
5198: x_header_rec.deliver_to_contact_ref := g_deliver_to_contact_ref;
5199:
5200: x_customer_info(l_index).customer_info_type_code := 'CONTACT';
5201: x_customer_info(l_index).customer_info_ref := g_deliver_to_contact_ref;

Line 5365: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

5361: PROCEDURE Populate_Header_Rec(
5362: p_action_type IN VARCHAR2,
5363: p_om_header_rec IN OM_Header_Rec_Type,
5364: p_del_interface_rec IN Del_Interface_Rec_Type,
5365: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
5366: x_return_status OUT NOCOPY VARCHAR2 ) IS
5367:
5368:
5369: CURSOR c_get_source_id( p_client_code IN VARCHAR2) IS

Line 5396: x_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

5392: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5393:
5394: l_header_id := p_om_header_rec.header_id;
5395:
5396: x_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
5397: x_header_rec.version_number := p_del_interface_rec.document_revision;
5398: -- LSP PROJECT : Populate orig sys document ref as 'SHIPMENT_REQUEST:CLIENT CODE:ORDER NUMBER
5399: IF p_del_interface_rec.client_code IS NOT NULL THEN
5400: x_header_rec.orig_sys_document_ref := 'SHIPMENT_REQUEST:'||p_del_interface_rec.client_code||':'||p_del_interface_rec.order_number;

Line 6363: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

6359: p_om_line_tbl_type IN OM_Line_Tbl_Type,
6360: p_details_interface_rec_tab IN Del_Details_Interface_Rec_Tab,
6361: p_om_header_rec_type IN OM_Header_Rec_Type,
6362: p_delivery_interface_rec IN Del_Interface_Rec_Type,
6363: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
6364: x_line_details_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6365: x_return_status OUT NOCOPY VARCHAR2 )
6366: IS
6367: CURSOR c_non_interface_order_lines

Line 6430: x_line_tbl(l_line_cnt) := OE_ORDER_PUB.G_MISS_LINE_REC;

6426: goto zero_req_quantity;
6427: END IF;
6428:
6429: l_line_cnt := l_line_cnt + 1;
6430: x_line_tbl(l_line_cnt) := OE_ORDER_PUB.G_MISS_LINE_REC;
6431:
6432: l_line_id := p_details_interface_rec_tab(i).line_id;
6433:
6434: -- LSP PROJECT commented out the following code.

Line 6610: x_line_tbl(l_line_cnt) := OE_ORDER_PUB.G_MISS_LINE_REC;

6606: WSH_DEBUG_SV.logmsg(l_module_name, 'Non-Interface details, Line Id => ' || l_non_interface_rec.line_id
6607: || ', Line Number => ' || l_non_interface_rec.line_number );
6608: END IF;
6609: l_line_cnt := l_line_cnt + 1;
6610: x_line_tbl(l_line_cnt) := OE_ORDER_PUB.G_MISS_LINE_REC;
6611: x_line_tbl(l_line_cnt).operation := OE_GLOBALS.G_OPR_UPDATE;
6612: x_line_tbl(l_line_cnt).line_id := l_non_interface_rec.line_id;
6613: x_line_tbl(l_line_cnt).calculate_price_flag := 'N';
6614: -- LSP PROJECT: commented the following after discussion with UMA.