[Home] [Help]
1336: -- on the dIScount information.
1337: --
1338: -- PARAMETERS
1339: -- p_resale_batch_id IN NUMBER,
1340: -- p_line_tbl IN OZF_ORDER_PRICE_PVT.line_rec_tbl_type,
1341: -- p_inventory_tracking IN VARCHAR2,
1342: -- x_return_status out VARCHAR2
1343: --
1344: -- NOTES
1347: --
1348: ---------------------------------------------------------------------
1349: PROCEDURE Process_Pricing_Result (
1350: p_resale_batch_id IN NUMBER,
1351: p_line_tbl IN OZF_ORDER_PRICE_PVT.line_rec_tbl_type,
1352: p_inventory_tracking IN VARCHAR2,
1353: x_return_status OUT NOCOPY VARCHAR2
1354: )
1355: IS
1839: p_resale_batch_id IN NUMBER,
1840: p_order_number IN VARCHAR2,
1841: p_sold_from_cust_acct_id IN NUMBER,
1842: p_date_ordered IN DATE,
1843: x_line_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.line_rec_tbl_type,
1844: x_ldets_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE,
1845: x_related_lines_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE,
1846: x_return_status OUT NOCOPY VARCHAR2
1847: )
1840: p_order_number IN VARCHAR2,
1841: p_sold_from_cust_acct_id IN NUMBER,
1842: p_date_ordered IN DATE,
1843: x_line_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.line_rec_tbl_type,
1844: x_ldets_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE,
1845: x_related_lines_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE,
1846: x_return_status OUT NOCOPY VARCHAR2
1847: )
1848: IS
1841: p_sold_from_cust_acct_id IN NUMBER,
1842: p_date_ordered IN DATE,
1843: x_line_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.line_rec_tbl_type,
1844: x_ldets_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE,
1845: x_related_lines_tbl OUT NOCOPY OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE,
1846: x_return_status OUT NOCOPY VARCHAR2
1847: )
1848: IS
1849: --
1854: l_msg_data VARCHAR2(2000);
1855: l_msg_count NUMBER;
1856: l_return_status VARCHAR2(30);
1857: --
1858: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1859: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1860: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1861: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1862: --
1855: l_msg_count NUMBER;
1856: l_return_status VARCHAR2(30);
1857: --
1858: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1859: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1860: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1861: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1862: --
1863: l_line_count NUMBER;
1856: l_return_status VARCHAR2(30);
1857: --
1858: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1859: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1860: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1861: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1862: --
1863: l_line_count NUMBER;
1864: J NUMBER;
2027: IF l_order_set_tbl.EXISTS(1) THEN l_order_set_tbl.DELETE; END IF;
2028: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
2029: IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
2030: IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
2031: IF OZF_ORDER_PRICE_PVT.g_line_rec_tbl.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.g_line_rec_tbl.DELETE; END IF;
2032:
2033: -- Get all lines in an order
2034: --l_line_count := 1;
2035: OPEN order_set_csr(p_order_number,
2070:
2071: -- insert INTO l_line_tbl
2072: l_line_tbl(J).line_index := J;
2073: l_line_tbl(J).line_id := NULL;
2074: l_line_tbl(J).line_type_code := OZF_ORDER_PRICE_PVT.G_ORDER_LINE_TYPE;
2075: l_line_tbl(J).pricing_effective_date := l_order_set_tbl(J).date_ordered;
2076: l_line_tbl(J).active_date_first := l_order_set_tbl(J).date_ordered;
2077: l_line_tbl(J).active_date_first_type := 'ORD';
2078: l_line_tbl(J).active_date_second := l_order_set_tbl(J).date_shipped;
2111: l_line_tbl(J).resale_table_type := 'IFACE'; -- bug 5360598
2112:
2113: -- populate the order_price global line arrary
2114: -- Here I only populate the values of the qualifiers FOR ONT.
2115: -- The real global structure will be populate in ozf_order_price_pvt.
2116: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2117:
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2114: -- Here I only populate the values of the qualifiers FOR ONT.
2115: -- The real global structure will be populate in ozf_order_price_pvt.
2116: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2117:
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2120: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_id := NULL;
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2115: -- The real global structure will be populate in ozf_order_price_pvt.
2116: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2117:
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2120: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_id := NULL;
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2123:
2116: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2117:
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2120: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_id := NULL;
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2123:
2124: IF l_order_set_tbl(J).corrected_agreement_id IS NOT NULL THEN
2117:
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2120: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_id := NULL;
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2123:
2124: IF l_order_set_tbl(J).corrected_agreement_id IS NOT NULL THEN
2125: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).corrected_agreement_id;
2118: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).header_id := l_order_set_tbl.LAST +1;
2119: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).inventory_item_id := l_order_set_tbl(J).inventory_item_id;
2120: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_id := NULL;
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2123:
2124: IF l_order_set_tbl(J).corrected_agreement_id IS NOT NULL THEN
2125: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).corrected_agreement_id;
2126: ELSE
2121: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ordered_quantity := l_order_set_tbl(J).quantity;
2122: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).order_quantity_uom := l_order_set_tbl(J).uom_code;
2123:
2124: IF l_order_set_tbl(J).corrected_agreement_id IS NOT NULL THEN
2125: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).corrected_agreement_id;
2126: ELSE
2127: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).agreement_id;
2128: END IF;
2129:
2123:
2124: IF l_order_set_tbl(J).corrected_agreement_id IS NOT NULL THEN
2125: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).corrected_agreement_id;
2126: ELSE
2127: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).agreement_id;
2128: END IF;
2129:
2130: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).request_date := l_order_set_tbl(J).date_ordered;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2126: ELSE
2127: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).agreement_id;
2128: END IF;
2129:
2130: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).request_date := l_order_set_tbl(J).date_ordered;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2127: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).price_list_id := l_order_set_tbl(J).agreement_id;
2128: END IF;
2129:
2130: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).request_date := l_order_set_tbl(J).date_ordered;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2128: END IF;
2129:
2130: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).request_date := l_order_set_tbl(J).date_ordered;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2129:
2130: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).request_date := l_order_set_tbl(J).date_ordered;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_org_id := l_order_set_tbl(J).bill_to_site_use_id;
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2132: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_org_id := l_order_set_tbl(J).ship_to_site_use_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2133: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_to_org_id := l_order_set_tbl(J).bill_to_cust_account_id;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2134: -- [BEGIN OF BUG 4186465 FIXING]
2135: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2142: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).pricing_date := l_order_set_tbl(J).date_ordered;
2136: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).invoice_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2142: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).pricing_date := l_order_set_tbl(J).date_ordered;
2143: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_type_id := l_order_set_tbl(J).order_type_id;
2144:
2137: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2142: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).pricing_date := l_order_set_tbl(J).date_ordered;
2143: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_type_id := l_order_set_tbl(J).order_type_id;
2144:
2145:
2138: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2142: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).pricing_date := l_order_set_tbl(J).date_ordered;
2143: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_type_id := l_order_set_tbl(J).order_type_id;
2144:
2145:
2146: -- R12 Populate Global Resale Structure (+)
2139: -- [END OF BUG 4186465 FIXING]
2140: -- OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).sold_from_org_id := l_order_set_tbl(J).sold_from_cust_account_id;
2141: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).actual_shipment_date := l_order_set_tbl(J).date_shipped;
2142: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).pricing_date := l_order_set_tbl(J).date_ordered;
2143: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_type_id := l_order_set_tbl(J).order_type_id;
2144:
2145:
2146: -- R12 Populate Global Resale Structure (+)
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2143: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(J).line_type_id := l_order_set_tbl(J).order_type_id;
2144:
2145:
2146: -- R12 Populate Global Resale Structure (+)
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2144:
2145:
2146: -- R12 Populate Global Resale Structure (+)
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2145:
2146: -- R12 Populate Global Resale Structure (+)
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2146: -- R12 Populate Global Resale Structure (+)
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).batch_type := 'CHARGEBACK';
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_index := l_line_tbl(J).line_index;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_table_type := 'IFACE';
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_id := l_order_set_tbl(J).resale_line_int_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).resale_transfer_type := l_order_set_tbl(J).resale_transfer_type;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_movement_type := l_order_set_tbl(J).product_transfer_movement_type;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).product_transfer_date := l_order_set_tbl(J).product_transfer_date;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).tracing_flag := l_order_set_tbl(J).tracing_flag;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_cust_account_id := l_order_set_tbl(J).sold_from_cust_account_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_site_id := l_order_set_tbl(J).sold_from_site_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).sold_from_contact_party_id := l_order_set_tbl(J).sold_from_contact_party_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_cust_account_id := l_order_set_tbl(J).ship_from_cust_account_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_site_id := l_order_set_tbl(J).ship_from_site_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_from_contact_party_id := l_order_set_tbl(J).ship_from_contact_party_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_id := l_order_set_tbl(J).bill_to_party_id;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_party_site_id := l_order_set_tbl(J).bill_to_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).bill_to_contact_party_id := l_order_set_tbl(J).bill_to_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_id := l_order_set_tbl(J).ship_to_party_id;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_party_site_id := l_order_set_tbl(J).ship_to_party_site_id;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).ship_to_contact_party_id := l_order_set_tbl(J).ship_to_contact_party_id;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_id := l_order_set_tbl(J).end_cust_party_id;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_id := l_order_set_tbl(J).end_cust_site_use_id;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_site_use_code := l_order_set_tbl(J).end_cust_site_use_code;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_party_site_id := l_order_set_tbl(J).end_cust_party_site_id;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).end_cust_contact_party_id := l_order_set_tbl(J).end_cust_contact_party_id;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).data_source_code := l_order_set_tbl(J).data_source_code;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2174: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute_category := l_order_set_tbl(J).header_attribute_category;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2175: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute1 := l_order_set_tbl(J).header_attribute1;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2176: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute2 := l_order_set_tbl(J).header_attribute2;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2177: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute3 := l_order_set_tbl(J).header_attribute3;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2178: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute4 := l_order_set_tbl(J).header_attribute4;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2179: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute5 := l_order_set_tbl(J).header_attribute5;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2180: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute6 := l_order_set_tbl(J).header_attribute6;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2181: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute7 := l_order_set_tbl(J).header_attribute7;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2182: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute8 := l_order_set_tbl(J).header_attribute8;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2183: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute9 := l_order_set_tbl(J).header_attribute9;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2184: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute10 := l_order_set_tbl(J).header_attribute10;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2185: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute11 := l_order_set_tbl(J).header_attribute11;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2186: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute12 := l_order_set_tbl(J).header_attribute12;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2187: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute13 := l_order_set_tbl(J).header_attribute13;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2188: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute14 := l_order_set_tbl(J).header_attribute14;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2189: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).header_attribute15 := l_order_set_tbl(J).header_attribute15;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2190: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute_category := l_order_set_tbl(J).line_attribute_category;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2191: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute1 := l_order_set_tbl(J).line_attribute1;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2192: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute2 := l_order_set_tbl(J).line_attribute2;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2193: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute3 := l_order_set_tbl(J).line_attribute3;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2194: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute4 := l_order_set_tbl(J).line_attribute4;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2195: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute5 := l_order_set_tbl(J).line_attribute5;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2196: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute6 := l_order_set_tbl(J).line_attribute6;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2197: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute7 := l_order_set_tbl(J).line_attribute7;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2205: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute15 := l_order_set_tbl(J).line_attribute15;
2198: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute8 := l_order_set_tbl(J).line_attribute8;
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2205: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute15 := l_order_set_tbl(J).line_attribute15;
2206: -- R12 Populate Global Resale Structure (-)
2199: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute9 := l_order_set_tbl(J).line_attribute9;
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2205: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute15 := l_order_set_tbl(J).line_attribute15;
2206: -- R12 Populate Global Resale Structure (-)
2207:
2200: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute10 := l_order_set_tbl(J).line_attribute10;
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2205: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute15 := l_order_set_tbl(J).line_attribute15;
2206: -- R12 Populate Global Resale Structure (-)
2207:
2208:
2201: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute11 := l_order_set_tbl(J).line_attribute11;
2202: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute12 := l_order_set_tbl(J).line_attribute12;
2203: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute13 := l_order_set_tbl(J).line_attribute13;
2204: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute14 := l_order_set_tbl(J).line_attribute14;
2205: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(J).line_attribute15 := l_order_set_tbl(J).line_attribute15;
2206: -- R12 Populate Global Resale Structure (-)
2207:
2208:
2209: IF OZF_DEBUG_LOW_ON THEN
2217: -- build summary line
2218: k := l_order_set_tbl.LAST +1;
2219: l_line_tbl(k).LINE_INDEX := k;
2220: l_line_tbl(k).LINE_ID := NULL;
2221: l_line_tbl(k).LINE_TYPE_CODE := OZF_ORDER_PRICE_PVT.G_ORDER_HEADER_TYPE;
2222: l_line_tbl(k).PRICING_EFFECTIVE_DATE := l_line_tbl(1).PRICING_EFFECTIVE_DATE;
2223: l_line_tbl(k).ACTIVE_DATE_FIRST := l_line_tbl(1).ACTIVE_DATE_FIRST;
2224: l_line_tbl(k).ACTIVE_DATE_FIRST_TYPE := 'ORD'; -- Change because of ONT QP order 'NO TYPE';
2225: l_line_tbl(k).ACTIVE_DATE_SECOND := l_line_tbl(1).ACTIVE_DATE_SECOND;
2254: l_line_tbl(k).resale_table_type := 'IFACE'; -- bug 5360598
2255:
2256: -- populate the order_price global header structure
2257: -- Here I only populate the values of the qualifiers FOR ONT.
2258: -- The real global structure will be populate in ozf_order_price_pvt.
2259: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2260: -- Might be able to add more value here.
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2257: -- Here I only populate the values of the qualifiers FOR ONT.
2258: -- The real global structure will be populate in ozf_order_price_pvt.
2259: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2260: -- Might be able to add more value here.
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2258: -- The real global structure will be populate in ozf_order_price_pvt.
2259: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2260: -- Might be able to add more value here.
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2259: -- AND it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2260: -- Might be able to add more value here.
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2260: -- Might be able to add more value here.
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2261: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2262: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).sold_to_org_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2263: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2264: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_org_id;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2265: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_org_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2266: -- [BEGIN OF BUG 4186465 FIXING]
2267: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_id;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2274: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
2268: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).invoice_to_party_site_id;
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2274: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
2275: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
2276: IF OZF_DEBUG_HIGH_ON THEN
2269: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_id;
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2274: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
2275: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
2276: IF OZF_DEBUG_HIGH_ON THEN
2277: OZF_UTILITY_PVT.debug_message('/*---END Buidling order header FOR order ---*/');
2270: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(1).ship_to_party_site_id;
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2274: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
2275: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
2276: IF OZF_DEBUG_HIGH_ON THEN
2277: OZF_UTILITY_PVT.debug_message('/*---END Buidling order header FOR order ---*/');
2278: OZF_UTILITY_PVT.debug_message('/*--- Calling get order price ---*/');
2271: -- [END OF BUG 4186465 FIXING]
2272: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
2273: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2274: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
2275: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
2276: IF OZF_DEBUG_HIGH_ON THEN
2277: OZF_UTILITY_PVT.debug_message('/*---END Buidling order header FOR order ---*/');
2278: OZF_UTILITY_PVT.debug_message('/*--- Calling get order price ---*/');
2279: END IF;
2278: OZF_UTILITY_PVT.debug_message('/*--- Calling get order price ---*/');
2279: END IF;
2280:
2281: -- Get the agreement price for order lines
2282: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2283: p_api_version => 1.0
2284: ,p_init_msg_list => FND_API.G_FALSE
2285: ,p_commit => FND_API.G_FALSE
2286: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2371: l_cust_account_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
2372: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
2373: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
2374:
2375: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2376: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2377: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2378:
2379: CURSOR batch_info_csr (p_id IN NUMBER) IS
2372: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
2373: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
2374:
2375: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2376: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2377: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2378:
2379: CURSOR batch_info_csr (p_id IN NUMBER) IS
2380: SELECT partner_party_id, report_start_date, report_end_date
2373: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
2374:
2375: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2376: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2377: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2378:
2379: CURSOR batch_info_csr (p_id IN NUMBER) IS
2380: SELECT partner_party_id, report_start_date, report_end_date
2381: FROM ozf_resale_batches