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

Line 4208: l_model_tab oe_order_pub.Line_tbl_type;

4204: index by binary_integer;
4205:
4206: seg lSegType ;
4207:
4208: l_model_tab oe_order_pub.Line_tbl_type;
4209:
4210: -- Start Bugfix 2157740
4211: cursor c_get_org_id is
4212: select msi.organization_id src_org_id

Line 8379: l_model_tab oe_order_pub.Line_Tbl_Type;

8375: is
8376:
8377: lStmtNumber number;
8378: lItemName Varchar2(2000);
8379: l_model_tab oe_order_pub.Line_Tbl_Type;
8380: l_line_rec oe_order_pub.Line_Rec_type;
8381:
8382: l_msg_count number;
8383: l_msg_data varchar2(2000);

Line 8380: l_line_rec oe_order_pub.Line_Rec_type;

8376:
8377: lStmtNumber number;
8378: lItemName Varchar2(2000);
8379: l_model_tab oe_order_pub.Line_Tbl_Type;
8380: l_line_rec oe_order_pub.Line_Rec_type;
8381:
8382: l_msg_count number;
8383: l_msg_data varchar2(2000);
8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 8385: l_header_rec oe_order_pub.Header_Rec_Type;

8381:
8382: l_msg_count number;
8383: l_msg_data varchar2(2000);
8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

Line 8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;

8382: l_msg_count number;
8383: l_msg_data varchar2(2000);
8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

Line 8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;

8383: l_msg_data varchar2(2000);
8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

Line 8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;

8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;

Line 8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;

Line 8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;

Line 8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;

Line 8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;

8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;

Line 8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;

8389: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;

Line 8394: l_line_tbl oe_order_pub.Line_Tbl_Type;

8390: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;

Line 8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;

8391: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

Line 8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;

8392: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

Line 8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;

8393: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;

Line 8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;

8394: l_line_tbl oe_order_pub.Line_Tbl_Type;
8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;

Line 8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

8395: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

Line 8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

8396: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;

Line 8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;

8397: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;

Line 8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;

8398: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8406:

Line 8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

8399: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8406:
8407: l_config_line_id number;

Line 8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;

8400: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8406:
8407: l_config_line_id number;
8408: l_config_id number;

Line 8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;

8401: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8402: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8403: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8404: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8405: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8406:
8407: l_config_line_id number;
8408: l_config_id number;
8409: lLinkLineId number;

Line 8424: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;

8420:
8421: gUserId number;
8422: gLoginId number;
8423:
8424: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;
8425: l_upd_line_rec oe_order_pub.Line_Rec_type;
8426: l_option_line_id number;
8427: i number;
8428: x number;

Line 8425: l_upd_line_rec oe_order_pub.Line_Rec_type;

8421: gUserId number;
8422: gLoginId number;
8423:
8424: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;
8425: l_upd_line_rec oe_order_pub.Line_Rec_type;
8426: l_option_line_id number;
8427: i number;
8428: x number;
8429: y varchar(1);

Line 8535: l_model_tab(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

8531:
8532: end if ;
8533: /* BUG#2234858 Sushant added this for Drop Ship project */
8534:
8535: l_model_tab(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
8536: l_model_tab(1).operation := OE_Globals.G_OPR_CREATE;
8537: l_model_tab(1).inventory_item_id := pConfigId;
8538: l_model_tab(1).item_type_code := OE_Globals.G_ITEM_CONFIG;
8539: l_model_tab(1).ordered_quantity := l_line_rec.ordered_quantity;