APPS.OE_OE_AVAILABILITY dependencies on OE_ORDER_PUB

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

1588: ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE||
1589: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
1590: END IF;
1591:
1592: oe_order_pub.g_line.org_id := l_org_id;
1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;

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

1589: ' UOM='||G_panda_rec_table(p_line_index).p_UOM ) ;
1590: END IF;
1591:
1592: oe_order_pub.g_line.org_id := l_org_id;
1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;

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

1590: END IF;
1591:
1592: oe_order_pub.g_line.org_id := l_org_id;
1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;

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

1591:
1592: oe_order_pub.g_line.org_id := l_org_id;
1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;

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

1592: oe_order_pub.g_line.org_id := l_org_id;
1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905

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

1593: oe_order_pub.g_line.pricing_date := g_panda_rec_table(p_line_index).p_pricing_date;
1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905

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

1594: oe_order_pub.g_line.inventory_item_id := g_panda_rec_table(p_line_index).p_inventory_item_id;
1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;

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

1595: oe_order_pub.g_line.agreement_id := g_panda_rec_table(p_line_index).p_agreement_id;
1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;

Line 1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905

1596: --oe_order_pub.g_line.ordered_date := g_request_date;
1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;

Line 1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905

1597: oe_order_pub.g_line.ship_to_org_id := g_panda_rec_table(p_line_index).p_ship_to_org_id;
1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;

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

1598: oe_order_pub.g_line.invoice_to_org_id := g_panda_rec_table(p_line_index).p_invoice_to_org_id;
1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;

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

1599: oe_order_pub.g_line.ordered_quantity := g_panda_rec_table(p_line_index).p_qty;
1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;

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

1600: oe_order_pub.g_line.item_identifier_type := g_panda_rec_table(p_line_index).p_item_identifier_type; -- 3661905
1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;

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

1601: oe_order_pub.g_line.ordered_item_id := g_panda_rec_table(p_line_index).p_ordered_item_id; -- 3661905
1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
1609:

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

1602: oe_order_pub.g_line.line_id := g_line_id;
1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
1609:
1610: --Bug 6697648/6759791 --copy header level attribute, Index should be 1(for header) and NOT p_line_index

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

1603: oe_order_pub.g_line.header_id := g_header_id;
1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
1609:
1610: --Bug 6697648/6759791 --copy header level attribute, Index should be 1(for header) and NOT p_line_index
1611: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;

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

1604: oe_order_pub.g_line.item_type_code := p_item_type_code;
1605: oe_order_pub.g_line.price_list_id := g_panda_rec_table(p_line_index).p_price_list_id;
1606: oe_order_pub.g_line.sold_to_org_id := g_panda_rec_table(p_line_index).p_customer_id;
1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
1609:
1610: --Bug 6697648/6759791 --copy header level attribute, Index should be 1(for header) and NOT p_line_index
1611: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1612:

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

1607: oe_order_pub.g_line.price_request_code := p_price_request_code;
1608: oe_order_pub.g_line.order_quantity_uom := g_panda_rec_table(p_line_index).p_uom;
1609:
1610: --Bug 6697648/6759791 --copy header level attribute, Index should be 1(for header) and NOT p_line_index
1611: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1612:
1613: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
1614:
1615: SELECT concatenated_segments

Line 1616: INTO oe_order_pub.g_line.ordered_item

1612:
1613: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
1614:
1615: SELECT concatenated_segments
1616: INTO oe_order_pub.g_line.ordered_item
1617: FROM mtl_system_items_kfv
1618: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
1619: AND organization_id = l_master_org_id;
1620:

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

1696: ' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' PRICE REQ CODE='||
1697: P_PRICE_REQUEST_CODE ) ;
1698: END IF;
1699:
1700: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;

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

1697: P_PRICE_REQUEST_CODE ) ;
1698: END IF;
1699:
1700: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;

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

1698: END IF;
1699:
1700: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;

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

1699:
1700: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;

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

1700: oe_order_pub.g_hdr.agreement_id := g_panda_rec_table(1).p_agreement_id;
1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;

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

1701: oe_order_pub.g_hdr.invoice_to_org_id := g_panda_rec_table(1).p_invoice_to_org_id;
1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;

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

1702: oe_order_pub.g_hdr.ordered_date := g_panda_rec_table(1).p_request_date;
1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;

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

1703: oe_order_pub.g_hdr.header_id := g_header_id;
1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;

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

1704: oe_order_pub.g_hdr.org_id := l_org_id;
1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;

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

1705: oe_order_pub.g_hdr.price_list_id := g_panda_rec_table(1).p_price_list_id;
1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;

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

1706: oe_order_pub.g_hdr.price_request_code := p_price_request_code;
1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;

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

1707: oe_order_pub.g_hdr.pricing_date := g_panda_rec_table(1).p_pricing_date;
1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;

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

1708: oe_order_pub.g_hdr.request_date := g_panda_rec_table(1).p_request_date;
1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;

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

1709: oe_order_pub.g_hdr.ship_to_org_id := g_panda_rec_table(1).p_ship_to_org_id;
1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1717: --oe_order_pub.g_line.order_quantity_uom := p_uom;

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

1710: oe_order_pub.g_hdr.sold_to_org_id := g_panda_rec_table(1).p_customer_id;
1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1717: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1718:

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

1711: oe_order_pub.g_hdr.order_type_id := g_panda_rec_table(1).p_order_type_id;
1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1717: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1718:
1719:

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

1712: oe_order_pub.g_hdr.ship_from_org_id := g_panda_rec_table(1).p_ship_from_org_id;
1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1717: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1718:
1719:
1720: /*If p_item_identifier_type ='INT' then

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

1713: --oe_order_pub.g_line.inventory_item_id := p_inventory_item_id;
1714: --oe_order_pub.g_line.ordered_quantity := p_ordered_quantity;
1715: --oe_order_pub.g_line.line_id := g_line_id;
1716: --oe_order_pub.g_line.item_type_code := p_item_type_code;
1717: --oe_order_pub.g_line.order_quantity_uom := p_uom;
1718:
1719:
1720: /*If p_item_identifier_type ='INT' then
1721:

Line 1723: INTO oe_order_pub.g_line.ordered_item

1719:
1720: /*If p_item_identifier_type ='INT' then
1721:
1722: SELECT concatenated_segments
1723: INTO oe_order_pub.g_line.ordered_item
1724: FROM mtl_system_items_kfv
1725: WHERE inventory_item_id = g_inventory_item_id
1726: AND organization_id = l_org_id;
1727:

Line 3368: OE_ORDER_PUB.G_HDR:=NULL;

3364: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
3365: END IF;
3366:
3367:
3368: OE_ORDER_PUB.G_HDR:=NULL;
3369: OE_ORDER_PUB.G_LINE:=NULL;
3370:
3371: copy_Header_to_request(
3372: p_request_type_code => 'ONT'

Line 3369: OE_ORDER_PUB.G_LINE:=NULL;

3365: END IF;
3366:
3367:
3368: OE_ORDER_PUB.G_HDR:=NULL;
3369: OE_ORDER_PUB.G_LINE:=NULL;
3370:
3371: copy_Header_to_request(
3372: p_request_type_code => 'ONT'
3373: ,p_calculate_price_flag => 'Y'

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

3741:
3742: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
3743: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
3744:
3745: If OE_Order_PUB.G_Line.agreement_id is not null and
3746: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
3747: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
3748: Else
3749: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';

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

3742: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
3743: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
3744:
3745: If OE_Order_PUB.G_Line.agreement_id is not null and
3746: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
3747: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
3748: Else
3749: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
3750: End If;