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 2274: oe_order_pub.g_line.org_id := l_org_id;

2270: ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE||
2271: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
2272: END IF;
2273:
2274: oe_order_pub.g_line.org_id := l_org_id;
2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;

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

2271: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
2272: END IF;
2273:
2274: oe_order_pub.g_line.org_id := l_org_id;
2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;

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

2272: END IF;
2273:
2274: oe_order_pub.g_line.org_id := l_org_id;
2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;

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

2273:
2274: oe_order_pub.g_line.org_id := l_org_id;
2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;

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

2274: oe_order_pub.g_line.org_id := l_org_id;
2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;

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

2275: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;

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

2276: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;

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

2277: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;

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

2278: --oe_order_pub.g_line.ordered_date := g_request_date;
2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;

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

2279: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;

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

2280: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;

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

2281: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;

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

2282: oe_order_pub.g_line.line_type_id := g_panda_rec_table(p_line_index).p_line_type_id;
2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;

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

2283: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type;
2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;

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

2284: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id;
2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;

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

2285: --oe_order_pub.g_line.line_id := g_line_id;
2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2293: -- Added for the bug 4150554

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

2286: oe_order_pub.g_line.line_id := g_panda_rec_table(p_line_index).p_line_id;
2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2293: -- Added for the bug 4150554
2294: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;

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

2287: oe_order_pub.g_line.header_id := g_header_id;
2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2293: -- Added for the bug 4150554
2294: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2295:

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

2288: oe_order_pub.g_line.item_type_code := p_item_type_code;
2289: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2293: -- Added for the bug 4150554
2294: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2295:
2296:

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

2290: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
2291: oe_order_pub.g_line.price_request_code := p_price_request_code;
2292: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
2293: -- Added for the bug 4150554
2294: oe_order_pub.g_line.ship_from_org_id := g_panda_rec_table(p_line_index).p_ship_from_org_id;
2295:
2296:
2297: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2298:

Line 2300: INTO oe_order_pub.g_line.ordered_item

2296:
2297: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2298:
2299: SELECT concatenated_segments
2300: INTO oe_order_pub.g_line.ordered_item
2301: FROM mtl_system_items_kfv
2302: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2303: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2304:

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

2376: ' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' PRICE REQ CODE='||
2377: P_PRICE_REQUEST_CODE ) ;
2378: END IF;
2379:
2380: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;

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

2377: P_PRICE_REQUEST_CODE ) ;
2378: END IF;
2379:
2380: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;

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

2378: END IF;
2379:
2380: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

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

2379:
2380: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;

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

2380: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;

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

2381: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;

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

2382: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;

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

2383: oe_order_pub.g_hdr.header_id := g_header_id;
2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;

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

2384: oe_order_pub.g_hdr.org_id := l_org_id;
2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;

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

2385: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

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

2386: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

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

2387: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;

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

2388: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;

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

2389: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;

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

2390: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2398:

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

2391: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2398:
2399:

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

2392: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2398:
2399:
2400:

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

2393: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
2394: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
2395: --oe_order_pub.g_line.line_id := g_line_id;
2396: --oe_order_pub.g_line.item_type_code := p_item_type_code;
2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2398:
2399:
2400:
2401: QP_ATTR_Mapping_PUB.Build_Contexts(

Line 4140: OE_ORDER_PUB.G_HDR:=NULL;

4136: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
4137: END IF;
4138:
4139:
4140: OE_ORDER_PUB.G_HDR:=NULL;
4141: OE_ORDER_PUB.G_LINE:=NULL;
4142:
4143: IF l_debug_level > 0 THEN
4144: print_time('Before Calling Copy Header to Request');

Line 4141: OE_ORDER_PUB.G_LINE:=NULL;

4137: END IF;
4138:
4139:
4140: OE_ORDER_PUB.G_HDR:=NULL;
4141: OE_ORDER_PUB.G_LINE:=NULL;
4142:
4143: IF l_debug_level > 0 THEN
4144: print_time('Before Calling Copy Header to Request');
4145: END IF;

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

5110:
5111: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5112: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5113:
5114: If OE_Order_PUB.G_Line.agreement_id is not null and
5115: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5116: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5117: Else
5118: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';

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

5111: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5112: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5113:
5114: If OE_Order_PUB.G_Line.agreement_id is not null and
5115: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5116: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5117: Else
5118: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
5119: End If;

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

7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,

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

7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,

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

7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,

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

7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,

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

7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,

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

7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7148: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)

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

7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7148: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7149: IS

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

7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,
7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7148: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7149: IS
7150: j Number;

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

7143: x_Header_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Price_Att_Tbl_Type,
7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7148: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7149: IS
7150: j Number;
7151: Begin

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

7144: x_Header_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Att_Tbl_Type,
7145: x_Header_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type,
7146: x_Line_price_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Price_Att_Tbl_Type,
7147: x_Line_Adj_Att_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Att_Tbl_Type,
7148: x_Line_Adj_Assoc_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type)
7149: IS
7150: j Number;
7151: Begin
7152:

Line 7157: x_header_rec:=OE_Order_PUB.G_MISS_HEADER_REC;

7153:
7154:
7155: IF p_header_rec.EXISTS(1) Then
7156: --copy header info
7157: x_header_rec:=OE_Order_PUB.G_MISS_HEADER_REC;
7158:
7159: IF p_header_rec(1).sold_to_org_id is not null then
7160: x_header_rec.sold_to_org_id :=p_header_rec(1).sold_to_org_id;
7161: END IF;

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

7225: for i in p_Header_Adj_tbl.first..p_Header_Adj_tbl.last
7226: Loop
7227: If p_Header_Adj_tbl.Exists(i) Then
7228: j:=j+1;
7229: x_header_adj_tbl(j):= Oe_Order_Pub.G_Miss_Header_Adj_rec;
7230:
7231: if p_header_adj_tbl(i).list_header_id is not null then
7232: x_header_adj_tbl(j).list_header_id:= p_header_adj_tbl(i).list_header_id;
7233: end if;

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

7275: for i in p_header_price_att_tbl.first..p_header_price_att_tbl.last
7276: Loop
7277: if p_header_price_att_tbl.Exists(i) then
7278: j:=j+1;
7279: x_header_price_att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
7280:
7281: if p_header_price_att_tbl(i).flex_title is not null then
7282: x_header_price_att_tbl(j).flex_title := p_header_price_att_tbl(i).flex_title;
7283: end if;

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

7305: For i in p_Header_Adj_Att_tbl.first..p_Header_Adj_Att_tbl.last
7306: Loop
7307: If p_Header_Adj_Att_tbl.Exists(i) Then
7308: j:=j+1;
7309: x_Header_Adj_Att_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_REC;
7310:
7311: End if;
7312: End Loop;
7313: End if;

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

7319: For i in p_Header_Adj_Assoc_tbl.first..p_Header_Adj_Assoc_tbl.last
7320: Loop
7321: If p_Header_Adj_Assoc_tbl.Exists(i) Then
7322: j:=j+1;
7323: x_Header_Adj_Assoc_tbl(j):=OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_REC;
7324:
7325: End if;
7326: End loop;
7327: End if;

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

7333: For i in p_line_Tbl.first..p_line_Tbl.last
7334: Loop
7335: j:=j+1;
7336: if p_line_Tbl.Exists(i) Then
7337: x_line_Tbl(j):=OE_ORDER_PUB.G_MISS_LINE_REC;
7338:
7339: if p_line_Tbl(i).agreement_id is not null then
7340: x_line_Tbl(j).agreement_id := p_line_Tbl(i).agreement_id;
7341: end if;

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

7441: For i in p_line_Adj_tbl.first..p_line_Adj_tbl.last
7442: Loop
7443: If p_line_Adj_tbl.Exists(i) then
7444: j:=j+1;
7445: x_line_Adj_tbl(j):=OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
7446:
7447: if p_line_Adj_tbl(i).line_index is not null then
7448:
7449: --commented for bug 3566972

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

7508: For i in p_line_price_Att_tbl.first..p_line_price_Att_tbl.last
7509: Loop
7510: if p_line_price_Att_tbl.Exists(i) then
7511: j:=j+1;
7512: x_line_price_Att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Price_Att_Rec;
7513:
7514: if p_line_price_Att_tbl(i).line_index is not null then
7515: x_line_price_Att_tbl(j).line_index := p_line_price_Att_tbl(i).line_index;
7516: end if;

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

7544: For i in p_line_Adj_Att_tbl.first..p_line_Adj_Att_tbl.last
7545: Loop
7546: if p_line_Adj_Att_tbl.Exists(i) Then
7547: j:=j+1;
7548: x_line_Adj_att_tbl(j):= OE_ORDER_PUB.G_MISS_Line_Adj_Att_Rec;
7549: if p_line_Adj_att_tbl(i).Adj_index is not null then
7550: x_line_Adj_att_tbl(j).Adj_index := p_line_Adj_att_tbl(i).Adj_index;
7551: end if;
7552: if p_line_Adj_att_tbl(i).flex_title is not null then

Line 7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

7625: x_msg_data OUT NOCOPY VARCHAR2,
7626: x_return_status OUT NOCOPY VARCHAR2
7627: ) IS
7628:
7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

7626: x_return_status OUT NOCOPY VARCHAR2
7627: ) IS
7628:
7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

7627: ) IS
7628:
7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

7628:
7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

7629: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

7630: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 7635: l_line_rec OE_Order_PUB.Line_Rec_Type;

7631: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

7632: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7633: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

7634: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

7635: l_line_rec OE_Order_PUB.Line_Rec_Type;
7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

7636: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

7637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

7638: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

7639: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

7640: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

7641: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7649: l_file_val Varchar2(30);

Line 7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;

7642: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7649: l_file_val Varchar2(30);
7650: x_msg_index number;

Line 7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

7643: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7649: l_file_val Varchar2(30);
7650: x_msg_index number;
7651: v Varchar2(30);

Line 7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

7644: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
7645: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
7646: l_action_request_tbl OE_Order_PUB.request_tbl_type;
7647: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
7648: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
7649: l_file_val Varchar2(30);
7650: x_msg_index number;
7651: v Varchar2(30);
7652: l_date date;

Line 7655: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

7651: v Varchar2(30);
7652: l_date date;
7653: l_booked_flag varchar2(1);
7654: l_shipping_interfaced_flag varchar2(1);
7655: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
7656: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7657:
7658: l_subtotal number;
7659: l_discount number;

Line 7663: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

7659: l_discount number;
7660: l_charges number;
7661: l_tax number;
7662: l_transaction_phase_code varchar2(30);
7663: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7664: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7665: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7666: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7667: BEGIN

Line 7664: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

7660: l_charges number;
7661: l_tax number;
7662: l_transaction_phase_code varchar2(30);
7663: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7664: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7665: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7666: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7667: BEGIN
7668:

Line 7665: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

7661: l_tax number;
7662: l_transaction_phase_code varchar2(30);
7663: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7664: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7665: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7666: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7667: BEGIN
7668:
7669: IF l_debug_level > 0 THEN

Line 7666: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

7662: l_transaction_phase_code varchar2(30);
7663: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
7664: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
7665: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
7666: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
7667: BEGIN
7668:
7669: IF l_debug_level > 0 THEN
7670: oe_debug_pub.add('==========================================='||

Line 8069: p_old_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;

8065: OE_GLOBALS.g_validate_desc_flex:='N';
8066: END IF;
8067: END IF;
8068: IF OE_GLOBALS.g_validate_desc_flex='Y' THEN
8069: p_old_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
8070: FOR i in l_line_tbl.FIRST..l_line_tbl.LAST
8071: LOOP
8072: p_x_line_rec:=l_line_tbl(i);
8073: G_PR_AV:='Y' ; -- bug7380336

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

8487: END GET_MRP_ERR_MSG;
8488:
8489: /* 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*/
8490:
8491: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8492: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8493: ,p_order_currency IN VARCHAR2 Default NULL
8494: ,p_sob_currency IN VARCHAR2 Default NULL
8495: ,p_inventory_item_id IN NUMBER Default NULL

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

8488:
8489: /* 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*/
8490:
8491: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8492: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8493: ,p_order_currency IN VARCHAR2 Default NULL
8494: ,p_sob_currency IN VARCHAR2 Default NULL
8495: ,p_inventory_item_id IN NUMBER Default NULL
8496: ,p_ship_from_org_id IN NUMBER Default NULL