3503: IF G_PRICE_REQUEST_CODE_TBL.EXISTS(1) THEN G_PRICE_REQUEST_CODE_TBL.DELETE; END IF;
3504: IF G_USAGE_PRICING_TYPE_TBL.EXISTS(1) THEN G_USAGE_PRICING_TYPE_TBL.DELETE; END IF;
3505:
3506: --build header
3507: oe_order_pub.g_hdr.header_id := l_uniqueHeaderIdtbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3504: IF G_USAGE_PRICING_TYPE_TBL.EXISTS(1) THEN G_USAGE_PRICING_TYPE_TBL.DELETE; END IF;
3505:
3506: --build header
3507: oe_order_pub.g_hdr.header_id := l_uniqueHeaderIdtbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3505:
3506: --build header
3507: oe_order_pub.g_hdr.header_id := l_uniqueHeaderIdtbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3506: --build header
3507: oe_order_pub.g_hdr.header_id := l_uniqueHeaderIdtbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3507: oe_order_pub.g_hdr.header_id := l_uniqueHeaderIdtbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3508: oe_order_pub.g_hdr.order_type_id := l_orderTypeIdTbl(P);
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3509: oe_order_pub.g_hdr.sold_to_org_id := l_hdrSoldToOrgIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3510: oe_order_pub.g_hdr.invoice_to_org_id := l_hdrInvoiceToOrgIdTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3511: oe_order_pub.g_hdr.ship_to_org_id := l_hdrShipToOrgIdTbl(P);
3512: oe_order_pub.g_hdr.price_list_id := l_hdrPriceListIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3513: oe_order_pub.g_hdr.ordered_date := l_hdrOrderedDateTbl(P); --check if ordered_date exists in oe header table
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3514: oe_order_pub.g_hdr.request_date := l_hdrRequestDateTbl(P); --check if ordered_date exists in oe header table
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3515: oe_order_pub.g_hdr.pricing_date := l_hdrPricingDateTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3516:
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3517: oe_order_pub.g_hdr.agreement_id := l_hdrAgreementIdTbl(P);
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3518: oe_order_pub.g_hdr.cust_po_number := l_hdrCustPONumberTbl(P);
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3519: oe_order_pub.g_hdr.ship_from_org_id := l_hdrShipFromOrgIdTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3520: oe_order_pub.g_hdr.order_category_code := l_hdrOrderCategoryCodeTbl(P);
3521: oe_order_pub.g_hdr.shipment_priority_code := l_hdrShipmentPriorityCodeTbl(P);
3522: oe_order_pub.g_hdr.freight_terms_code := l_hdrFreightTermsCodeTbl(P);
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3528: -- end of fix for bug 13579540
3523: oe_order_pub.g_hdr.payment_term_id := l_hdrPaymentTermIdTbl(P);
3524: oe_order_pub.g_hdr.shipping_method_code := l_hdrShippingMethodCodeTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3528: -- end of fix for bug 13579540
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3525: -- fix for bug 13579540 l_hdrShippingMethodCodeTbl (varchar2(30) was being assigned
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3528: -- end of fix for bug 13579540
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3526: -- to transactional_curr_code varchar2(15) causing ORA-06502: PL/SQL: numeric or value error
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3528: -- end of fix for bug 13579540
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3534: oe_order_pub.g_hdr.BLANKET_NUMBER := l_hdrBlanketNumberTbl(P);
3527: oe_order_pub.g_hdr.transactional_curr_code := l_orderCurrTbl(P);
3528: -- end of fix for bug 13579540
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3534: oe_order_pub.g_hdr.BLANKET_NUMBER := l_hdrBlanketNumberTbl(P);
3535:
3528: -- end of fix for bug 13579540
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3534: oe_order_pub.g_hdr.BLANKET_NUMBER := l_hdrBlanketNumberTbl(P);
3535:
3536: G_LINE_INDEX_TBL(l_tbl_index) := l_tbl_index;
3529: oe_order_pub.g_hdr.org_id := l_hdrOrgIdTbl(P);
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3534: oe_order_pub.g_hdr.BLANKET_NUMBER := l_hdrBlanketNumberTbl(P);
3535:
3536: G_LINE_INDEX_TBL(l_tbl_index) := l_tbl_index;
3537: G_LINE_TYPE_CODE_TBL(l_tbl_index):= OZF_ORDER_PRICE_PVT.G_ORDER_HEADER_TYPE;
3530: oe_order_pub.g_hdr.conversion_rate_date := l_hdrConversionRateDateTbl(P);
3531: oe_order_pub.g_hdr.conversion_rate := l_hdrConversionRateTbl(P);
3532: oe_order_pub.g_hdr.conversion_type_code := l_hdrConversionTypeCodeTbl(P);
3533: oe_order_pub.g_hdr.minisite_id := l_hdrMinisiteIdTbl(P);
3534: oe_order_pub.g_hdr.BLANKET_NUMBER := l_hdrBlanketNumberTbl(P);
3535:
3536: G_LINE_INDEX_TBL(l_tbl_index) := l_tbl_index;
3537: G_LINE_TYPE_CODE_TBL(l_tbl_index):= OZF_ORDER_PRICE_PVT.G_ORDER_HEADER_TYPE;
3538: G_PRICING_EFFECTIVE_DATE_TBL(l_tbl_index):= l_hdrPricingDateTbl(P);
3615: IF g_debug_flag = 'Y' THEN
3616: write_conc_log( 'l_lineCounter' || l_lineCounter);
3617: END IF;
3618:
3619: oe_order_pub.g_line.line_id := l_lineIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3616: write_conc_log( 'l_lineCounter' || l_lineCounter);
3617: END IF;
3618:
3619: oe_order_pub.g_line.line_id := l_lineIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3617: END IF;
3618:
3619: oe_order_pub.g_line.line_id := l_lineIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3618:
3619: oe_order_pub.g_line.line_id := l_lineIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3619: oe_order_pub.g_line.line_id := l_lineIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3620: oe_order_pub.g_line.line_type_id := l_lineTypeIdTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3621: oe_order_pub.g_line.inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3622: oe_order_pub.g_line.ordered_quantity := l_quantityTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3623: oe_order_pub.g_line.order_quantity_uom := l_orderUomTbl(l_lineCounter);
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3624: oe_order_pub.g_line.invoice_to_org_id := l_invoiceToOrgIdTbl(l_lineCounter);
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3632:
3625: oe_order_pub.g_line.ship_to_org_id := l_shipToOrgIdTbl(l_lineCounter);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3626: oe_order_pub.g_line.sold_to_org_id := l_soldToOrgIdTbl(l_lineCounter);
3627: oe_order_pub.g_line.price_list_id := l_priceListIdTbl(l_lineCounter);
3628: oe_order_pub.g_line.request_date := l_requestDateTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3629: oe_order_pub.g_line.actual_shipment_date := l_actualShipDateTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3630: oe_order_pub.g_line.pricing_date := l_pricingDateTbl(l_lineCounter);
3631:
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3631:
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3632:
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3633: oe_order_pub.g_line.header_id := l_uniqueHeaderIdtbl(P);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3634: oe_order_pub.g_line.end_customer_id := l_endCustomerIdTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3635: oe_order_pub.g_line.agreement_id := l_agreementIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3636: oe_order_pub.g_line.cust_po_number := l_custPONumberTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3637: oe_order_pub.g_line.ship_from_org_id := l_shipFromOrgIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3638: oe_order_pub.g_line.line_category_code := l_lineCatCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3639: oe_order_pub.g_line.shipment_priority_code := l_shipmentPriorityCodeTbl (l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3640: oe_order_pub.g_line.shippable_flag := l_shippableFlagTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3641: oe_order_pub.g_line.schedule_ship_date := l_scheduleShipDateTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3642: oe_order_pub.g_line.source_type_code := l_sourceTypeCodeTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3643: oe_order_pub.g_line.org_id := l_orgIdTbl(l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3644: oe_order_pub.g_line.freight_terms_code := l_freightTermsCodeTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3645: oe_order_pub.g_line.payment_term_id := l_paymentTermIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3646: oe_order_pub.g_line.shipping_method_code := l_shippingMethodCodeTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3647: oe_order_pub.g_line.item_identifier_type := l_itemIdentifierTypeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3648: oe_order_pub.g_line.ordered_item_id := l_orderedItemIdTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3656: oe_order_pub.g_line.charge_periodicity_code := l_chargePeriodicityCodeTbl(l_lineCounter);
3649: oe_order_pub.g_line.top_model_line_id := l_topModelLineIdTbl(l_lineCounter);
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3656: oe_order_pub.g_line.charge_periodicity_code := l_chargePeriodicityCodeTbl(l_lineCounter);
3657:
3650: oe_order_pub.g_line.unit_percent_base_price := l_unitPercentBasePriceTbl(l_lineCounter);
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3656: oe_order_pub.g_line.charge_periodicity_code := l_chargePeriodicityCodeTbl(l_lineCounter);
3657:
3658: QP_Attr_Mapping_PUB.Build_Contexts(
3651: oe_order_pub.g_line.preferred_grade := l_preferredGradeTbl (l_lineCounter);
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3656: oe_order_pub.g_line.charge_periodicity_code := l_chargePeriodicityCodeTbl(l_lineCounter);
3657:
3658: QP_Attr_Mapping_PUB.Build_Contexts(
3659: p_request_type_code => 'ONT',
3652: oe_order_pub.g_line.Blanket_number := l_blanketNumberTbl(l_lineCounter);
3653: oe_order_pub.g_line.minisite_id := l_minisiteIdTbl(l_lineCounter);
3654: oe_order_pub.g_line.blanket_line_number := l_blanketLineNumberTbl(l_lineCounter);
3655: oe_order_pub.g_line.transaction_phase_code := l_transactionPhaseCodeTbl(l_lineCounter);
3656: oe_order_pub.g_line.charge_periodicity_code := l_chargePeriodicityCodeTbl(l_lineCounter);
3657:
3658: QP_Attr_Mapping_PUB.Build_Contexts(
3659: p_request_type_code => 'ONT',
3660: p_line_index => l_tbl_index,