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 1024: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;

1020: l_control_rec.request_type_code := 'ONT';
1021: l_control_rec.rounding_flag := 'Q';
1022: --For multi_currency price list
1023: l_control_rec.use_multi_currency:='Y';
1024: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
1025: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
1026: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1027: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
1028:

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

1021: l_control_rec.rounding_flag := 'Q';
1022: --For multi_currency price list
1023: l_control_rec.use_multi_currency:='Y';
1024: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
1025: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
1026: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1027: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
1028:
1029: END set_pricing_control_record;

Line 1064: oe_order_pub.g_line.org_id := l_org_id;

1060: IF l_debug_level > 0 THEN
1061: 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 ) ;
1062: END IF;
1063:
1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;

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

1061: 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 ) ;
1062: END IF;
1063:
1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;

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

1062: END IF;
1063:
1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;

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

1063:
1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;

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

1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;

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

1065: oe_order_pub.g_line.pricing_date := g_pricing_date;
1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;

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

1066: oe_order_pub.g_line.inventory_item_id := g_related_item_id;
1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;

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

1067: oe_order_pub.g_line.agreement_id := g_agreement_id;
1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;

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

1068: --oe_order_pub.g_line.ordered_date := g_request_date;
1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;

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

1069: oe_order_pub.g_line.ship_to_org_id := g_ship_to_org_id;
1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;

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

1070: oe_order_pub.g_line.invoice_to_org_id := g_invoice_to_org_id;
1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;
1078: oe_order_pub.g_line.order_quantity_uom := g_uom;

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

1071: oe_order_pub.g_line.ordered_quantity := g_qty;
1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;
1078: oe_order_pub.g_line.order_quantity_uom := g_uom;
1079:

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

1072: oe_order_pub.g_line.line_id := g_line_id;
1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;
1078: oe_order_pub.g_line.order_quantity_uom := g_uom;
1079:
1080:

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

1073: oe_order_pub.g_line.header_id := g_header_id;
1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;
1078: oe_order_pub.g_line.order_quantity_uom := g_uom;
1079:
1080:
1081: IF g_item_identifier_type ='INT' then

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

1074: oe_order_pub.g_line.item_type_code := p_item_type_code;
1075: oe_order_pub.g_line.price_list_id := g_price_list_id;
1076: oe_order_pub.g_line.sold_to_org_id := g_customer_id;
1077: oe_order_pub.g_line.price_request_code := p_price_request_code;
1078: oe_order_pub.g_line.order_quantity_uom := g_uom;
1079:
1080:
1081: IF g_item_identifier_type ='INT' then
1082:

Line 1084: INTO oe_order_pub.g_line.ordered_item

1080:
1081: IF g_item_identifier_type ='INT' then
1082:
1083: SELECT concatenated_segments
1084: INTO oe_order_pub.g_line.ordered_item
1085: FROM mtl_system_items_kfv
1086: WHERE inventory_item_id = g_related_item_id
1087: AND organization_id = l_org_id;
1088:

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

1159:
1160: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1161: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1162:
1163: If OE_Order_PUB.G_Line.agreement_id is not null and
1164: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1165: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1166: Else
1167: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';

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

1160: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1161: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1162:
1163: If OE_Order_PUB.G_Line.agreement_id is not null and
1164: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1165: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1166: Else
1167: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
1168: End If;

Line 1209: l_header_rec OE_ORDER_PUB.header_rec_type;

1205: --
1206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1207: --
1208: /*4163551*/
1209: l_header_rec OE_ORDER_PUB.header_rec_type;
1210: /*4163551*/
1211: BEGIN
1212:
1213: IF l_debug_level > 0 THEN

Line 1241: oe_order_pub.g_hdr:=l_header_rec;

1237: END IF;
1238:
1239: IF l_header_rec.header_id IS NOT NULL AND
1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;

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

1239: IF l_header_rec.header_id IS NOT NULL AND
1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;
1246: /*4163551*/
1247: ELSE

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

1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;
1246: /*4163551*/
1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;

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

1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;
1246: /*4163551*/
1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;

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

1245: END IF;
1246: /*4163551*/
1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;

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

1246: /*4163551*/
1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

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

1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;

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

1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;
1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;

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

1249: oe_order_pub.g_hdr.invoice_to_org_id := g_invoice_to_org_id;
1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;

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

1250: oe_order_pub.g_hdr.ordered_date := g_request_date;
1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;

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

1251: oe_order_pub.g_hdr.header_id := g_header_id;
1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;

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

1252: oe_order_pub.g_hdr.org_id := l_org_id;
1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;

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

1253: oe_order_pub.g_hdr.price_list_id := g_price_list_id;
1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;

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

1254: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

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

1255: oe_order_pub.g_hdr.pricing_date := g_pricing_date;
1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

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

1256: oe_order_pub.g_hdr.request_date := g_request_date;
1257: oe_order_pub.g_hdr.ship_to_org_id := g_ship_to_org_id;
1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;

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

1258: oe_order_pub.g_hdr.sold_to_org_id := g_customer_id;
1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;
1265: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1266: --oe_order_pub.g_line.order_quantity_uom := p_uom;

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

1259: oe_order_pub.g_hdr.order_type_id := g_order_type_id;
1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;
1265: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1266: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1267:

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

1260: oe_order_pub.g_hdr.ship_from_org_id := g_ship_from_org_id;
1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;
1265: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1266: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1267:
1268:

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

1261: END IF;
1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;
1265: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1266: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1267:
1268:
1269: /*If p_item_identifier_type ='INT' then

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

1262: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1263: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1264: --oe_order_pub.g_line.line_id := g_line_id;
1265: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1266: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1267:
1268:
1269: /*If p_item_identifier_type ='INT' then
1270:

Line 1272: INTO oe_order_pub.g_line.ordered_item

1268:
1269: /*If p_item_identifier_type ='INT' then
1270:
1271: SELECT concatenated_segments
1272: INTO oe_order_pub.g_line.ordered_item
1273: FROM mtl_system_items_kfv
1274: WHERE inventory_item_id = g_inventory_item_id
1275: AND organization_id = l_org_id;
1276:

Line 2380: oe_order_pub.g_hdr:=null;

2376: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2377: --
2378: BEGIN
2379: /*4163551*/
2380: oe_order_pub.g_hdr:=null;
2381: oe_order_pub.g_line:=null;
2382: /*4163551*/
2383:
2384: --copy_fields_to_globals;

Line 2381: oe_order_pub.g_line:=null;

2377: --
2378: BEGIN
2379: /*4163551*/
2380: oe_order_pub.g_hdr:=null;
2381: oe_order_pub.g_line:=null;
2382: /*4163551*/
2383:
2384: --copy_fields_to_globals;
2385: g_related_item_id := in_related_item_id;