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

Line 1057: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;

1053: l_control_rec.request_type_code := 'ONT';
1054: l_control_rec.rounding_flag := 'Q';
1055: --For multi_currency price list
1056: l_control_rec.use_multi_currency:='Y';
1057: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
1058: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
1059: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1060: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
1061:

Line 1058: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;

1054: l_control_rec.rounding_flag := 'Q';
1055: --For multi_currency price list
1056: l_control_rec.use_multi_currency:='Y';
1057: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
1058: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
1059: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1060: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
1061:
1062: END set_pricing_control_record;

Line 1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197

1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.add( 'QTY='||G_QTY|| ' ITEM_TYPE_CODE='||P_ITEM_TYPE_CODE|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE|| ' UOM='||G_UOM ) ;
1095: END IF;
1096:
1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;

Line 1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197

1094: oe_debug_pub.add( 'QTY='||G_QTY|| ' ITEM_TYPE_CODE='||P_ITEM_TYPE_CODE|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE|| ' UOM='||G_UOM ) ;
1095: END IF;
1096:
1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;

Line 1099: oe_order_pub.g_line.pricing_date := g_pricing_date;

1095: END IF;
1096:
1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;

Line 1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;

1096:
1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;

Line 1101: oe_order_pub.g_line.agreement_id := g_agreement_id;

1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;

Line 1102: --oe_order_pub.g_line.ordered_date := g_request_date;

1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197
1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;

Line 1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;

1099: oe_order_pub.g_line.pricing_date := g_pricing_date;
1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;

Line 1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;

1100: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;

Line 1105: oe_order_pub.g_line.ordered_quantity := g_qty;

1101: oe_order_pub.g_line.agreement_id := g_agreement_id;
1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;

Line 1106: oe_order_pub.g_line.line_id := g_line_id;

1102: --oe_order_pub.g_line.ordered_date := g_request_date;
1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;

Line 1107: oe_order_pub.g_line.header_id := g_header_id;

1103: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;

Line 1108: oe_order_pub.g_line.item_type_code := p_item_type_code;

1104: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;
1112: oe_order_pub.g_line.order_quantity_uom := g_uom;

Line 1109: oe_order_pub.g_line.price_list_id := g_price_list_id;

1105: oe_order_pub.g_line.ordered_quantity := g_qty;
1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;
1112: oe_order_pub.g_line.order_quantity_uom := g_uom;
1113:

Line 1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;

1106: oe_order_pub.g_line.line_id := g_line_id;
1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;
1112: oe_order_pub.g_line.order_quantity_uom := g_uom;
1113:
1114:

Line 1111: oe_order_pub.g_line.price_request_code := p_price_request_code;

1107: oe_order_pub.g_line.header_id := g_header_id;
1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;
1112: oe_order_pub.g_line.order_quantity_uom := g_uom;
1113:
1114:
1115: IF g_item_identifier_type ='INT' then

Line 1112: oe_order_pub.g_line.order_quantity_uom := g_uom;

1108: oe_order_pub.g_line.item_type_code := p_item_type_code;
1109: oe_order_pub.g_line.price_list_id := g_price_list_id;
1110: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1111: oe_order_pub.g_line.price_request_code := p_price_request_code;
1112: oe_order_pub.g_line.order_quantity_uom := g_uom;
1113:
1114:
1115: IF g_item_identifier_type ='INT' then
1116:

Line 1118: INTO oe_order_pub.g_line.ordered_item

1114:
1115: IF g_item_identifier_type ='INT' then
1116:
1117: SELECT concatenated_segments
1118: INTO oe_order_pub.g_line.ordered_item
1119: FROM mtl_system_items_kfv
1120: WHERE inventory_item_id = g_related_item_id
1121: AND organization_id = l_org_id;
1122:

Line 1197: If OE_Order_PUB.G_Line.agreement_id is not null and

1193:
1194: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1195: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1196:
1197: If OE_Order_PUB.G_Line.agreement_id is not null and
1198: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1199: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1200: Else
1201: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';

Line 1198: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then

1194: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1195: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1196:
1197: If OE_Order_PUB.G_Line.agreement_id is not null and
1198: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1199: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1200: Else
1201: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
1202: End If;

Line 1243: l_header_rec OE_ORDER_PUB.header_rec_type;

1239: --
1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1241: --
1242: /*4163551*/
1243: l_header_rec OE_ORDER_PUB.header_rec_type;
1244: /*4163551*/
1245: BEGIN
1246:
1247: IF l_debug_level > 0 THEN

Line 1275: oe_order_pub.g_hdr:=l_header_rec;

1271: END IF;
1272:
1273: IF l_header_rec.header_id IS NOT NULL AND
1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;

Line 1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);

1273: IF l_header_rec.header_id IS NOT NULL AND
1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;
1280: /*4163551*/
1281: ELSE

Line 1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);

1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;
1280: /*4163551*/
1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;

Line 1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;

1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;
1280: /*4163551*/
1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;

Line 1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;

1279: END IF;
1280: /*4163551*/
1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;

Line 1284: oe_order_pub.g_hdr.ordered_date := g_request_date;

1280: /*4163551*/
1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

Line 1285: oe_order_pub.g_hdr.header_id := g_header_id;

1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;

Line 1286: oe_order_pub.g_hdr.org_id := l_org_id;

1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;

Line 1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;

1283: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;

Line 1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

1284: oe_order_pub.g_hdr.ordered_date := g_request_date;
1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;

Line 1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;

1285: oe_order_pub.g_hdr.header_id := g_header_id;
1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;

Line 1290: oe_order_pub.g_hdr.request_date := g_request_date;

1286: oe_order_pub.g_hdr.org_id := l_org_id;
1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;

Line 1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;

1287: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;

Line 1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;

1288: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

Line 1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;

1289: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

Line 1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;

1290: oe_order_pub.g_hdr.request_date := g_request_date;
1291: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;

Line 1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

1292: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;
1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;

Line 1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

1293: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;
1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1301:

Line 1298: --oe_order_pub.g_line.line_id := g_line_id;

1294: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;
1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1301:
1302:

Line 1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;

1295: END IF;
1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;
1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1301:
1302:
1303: /*If p_item_identifier_type ='INT' then

Line 1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;

1296: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1297: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1298: --oe_order_pub.g_line.line_id := g_line_id;
1299: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1300: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1301:
1302:
1303: /*If p_item_identifier_type ='INT' then
1304:

Line 1306: INTO oe_order_pub.g_line.ordered_item

1302:
1303: /*If p_item_identifier_type ='INT' then
1304:
1305: SELECT concatenated_segments
1306: INTO oe_order_pub.g_line.ordered_item
1307: FROM mtl_system_items_kfv
1308: WHERE inventory_item_id = g_inventory_item_id
1309: AND organization_id = l_org_id;
1310:

Line 2414: oe_order_pub.g_hdr:=null;

2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2411: --
2412: BEGIN
2413: /*4163551*/
2414: oe_order_pub.g_hdr:=null;
2415: oe_order_pub.g_line:=null;
2416: /*4163551*/
2417:
2418: --copy_fields_to_globals;

Line 2415: oe_order_pub.g_line:=null;

2411: --
2412: BEGIN
2413: /*4163551*/
2414: oe_order_pub.g_hdr:=null;
2415: oe_order_pub.g_line:=null;
2416: /*4163551*/
2417:
2418: --copy_fields_to_globals;
2419: g_related_item_id := in_related_item_id;