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 4115: l_model_tab oe_order_pub.Line_tbl_type;

4111: index by binary_integer;
4112:
4113: seg lSegType ;
4114:
4115: l_model_tab oe_order_pub.Line_tbl_type;
4116:
4117: -- Start Bugfix 2157740
4118: cursor c_get_org_id is
4119: select msi.organization_id src_org_id

Line 8098: l_model_tab oe_order_pub.Line_Tbl_Type;

8094: is
8095:
8096: lStmtNumber number;
8097: lItemName Varchar2(2000);
8098: l_model_tab oe_order_pub.Line_Tbl_Type;
8099: l_line_rec oe_order_pub.Line_Rec_type;
8100:
8101: l_msg_count number;
8102: l_msg_data varchar2(2000);

Line 8099: l_line_rec oe_order_pub.Line_Rec_type;

8095:
8096: lStmtNumber number;
8097: lItemName Varchar2(2000);
8098: l_model_tab oe_order_pub.Line_Tbl_Type;
8099: l_line_rec oe_order_pub.Line_Rec_type;
8100:
8101: l_msg_count number;
8102: l_msg_data varchar2(2000);
8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 8104: l_header_rec oe_order_pub.Header_Rec_Type;

8100:
8101: l_msg_count number;
8102: l_msg_data varchar2(2000);
8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

Line 8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;

8101: l_msg_count number;
8102: l_msg_data varchar2(2000);
8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

Line 8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;

8102: l_msg_data varchar2(2000);
8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

Line 8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;

8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;

Line 8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;

Line 8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;

Line 8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;

Line 8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;

8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;
8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;

Line 8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;

8108: l_Header_price_Att_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;

Line 8113: l_line_tbl oe_order_pub.Line_Tbl_Type;

8109: l_Header_Adj_Att_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;

Line 8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;

8110: l_Header_Adj_Assoc_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

Line 8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;

8111: l_Header_Scredit_tbl oe_order_pub.Header_Scredit_Tbl_Type;
8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

Line 8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;

8112: l_Header_Scredit_val_tbl oe_order_pub.Header_Scredit_Val_Tbl_Type;
8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;

Line 8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;

8113: l_line_tbl oe_order_pub.Line_Tbl_Type;
8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;

Line 8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

8114: l_line_val_tbl oe_order_pub.Line_Val_Tbl_Type;
8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

Line 8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

8115: l_Line_Adj_tbl oe_order_pub.Line_Adj_Tbl_Type;
8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;

Line 8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;

8116: l_Line_Adj_val_tbl oe_order_pub.Line_Adj_Val_Tbl_Type;
8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;

Line 8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;

8117: l_Line_price_Att_tbl oe_order_pub.Line_Price_Att_Tbl_Type;
8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8125:

Line 8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

8118: l_Line_Adj_Att_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8125:
8126: l_config_line_id number;

Line 8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;

8119: l_Line_Adj_Assoc_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8125:
8126: l_config_line_id number;
8127: l_config_id number;

Line 8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;

8120: l_Line_Scredit_tbl oe_order_pub.Line_Scredit_Tbl_Type ;
8121: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_Val_Tbl_Type;
8122: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
8123: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_Val_Tbl_Type;
8124: l_action_request_tbl oe_order_pub.Request_Tbl_Type;
8125:
8126: l_config_line_id number;
8127: l_config_id number;
8128: lLinkLineId number;

Line 8143: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;

8139:
8140: gUserId number;
8141: gLoginId number;
8142:
8143: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;
8144: l_upd_line_rec oe_order_pub.Line_Rec_type;
8145: l_option_line_id number;
8146: i number;
8147: x number;

Line 8144: l_upd_line_rec oe_order_pub.Line_Rec_type;

8140: gUserId number;
8141: gLoginId number;
8142:
8143: l_upd_line_tbl oe_order_pub.Line_Tbl_Type;
8144: l_upd_line_rec oe_order_pub.Line_Rec_type;
8145: l_option_line_id number;
8146: i number;
8147: x number;
8148: y varchar(1);

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

8245:
8246: end if ;
8247: /* BUG#2234858 Sushant added this for Drop Ship project */
8248:
8249: l_model_tab(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
8250: l_model_tab(1).operation := OE_Globals.G_OPR_CREATE;
8251: l_model_tab(1).inventory_item_id := pConfigId;
8252: l_model_tab(1).item_type_code := OE_Globals.G_ITEM_CONFIG;
8253: l_model_tab(1).ordered_quantity := l_line_rec.ordered_quantity;