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_OE_PRICING_AVAILABILITY dependencies on OE_ORDER_PUB

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

2280: ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE||
2281: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
2282: END IF;
2283:
2284: oe_order_pub.g_line.org_id := l_org_id;
2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;

Line 2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;

2281: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
2282: END IF;
2283:
2284: oe_order_pub.g_line.org_id := l_org_id;
2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;

Line 2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;

2282: END IF;
2283:
2284: oe_order_pub.g_line.org_id := l_org_id;
2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;

Line 2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;

2283:
2284: oe_order_pub.g_line.org_id := l_org_id;
2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;

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

2284: oe_order_pub.g_line.org_id := l_org_id;
2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;

Line 2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;

2285: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;

Line 2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;

2286: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;

Line 2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;

2287: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;

Line 2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;

2288: --oe_order_pub.g_line.ordered_date := g_request_date;
2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;

Line 2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;

2289: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;

Line 2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;

2290: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;

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

2291: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;

Line 2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;

2292: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;

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

2293: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;

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

2294: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;

Line 2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;

2295: --oe_order_pub.g_line.line_id := g_line_id;
2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2303: -- Added for the bug 4150554

Line 2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;

2296: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2303: -- Added for the bug 4150554
2304: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;

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

2297: oe_order_pub.g_line.header_id := g_header_id;
2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2303: -- Added for the bug 4150554
2304: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2305:

Line 2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;

2298: oe_order_pub.g_line.item_type_code := p_item_type_code;
2299: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2303: -- Added for the bug 4150554
2304: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2305:
2306: --BUG#7671483

Line 2304: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;

2300: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2301: oe_order_pub.g_line.price_request_code := p_price_request_code;
2302: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2303: -- Added for the bug 4150554
2304: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2305:
2306: --BUG#7671483
2307: /*The change is done to fetch the Order_category_code based on Order_Type
2308: As Order_Category is directly related to Order_Type so if Order_Type is

Line 2311: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(p_line_index).p_order_type_id;

2307: /*The change is done to fetch the Order_category_code based on Order_Type
2308: As Order_Category is directly related to Order_Type so if Order_Type is
2309: mentioned the corresponding Order_Category should be determined and
2310: interfaced to Pricing*/
2311: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(p_line_index).p_order_type_id;
2312:
2313: oe_debug_pub.add('order_type_id' || oe_order_pub.g_hdr.order_type_id);
2314:
2315: oe_order_pub.g_hdr.order_category_code := OE_Header_Util.Get_Order_Type(g_panda_rec_table(1).p_order_type_id);

Line 2313: oe_debug_pub.add('order_type_id' || oe_order_pub.g_hdr.order_type_id);

2309: mentioned the corresponding Order_Category should be determined and
2310: interfaced to Pricing*/
2311: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(p_line_index).p_order_type_id;
2312:
2313: oe_debug_pub.add('order_type_id' || oe_order_pub.g_hdr.order_type_id);
2314:
2315: oe_order_pub.g_hdr.order_category_code := OE_Header_Util.Get_Order_Type(g_panda_rec_table(1).p_order_type_id);
2316:
2317: oe_debug_pub.add('order_category_code' || oe_order_pub.g_hdr.order_category_code);

Line 2315: oe_order_pub.g_hdr.order_category_code := OE_Header_Util.Get_Order_Type(g_panda_rec_table(1).p_order_type_id);

2311: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(p_line_index).p_order_type_id;
2312:
2313: oe_debug_pub.add('order_type_id' || oe_order_pub.g_hdr.order_type_id);
2314:
2315: oe_order_pub.g_hdr.order_category_code := OE_Header_Util.Get_Order_Type(g_panda_rec_table(1).p_order_type_id);
2316:
2317: oe_debug_pub.add('order_category_code' || oe_order_pub.g_hdr.order_category_code);
2318: oe_debug_pub.add('in line' ||g_panda_rec_table(p_line_index).p_order_type_id );
2319: --BUG#7671483

Line 2317: oe_debug_pub.add('order_category_code' || oe_order_pub.g_hdr.order_category_code);

2313: oe_debug_pub.add('order_type_id' || oe_order_pub.g_hdr.order_type_id);
2314:
2315: oe_order_pub.g_hdr.order_category_code := OE_Header_Util.Get_Order_Type(g_panda_rec_table(1).p_order_type_id);
2316:
2317: oe_debug_pub.add('order_category_code' || oe_order_pub.g_hdr.order_category_code);
2318: oe_debug_pub.add('in line' ||g_panda_rec_table(p_line_index).p_order_type_id );
2319: --BUG#7671483
2320: oe_order_pub.g_hdr.transactional_curr_code:= g_panda_rec_table(p_line_index).p_currency ; --14002299
2321:

Line 2320: oe_order_pub.g_hdr.transactional_curr_code:= g_panda_rec_table(p_line_index).p_currency ; --14002299

2316:
2317: oe_debug_pub.add('order_category_code' || oe_order_pub.g_hdr.order_category_code);
2318: oe_debug_pub.add('in line' ||g_panda_rec_table(p_line_index).p_order_type_id );
2319: --BUG#7671483
2320: oe_order_pub.g_hdr.transactional_curr_code:= g_panda_rec_table(p_line_index).p_currency ; --14002299
2321:
2322: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2323:
2324: SELECT concatenated_segments

Line 2325: INTO oe_order_pub.g_line.ordered_item

2321:
2322: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2323:
2324: SELECT concatenated_segments
2325: INTO oe_order_pub.g_line.ordered_item
2326: FROM mtl_system_items_kfv
2327: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2328: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2329:

Line 2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;

2401: ' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' PRICE REQ CODE='||
2402: P_PRICE_REQUEST_CODE ) ;
2403: END IF;
2404:
2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;

Line 2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;

2402: P_PRICE_REQUEST_CODE ) ;
2403: END IF;
2404:
2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;

Line 2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;

2403: END IF;
2404:
2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

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

2404:
2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;

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

2405: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;

Line 2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;

2406: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;

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

2407: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;

Line 2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;

2408: oe_order_pub.g_hdr.header_id := g_header_id;
2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;

Line 2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;

2409: oe_order_pub.g_hdr.org_id := l_org_id;
2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;

Line 2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;

2410: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

Line 2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;

2411: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

Line 2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;

2412: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;

Line 2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;

2413: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;

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

2414: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;

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

2415: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2423:

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

2416: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2423:
2424:

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

2417: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2423:
2424:
2425:

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

2418: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2419: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2420: --oe_order_pub.g_line.line_id := g_line_id;
2421: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2423:
2424:
2425:
2426: QP_ATTR_Mapping_PUB.Build_Contexts(

Line 4165: OE_ORDER_PUB.G_HDR:=NULL;

4161: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
4162: END IF;
4163:
4164:
4165: OE_ORDER_PUB.G_HDR:=NULL;
4166: OE_ORDER_PUB.G_LINE:=NULL;
4167:
4168: IF l_debug_level > 0 THEN
4169: print_time('Before Calling Copy Header to Request');

Line 4166: OE_ORDER_PUB.G_LINE:=NULL;

4162: END IF;
4163:
4164:
4165: OE_ORDER_PUB.G_HDR:=NULL;
4166: OE_ORDER_PUB.G_LINE:=NULL;
4167:
4168: IF l_debug_level > 0 THEN
4169: print_time('Before Calling Copy Header to Request');
4170: END IF;

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

5135:
5136: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5137: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5138:
5139: If OE_Order_PUB.G_Line.agreement_id is not null and
5140: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5141: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5142: Else
5143: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';

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

5136: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5137: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5138:
5139: If OE_Order_PUB.G_Line.agreement_id is not null and
5140: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5141: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5142: Else
5143: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
5144: End If;

Line 7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,

7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,

Line 7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,

7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,

Line 7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,

7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,

Line 7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,

7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,

Line 7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,

7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,

Line 7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,

7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)

Line 7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,

7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7174: IS

Line 7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,

7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7174: IS
7175: j Number;

Line 7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,

7168: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7174: IS
7175: j Number;
7176: Begin

Line 7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)

7169: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7170: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7171: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7172: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7173: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7174: IS
7175: j Number;
7176: Begin
7177:

Line 7182: x_header_rec:=OE_Order_PUB.G_MISS_HEADER_REC;

7178:
7179:
7180: IF p_header_rec.EXISTS(1) Then
7181: --copy header info
7182: x_header_rec:=OE_Order_PUB.G_MISS_HEADER_REC;
7183:
7184: IF p_header_rec(1).sold_to_org_id is not null then
7185: x_header_rec.sold_to_org_id :=p_header_rec(1).sold_to_org_id;
7186: END IF;

Line 7254: x_header_adj_tbl(j):= Oe_Order_Pub.G_Miss_Header_Adj_rec;

7250: for i in p_Header_Adj_tbl.first..p_Header_Adj_tbl.last
7251: Loop
7252: If p_Header_Adj_tbl.Exists(i) Then
7253: j:=j+1;
7254: x_header_adj_tbl(j):= Oe_Order_Pub.G_Miss_Header_Adj_rec;
7255:
7256: if p_header_adj_tbl(i).list_header_id is not null then
7257: x_header_adj_tbl(j).list_header_id:= p_header_adj_tbl(i).list_header_id;
7258: end if;

Line 7304: x_header_price_att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;

7300: for i in p_header_price_att_tbl.first..p_header_price_att_tbl.last
7301: Loop
7302: if p_header_price_att_tbl.Exists(i) then
7303: j:=j+1;
7304: x_header_price_att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
7305:
7306: if p_header_price_att_tbl(i).flex_title is not null then
7307: x_header_price_att_tbl(j).flex_title := p_header_price_att_tbl(i).flex_title;
7308: end if;

Line 7334: x_Header_Adj_Att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_REC;

7330: For i in p_Header_Adj_Att_tbl.first..p_Header_Adj_Att_tbl.last
7331: Loop
7332: If p_Header_Adj_Att_tbl.Exists(i) Then
7333: j:=j+1;
7334: x_Header_Adj_Att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_REC;
7335:
7336: End if;
7337: End Loop;
7338: End if;

Line 7348: x_Header_Adj_Assoc_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_REC;

7344: For i in p_Header_Adj_Assoc_tbl.first..p_Header_Adj_Assoc_tbl.last
7345: Loop
7346: If p_Header_Adj_Assoc_tbl.Exists(i) Then
7347: j:=j+1;
7348: x_Header_Adj_Assoc_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_REC;
7349:
7350: End if;
7351: End loop;
7352: End if;

Line 7362: x_line_Tbl(j):=OE_ORDER_PUB.G_MISS_LINE_REC;

7358: For i in p_line_Tbl.first..p_line_Tbl.last
7359: Loop
7360: j:=j+1;
7361: if p_line_Tbl.Exists(i) Then
7362: x_line_Tbl(j):=OE_ORDER_PUB.G_MISS_LINE_REC;
7363:
7364: if p_line_Tbl(i).agreement_id is not null then
7365: x_line_Tbl(j).agreement_id := p_line_Tbl(i).agreement_id;
7366: end if;

Line 7470: x_line_Adj_tbl(j):=OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;

7466: For i in p_line_Adj_tbl.first..p_line_Adj_tbl.last
7467: Loop
7468: If p_line_Adj_tbl.Exists(i) then
7469: j:=j+1;
7470: x_line_Adj_tbl(j):=OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
7471:
7472: if p_line_Adj_tbl(i).line_index is not null then
7473:
7474: --commented for bug 3566972

Line 7537: x_line_price_Att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Price_Att_Rec;

7533: For i in p_line_price_Att_tbl.first..p_line_price_Att_tbl.last
7534: Loop
7535: if p_line_price_Att_tbl.Exists(i) then
7536: j:=j+1;
7537: x_line_price_Att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Price_Att_Rec;
7538:
7539: if p_line_price_Att_tbl(i).line_index is not null then
7540: x_line_price_Att_tbl(j).line_index := p_line_price_Att_tbl(i).line_index;
7541: end if;

Line 7573: x_line_Adj_att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Adj_Att_Rec;

7569: For i in p_line_Adj_Att_tbl.first..p_line_Adj_Att_tbl.last
7570: Loop
7571: if p_line_Adj_Att_tbl.Exists(i) Then
7572: j:=j+1;
7573: x_line_Adj_att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Adj_Att_Rec;
7574: if p_line_Adj_att_tbl(i).Adj_index is not null then
7575: x_line_Adj_att_tbl(j).Adj_index := p_line_Adj_att_tbl(i).Adj_index;
7576: end if;
7577: if p_line_Adj_att_tbl(i).flex_title is not null then

Line 7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

7650: x_msg_data OUT NOCOPY VARCHAR2,
7651: x_return_status OUT NOCOPY VARCHAR2
7652: ) IS
7653:
7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

7651: x_return_status OUT NOCOPY VARCHAR2
7652: ) IS
7653:
7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

7652: ) IS
7653:
7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

7653:
7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

7654: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

7655: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 7660: l_line_rec OE_Order_PUB.Line_Rec_Type;

7656: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

7657: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7658: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

7659: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

7660: l_line_rec OE_Order_PUB.Line_Rec_Type;
7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

7661: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

7662: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

7663: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

7664: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

7665: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

7666: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7674: l_file_val Varchar2(30);

Line 7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;

7667: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7674: l_file_val Varchar2(30);
7675: x_msg_index number;

Line 7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

7668: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7674: l_file_val Varchar2(30);
7675: x_msg_index number;
7676: v Varchar2(30);

Line 7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

7669: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7670: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7671: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7672: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7673: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7674: l_file_val Varchar2(30);
7675: x_msg_index number;
7676: v Varchar2(30);
7677: l_date date;

Line 7680: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

7676: v Varchar2(30);
7677: l_date date;
7678: l_booked_flag varchar2(1);
7679: l_shipping_interfaced_flag varchar2(1);
7680: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
7681: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7682:
7683: l_subtotal number;
7684: l_discount number;

Line 7688: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

7684: l_discount number;
7685: l_charges number;
7686: l_tax number;
7687: l_transaction_phase_code varchar2(30);
7688: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7689: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7690: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7691: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7692: BEGIN

Line 7689: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

7685: l_charges number;
7686: l_tax number;
7687: l_transaction_phase_code varchar2(30);
7688: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7689: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7690: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7691: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7692: BEGIN
7693:

Line 7690: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

7686: l_tax number;
7687: l_transaction_phase_code varchar2(30);
7688: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7689: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7690: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7691: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7692: BEGIN
7693:
7694: IF l_debug_level > 0 THEN

Line 7691: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

7687: l_transaction_phase_code varchar2(30);
7688: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7689: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7690: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7691: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7692: BEGIN
7693:
7694: IF l_debug_level > 0 THEN
7695: oe_debug_pub.add('==========================================='||

Line 8094: p_old_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;

8090: OE_GLOBALS.g_validate_desc_flex:='N';
8091: END IF;
8092: END IF;
8093: IF OE_GLOBALS.g_validate_desc_flex='Y' THEN
8094: p_old_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
8095: FOR i in l_line_tbl.FIRST..l_line_tbl.LAST
8096: LOOP
8097: p_x_line_rec:=l_line_tbl(i);
8098: G_PR_AV:='Y' ; -- bug7380336

Line 8516: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC

8512: END GET_MRP_ERR_MSG;
8513:
8514: /* start bug 3440778 , Created to convert the reference to other products serverside code inside OEXPRAVA pld into a local call. to OE_OE_PRICING_AVAILABILITY package*/
8515:
8516: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8517: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8518: ,p_order_currency IN VARCHAR2 Default NULL
8519: ,p_sob_currency IN VARCHAR2 Default NULL
8520: ,p_inventory_item_id IN NUMBER Default NULL

Line 8517: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC

8513:
8514: /* start bug 3440778 , Created to convert the reference to other products serverside code inside OEXPRAVA pld into a local call. to OE_OE_PRICING_AVAILABILITY package*/
8515:
8516: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8517: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8518: ,p_order_currency IN VARCHAR2 Default NULL
8519: ,p_sob_currency IN VARCHAR2 Default NULL
8520: ,p_inventory_item_id IN NUMBER Default NULL
8521: ,p_ship_from_org_id IN NUMBER Default NULL