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.MSC_X_VMI_POREQ dependencies on OE_ORDER_PUB

Line 941: lv_header_rec OE_Order_PUB.Header_Rec_Type;

937: )
938: IS
939:
940: /* IN variables */
941: lv_header_rec OE_Order_PUB.Header_Rec_Type;
942: lv_line_rec OE_Order_PUB.Line_Rec_Type;
943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;
944:
945: lv_action_rec OE_Order_PUB.Request_Rec_Type;

Line 942: lv_line_rec OE_Order_PUB.Line_Rec_Type;

938: IS
939:
940: /* IN variables */
941: lv_header_rec OE_Order_PUB.Header_Rec_Type;
942: lv_line_rec OE_Order_PUB.Line_Rec_Type;
943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;
944:
945: lv_action_rec OE_Order_PUB.Request_Rec_Type;
946: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;

Line 943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;

939:
940: /* IN variables */
941: lv_header_rec OE_Order_PUB.Header_Rec_Type;
942: lv_line_rec OE_Order_PUB.Line_Rec_Type;
943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;
944:
945: lv_action_rec OE_Order_PUB.Request_Rec_Type;
946: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
947:

Line 945: lv_action_rec OE_Order_PUB.Request_Rec_Type;

941: lv_header_rec OE_Order_PUB.Header_Rec_Type;
942: lv_line_rec OE_Order_PUB.Line_Rec_Type;
943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;
944:
945: lv_action_rec OE_Order_PUB.Request_Rec_Type;
946: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
947:
948: /* API return values */
949: lv_return_status varchar2(10);

Line 946: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;

942: lv_line_rec OE_Order_PUB.Line_Rec_Type;
943: lv_Line_Tbl_Type OE_Order_PUB.Line_Tbl_Type;
944:
945: lv_action_rec OE_Order_PUB.Request_Rec_Type;
946: lv_action_req_tbl OE_Order_PUB.Request_Tbl_Type;
947:
948: /* API return values */
949: lv_return_status varchar2(10);
950: lv_msg_count number;

Line 954: l_header_rec OE_Order_PUB.Header_Rec_Type;

950: lv_msg_count number;
951: lv_msg_data varchar2(5000);
952:
953: /* OUT variables */
954: l_header_rec OE_Order_PUB.Header_Rec_Type;
955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

951: lv_msg_data varchar2(5000);
952:
953: /* OUT variables */
954: l_header_rec OE_Order_PUB.Header_Rec_Type;
955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

952:
953: /* OUT variables */
954: l_header_rec OE_Order_PUB.Header_Rec_Type;
955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

953: /* OUT variables */
954: l_header_rec OE_Order_PUB.Header_Rec_Type;
955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

954: l_header_rec OE_Order_PUB.Header_Rec_Type;
955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

955: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

956: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

957: l_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

958: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

959: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

960: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

961: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

962: l_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

963: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

964: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

965: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

966: l_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

967: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
975:

Line 972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

968: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
975:
976: userid varchar2(10);

Line 973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

969: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
975:
976: userid varchar2(10);
977:

Line 974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

970: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
971: l_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
972: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
973: l_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
974: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
975:
976: userid varchar2(10);
977:
978: lv_sqlstmt VARCHAR2(4000);

Line 1111: lv_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1107: p_release_id;
1108:
1109: log_message('Rows selected into MSC_SO_RELEASE_INTERFACE = ' || SQL%ROWCOUNT);
1110:
1111: lv_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1112: lv_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1113:
1114: log_message('ACTION : '||lv_ACTION);
1115:

Line 1112: lv_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1108:
1109: log_message('Rows selected into MSC_SO_RELEASE_INTERFACE = ' || SQL%ROWCOUNT);
1110:
1111: lv_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1112: lv_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1113:
1114: log_message('ACTION : '||lv_ACTION);
1115:
1116: IF (lv_ACTION = G_CREATE) THEN