442: --
443: -- PARAMETERS
444: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
445: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,
446: -- p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
447: -- p_header_id IN NUMBER,
448: -- p_resale_batch_id IN NUMBER,
449: -- p_inventory_tracking IN BOOLEAN,
450: -- p_price_diff_fund_id IN NUMBER,
458: ---------------------------------------------------------------------
459: PROCEDURE Process_One_Line(
460: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
461: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
462: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
463: p_header_id IN NUMBER,
464: p_resale_batch_id IN NUMBER,
465: p_inventory_tracking IN BOOLEAN,
466: p_price_diff_fund_id IN NUMBER,
488: INDEX BY binary_integer;
489:
490: l_line_ldets_tbl line_ldets_tbl_type;
491: l_line_id NUMBER := NULL;
492: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
493:
494: --j NUMBER :=1;
495: m NUMBER := 1;
496:
1220: -- on the discount information.
1221: --
1222: -- PARAMETERS
1223: -- p_resale_batch_id IN NUMBER,
1224: -- p_line_tbl IN OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE,
1225: -- p_caller_type IN VARCHAR2,
1226: -- x_return_status OUT NOCOPY VARCHAR2
1227: --
1228: -- NOTES
1232: --
1233: ---------------------------------------------------------------------
1234: PROCEDURE Process_Pricing_Result(
1235: p_resale_batch_id IN NUMBER,
1236: p_line_tbl IN OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE,
1237: p_caller_type IN VARCHAR2,
1238: x_return_status OUT NOCOPY VARCHAR2
1239: )
1240: IS
1855: l_order_set_tbl resale_lines_tbl_type;
1856:
1857: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1858:
1859: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1860: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1861: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1862:
1863: p NUMBER;
1856:
1857: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1858:
1859: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1860: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1861: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1862:
1863: p NUMBER;
1864: k NUMBER;
1857: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1858:
1859: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
1860: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
1861: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
1862:
1863: p NUMBER;
1864: k NUMBER;
1865:
1993: IF l_order_set_tbl.EXISTS(1) THEN l_order_set_tbl.DELETE; END IF;
1994: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
1995: IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
1996: IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
1997: IF OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.DELETE; END IF;
1998: IF OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.DELETE; END IF;
1999:
2000: -- get order_header_rec
2001: OPEN order_header_csr(l_header_id_tbl(i).resale_header_id);
1994: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
1995: IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
1996: IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
1997: IF OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.DELETE; END IF;
1998: IF OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.DELETE; END IF;
1999:
2000: -- get order_header_rec
2001: OPEN order_header_csr(l_header_id_tbl(i).resale_header_id);
2002: FETCH order_header_csr INTO l_header_rec;
2037:
2038: -- INSERT INTO l_line_tbl
2039: l_line_tbl(j).line_index := j;
2040: l_line_tbl(j).line_id := l_order_set_tbl(j).resale_line_id;
2041: l_line_tbl(j).line_type_code := OZF_ORDER_PRICE_PVT.G_ORDER_LINE_TYPE;
2042: l_line_tbl(j).pricing_effective_date := l_order_set_tbl(j).date_ordered;
2043: l_line_tbl(j).active_date_first := l_order_set_tbl(j).date_ordered;
2044: l_line_tbl(j).active_date_first_type := 'ORD';
2045: l_line_tbl(j).active_date_second := l_order_set_tbl(j).date_shipped;
2088:
2089:
2090: -- populate the order_price global line arrary
2091: -- Here I only populate the values of the qualifiers for ONT.
2092: -- The real global structure will be populate in ozf_order_price_pvt.
2093: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2094:
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2091: -- Here I only populate the values of the qualifiers for ONT.
2092: -- The real global structure will be populate in ozf_order_price_pvt.
2093: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2094:
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2092: -- The real global structure will be populate in ozf_order_price_pvt.
2093: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2094:
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2093: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2094:
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2094:
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2095: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2096: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2097: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_header_rec.order_type_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2098: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2099: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity);
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2100: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2101: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2102: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2103: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2104: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2105: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2106: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2107: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2108: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2109: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
2110: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2111: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2112: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2113:
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2114: -- R12 Populate Global Resale Structure (+)
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2115: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2116: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2117: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2118: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'RESALE';
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2119: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2120: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2121: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2122: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2123: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2124: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2125: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2126: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2127: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2128: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2129: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2130: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2131: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2132: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2133: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2134: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2135: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2136: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2137: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2138: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2139: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2140: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2141: --OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := ??
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2142: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_header_id_tbl(i).header_attribute_category;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2143: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_header_id_tbl(i).header_attribute1;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2144: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_header_id_tbl(i).header_attribute2;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2145: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_header_id_tbl(i).header_attribute3;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2146: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_header_id_tbl(i).header_attribute4;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2147: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_header_id_tbl(i).header_attribute5;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2148: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_header_id_tbl(i).header_attribute6;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2149: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_header_id_tbl(i).header_attribute7;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2150: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_header_id_tbl(i).header_attribute8;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2151: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_header_id_tbl(i).header_attribute9;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2152: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_header_id_tbl(i).header_attribute10;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2153: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_header_id_tbl(i).header_attribute11;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2154: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_header_id_tbl(i).header_attribute12;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2155: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_header_id_tbl(i).header_attribute13;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2156: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_header_id_tbl(i).header_attribute14;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2157: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_header_id_tbl(i).header_attribute15;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2158: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2159: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2160: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2161: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2162: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2163: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2164: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2165: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
2166: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
2174: -- R12 Populate Global Resale Structure (-)
2167: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
2174: -- R12 Populate Global Resale Structure (-)
2175:
2168: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
2174: -- R12 Populate Global Resale Structure (-)
2175:
2176:
2169: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
2170: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
2171: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
2172: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
2173: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
2174: -- R12 Populate Global Resale Structure (-)
2175:
2176:
2177:
2184: -- build summary line
2185: k := l_order_set_tbl.LAST + 1;
2186: l_line_tbl(k).line_index := k;
2187: l_line_tbl(k).line_id := NULL;
2188: l_line_tbl(k).line_type_code := OZF_ORDER_PRICE_PVT.G_ORDER_HEADER_TYPE;
2189: l_line_tbl(k).pricing_effective_date := l_header_rec.date_ordered;
2190: l_line_tbl(k).active_date_first := l_header_rec.date_ordered;
2191: l_line_tbl(k).active_date_first_type := 'ORD'; -- Change because of ONT QP order 'NO TYPE';
2192: l_line_tbl(k).active_date_second := l_header_rec.date_shipped;
2204:
2205:
2206: -- populate the order_price global header structure
2207: -- Here I only populate the values of the qualifiers for ONT.
2208: -- The real global structure will be populate in ozf_order_price_pvt.
2209: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2210:
2211: -- Might be able to add more value here.
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2208: -- The real global structure will be populate in ozf_order_price_pvt.
2209: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2210:
2211: -- Might be able to add more value here.
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2209: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
2210:
2211: -- Might be able to add more value here.
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2210:
2211: -- Might be able to add more value here.
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2211: -- Might be able to add more value here.
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2212: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2213: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_header_rec.order_type_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2214: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_header_rec.bill_to_cust_account_id;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2215: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_header_rec.bill_to_site_use_id;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2216: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_header_rec.ship_to_site_use_id;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2217: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_header_rec.bill_to_party_id;
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2225:
2218: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_header_rec.bill_to_party_site_id;
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2225:
2226:
2219: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_header_rec.ship_to_party_id;
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2225:
2226:
2227: IF OZF_DEBUG_LOW_ON THEN
2220: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_header_rec.ship_to_party_site_id;
2221: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
2222: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_header_rec.date_ordered;
2223: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_header_rec.date_ordered;
2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2225:
2226:
2227: IF OZF_DEBUG_LOW_ON THEN
2228: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
2227: IF OZF_DEBUG_LOW_ON THEN
2228: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
2229: END IF;
2230:
2231: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2232: p_api_version => 1.0
2233: ,p_init_msg_list => FND_API.G_FALSE
2234: ,p_commit => FND_API.G_FALSE
2235: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2886: l_order_set_tbl resale_lines_tbl_type;
2887:
2888: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2889:
2890: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2891: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2892: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2893:
2894: p NUMBER;
2887:
2888: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2889:
2890: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2891: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2892: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2893:
2894: p NUMBER;
2895: k NUMBER;
2888: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2889:
2890: l_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
2891: l_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
2892: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2893:
2894: p NUMBER;
2895: k NUMBER;
2896:
3227: IF l_order_set_tbl.EXISTS(1) THEN l_order_set_tbl.DELETE; END IF;
3228: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
3229: IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
3230: IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
3231: IF OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.DELETE; END IF;
3232: IF OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.DELETE; END IF;
3233:
3234: FETCH order_set_csr BULK COLLECT INTO l_order_set_tbl LIMIT G_BULK_LIMIT;
3235: IF l_order_set_tbl.FIRST IS NULL THEN
3228: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
3229: IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
3230: IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
3231: IF OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.DELETE; END IF;
3232: IF OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL.DELETE; END IF;
3233:
3234: FETCH order_set_csr BULK COLLECT INTO l_order_set_tbl LIMIT G_BULK_LIMIT;
3235: IF l_order_set_tbl.FIRST IS NULL THEN
3236: EXIT;
3269:
3270: -- INSERT INTO l_line_tbl
3271: l_line_tbl(j).line_index := j;
3272: l_line_tbl(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3273: l_line_tbl(j).line_type_code := OZF_ORDER_PRICE_PVT.G_ORDER_LINE_TYPE;
3274: l_line_tbl(j).pricing_effective_date := l_order_set_tbl(j).date_ordered;
3275: l_line_tbl(j).active_date_first := l_order_set_tbl(j).date_ordered;
3276: l_line_tbl(j).active_date_first_type := 'ORD';
3277: l_line_tbl(j).active_date_second := l_order_set_tbl(j).date_shipped;
3317: -- l_line_tbl(j).LINE_CATEGORY := NULL;
3318:
3319: -- populate the order_price global line arrary
3320: -- Here I only populate the values of the qualifiers for ONT.
3321: -- The real global structure will be populate in ozf_order_price_pvt.
3322: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3323:
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3320: -- Here I only populate the values of the qualifiers for ONT.
3321: -- The real global structure will be populate in ozf_order_price_pvt.
3322: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3323:
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3321: -- The real global structure will be populate in ozf_order_price_pvt.
3322: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3323:
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3322: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3323:
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3323:
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3324: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).header_id := l_order_set_tbl.LAST + 1;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3325: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3326: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).line_type_id := l_order_set_tbl(j).order_type_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3327: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).inventory_item_id := l_order_set_tbl(j).inventory_item_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3328: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ordered_quantity := ABS(l_order_set_tbl(j).quantity); -- BUG 4581928
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3329: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).order_quantity_uom := l_order_set_tbl(j).uom_code;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3330: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_org_id := l_order_set_tbl(j).bill_to_site_use_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3331: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_org_id := l_order_set_tbl(j).ship_to_site_use_id;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3332: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_to_org_id := l_order_set_tbl(j).bill_to_cust_account_id;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3333: --OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).sold_from_org_id := l_order_set_tbl(j).sold_from_cust_account_id;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3334: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3335: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).invoice_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3336: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3337: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3338: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).price_list_id := l_line_tbl(j).price_list_id;
3339: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).request_date := l_order_set_tbl(j).date_ordered;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3340: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).actual_shipment_date := l_order_set_tbl(j).date_shipped;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3341: OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL(j).pricing_date := l_order_set_tbl(j).date_ordered;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3342:
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3343: -- R12 Populate Global Resale Structure (+)
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3344: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).batch_type := 'TP_ACCRUAL';
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3345: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).qp_context_request_id := QP_Price_Request_Context.Get_Request_Id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3346: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_index := l_line_tbl(j).line_index;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3347: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_table_type := 'IFACE';
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3348: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_id := l_order_set_tbl(j).resale_line_int_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3349: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).resale_transfer_type := l_order_set_tbl(j).resale_transfer_type;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3350: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_movement_type := l_order_set_tbl(j).product_transfer_movement_type;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3351: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).product_transfer_date := l_order_set_tbl(j).product_transfer_date;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3352: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).tracing_flag := l_order_set_tbl(j).tracing_flag;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3353: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_cust_account_id := l_order_set_tbl(j).sold_from_cust_account_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3354: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_site_id := l_order_set_tbl(j).sold_from_site_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3355: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).sold_from_contact_party_id := l_order_set_tbl(j).sold_from_contact_party_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3356: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_cust_account_id := l_order_set_tbl(j).ship_from_cust_account_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3357: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_site_id := l_order_set_tbl(j).ship_from_site_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3358: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_from_contact_party_id := l_order_set_tbl(j).ship_from_contact_party_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3359: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_id := l_order_set_tbl(j).bill_to_party_id;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3360: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_party_site_id := l_order_set_tbl(j).bill_to_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3361: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).bill_to_contact_party_id := l_order_set_tbl(j).bill_to_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3362: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_id := l_order_set_tbl(j).ship_to_party_id;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3363: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_party_site_id := l_order_set_tbl(j).ship_to_party_site_id;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3364: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).ship_to_contact_party_id := l_order_set_tbl(j).ship_to_contact_party_id;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3365: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_id := l_order_set_tbl(j).end_cust_party_id;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3366: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_id := l_order_set_tbl(j).end_cust_site_use_id;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3367: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_site_use_code := l_order_set_tbl(j).end_cust_site_use_code;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3368: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_party_site_id := l_order_set_tbl(j).end_cust_party_site_id;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3369: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).end_cust_contact_party_id := l_order_set_tbl(j).end_cust_contact_party_id;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3370: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).data_source_code := l_order_set_tbl(j).data_source_code;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3371: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute_category := l_order_set_tbl(j).header_attribute_category;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3372: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute1 := l_order_set_tbl(j).header_attribute1;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3373: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute2 := l_order_set_tbl(j).header_attribute2;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3374: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute3 := l_order_set_tbl(j).header_attribute3;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3375: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute4 := l_order_set_tbl(j).header_attribute4;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3376: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute5 := l_order_set_tbl(j).header_attribute5;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3377: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute6 := l_order_set_tbl(j).header_attribute6;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3378: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute7 := l_order_set_tbl(j).header_attribute7;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3379: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute8 := l_order_set_tbl(j).header_attribute8;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3380: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute9 := l_order_set_tbl(j).header_attribute9;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3381: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute10 := l_order_set_tbl(j).header_attribute10;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3382: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute11 := l_order_set_tbl(j).header_attribute11;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3383: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute12 := l_order_set_tbl(j).header_attribute12;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3384: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute13 := l_order_set_tbl(j).header_attribute13;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3385: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute14 := l_order_set_tbl(j).header_attribute14;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3386: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).header_attribute15 := l_order_set_tbl(j).header_attribute15;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3387: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute_category := l_order_set_tbl(j).line_attribute_category;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3388: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute1 := l_order_set_tbl(j).line_attribute1;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3389: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute2 := l_order_set_tbl(j).line_attribute2;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3390: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute3 := l_order_set_tbl(j).line_attribute3;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3391: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute4 := l_order_set_tbl(j).line_attribute4;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3392: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute5 := l_order_set_tbl(j).line_attribute5;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3393: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute6 := l_order_set_tbl(j).line_attribute6;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3394: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute7 := l_order_set_tbl(j).line_attribute7;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3402: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
3395: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute8 := l_order_set_tbl(j).line_attribute8;
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3402: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
3403: -- R12 Populate Global Resale Structure (-)
3396: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute9 := l_order_set_tbl(j).line_attribute9;
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3402: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
3403: -- R12 Populate Global Resale Structure (-)
3404:
3397: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute10 := l_order_set_tbl(j).line_attribute10;
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3402: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
3403: -- R12 Populate Global Resale Structure (-)
3404:
3405: END LOOP; ---FOR i IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3398: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute11 := l_order_set_tbl(j).line_attribute11;
3399: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute12 := l_order_set_tbl(j).line_attribute12;
3400: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute13 := l_order_set_tbl(j).line_attribute13;
3401: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute14 := l_order_set_tbl(j).line_attribute14;
3402: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL(j).line_attribute15 := l_order_set_tbl(j).line_attribute15;
3403: -- R12 Populate Global Resale Structure (-)
3404:
3405: END LOOP; ---FOR i IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3406:
3412: -- build summary line
3413: k := l_order_set_tbl.LAST + 1;
3414: l_line_tbl(k).line_index := k;
3415: l_line_tbl(k).line_id := NULL;
3416: l_line_tbl(k).line_type_code := OZF_ORDER_PRICE_PVT.G_ORDER_HEADER_TYPE;
3417: l_line_tbl(k).pricing_effective_date := l_order_set_tbl(1).date_ordered;
3418: l_line_tbl(k).active_date_first := l_order_set_tbl(1).date_ordered;
3419: l_line_tbl(k).active_date_first_type := 'ORD'; -- Change because of ONT QP order 'NO TYPE';
3420: l_line_tbl(k).active_date_second := l_order_set_tbl(1).date_shipped;
3452: -- l_line_tbl(j).LINE_CATEGORY := NULL;
3453:
3454: -- populate the order_price global header structure
3455: -- Here I only populate the values of the qualifiers for ONT.
3456: -- The real global structure will be populate in ozf_order_price_pvt.
3457: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3458:
3459: -- Might be able to add more value here.
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3456: -- The real global structure will be populate in ozf_order_price_pvt.
3457: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3458:
3459: -- Might be able to add more value here.
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3457: -- And it's value can be change in OZF_CHARGEBACK_ATTRMAP_PUB
3458:
3459: -- Might be able to add more value here.
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3458:
3459: -- Might be able to add more value here.
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3459: -- Might be able to add more value here.
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3460: OZF_ORDER_PRICE_PVT.G_HEADER_REC.header_id := k;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3461: OZF_ORDER_PRICE_PVT.G_HEADER_REC.order_type_id := l_order_set_tbl(1).order_type_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3462: OZF_ORDER_PRICE_PVT.G_HEADER_REC.sold_to_org_id := l_order_set_tbl(1).bill_to_cust_account_id;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3463: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_org_id := l_order_set_tbl(1).bill_to_site_use_id;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3464: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_org_id := l_order_set_tbl(1).ship_to_site_use_id;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3465: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_id := l_order_set_tbl(1).bill_to_party_id;
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3473:
3466: OZF_ORDER_PRICE_PVT.G_HEADER_REC.invoice_to_party_site_id := l_order_set_tbl(1).bill_to_party_site_id;
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3473:
3474: IF OZF_DEBUG_LOW_ON THEN
3467: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_id := l_order_set_tbl(1).ship_to_party_id;
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3473:
3474: IF OZF_DEBUG_LOW_ON THEN
3475: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
3468: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ship_to_party_site_id := l_order_set_tbl(1).ship_to_party_site_id;
3469: OZF_ORDER_PRICE_PVT.G_HEADER_REC.price_list_id := l_line_tbl(1).price_list_id;
3470: OZF_ORDER_PRICE_PVT.G_HEADER_REC.ordered_date := l_order_set_tbl(1).date_ordered;
3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3473:
3474: IF OZF_DEBUG_LOW_ON THEN
3475: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
3476: END IF;
3474: IF OZF_DEBUG_LOW_ON THEN
3475: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
3476: END IF;
3477:
3478: OZF_ORDER_PRICE_PVT.Get_Order_Price (
3479: p_api_version => 1.0
3480: ,p_init_msg_list => FND_API.G_FALSE
3481: ,p_commit => FND_API.G_FALSE
3482: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL