eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_PVT

Line 1320: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1316: IS
1317: l_api_name VARCHAR2(30) := 'process_new_adjustments';
1318: l_qp_list_header_id NUMBER;
1319: l_error_location NUMBER;
1320: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1321: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;
1322:
1323: l_line_ctr NUMBER := 1;
1324: l_offer_type VARCHAR2(30);

Line 1321: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;

1317: l_api_name VARCHAR2(30) := 'process_new_adjustments';
1318: l_qp_list_header_id NUMBER;
1319: l_error_location NUMBER;
1320: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1321: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;
1322:
1323: l_line_ctr NUMBER := 1;
1324: l_offer_type VARCHAR2(30);
1325:

Line 1435: ozf_offer_pvt.process_modifiers ( p_init_msg_list

1431: l_modifier_line_tbl(l_index).qd_object_version_number := l_rltd_line.object_version_number;
1432: l_modifier_line_tbl(l_index).qd_list_line_id := l_adj_line.list_line_id_td;
1433: END IF;
1434: END LOOP;
1435: ozf_offer_pvt.process_modifiers ( p_init_msg_list
1436: ,p_api_version
1437: ,p_commit
1438: ,x_return_status
1439: ,x_msg_count

Line 1469: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1465: )
1466: IS
1467: l_qp_list_header_id NUMBER;
1468: l_error_location NUMBER;
1469: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1470: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;
1471:
1472: l_offer_type VARCHAR2(30);
1473:

Line 1470: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;

1466: IS
1467: l_qp_list_header_id NUMBER;
1468: l_error_location NUMBER;
1469: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1470: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type ;
1471:
1472: l_offer_type VARCHAR2(30);
1473:
1474: CURSOR c_qp_line_detail(p_list_header_id NUMBER) IS

Line 1615: ozf_offer_pvt.process_modifiers ( p_init_msg_list

1611: l_modifier_line_tbl(l_index).arithmetic_operator := l_qp_line_detail.arithmetic_operator;
1612:
1613: END LOOP;
1614: -- calling offer API to update lines
1615: ozf_offer_pvt.process_modifiers ( p_init_msg_list
1616: ,p_api_version
1617: ,p_commit
1618: ,x_return_status
1619: ,x_msg_count

Line 1655: l_reln_rec OZF_OFFER_PVT.ozf_qp_reln_rec_type ;

1651: l_api_name CONSTANT VARCHAR2(30) := 'process_vo_adj_products';
1652: l_api_version_number CONSTANT NUMBER := 1.0;
1653:
1654:
1655: l_reln_rec OZF_OFFER_PVT.ozf_qp_reln_rec_type ;
1656:
1657: BEGIN
1658: -- initialize
1659: SAVEPOINT process_vo_adj_products;

Line 1979: OZF_OFFER_PVT.relate_qp_ozf_lines

1975: -- mgudivak Bug 5400931
1976: -- Commenting the call since the following procedure has been
1977: -- obsoleted in ozfvofrs.pls 120.12
1978: /*
1979: OZF_OFFER_PVT.relate_qp_ozf_lines
1980: (
1981: p_api_version_number => p_api_version,
1982: p_init_msg_list => p_init_msg_list,
1983: p_commit => p_commit,

Line 2033: OZF_OFFER_PVT.relate_qp_ozf_lines

2029: -- mgudivak - Bug 5400931
2030: -- Commenting the call since the following procedure has been
2031: -- obsoleted in ozfvofrs.pls 120.12
2032: /*
2033: OZF_OFFER_PVT.relate_qp_ozf_lines
2034: (
2035: p_api_version_number => p_api_version,
2036: p_init_msg_list => p_init_msg_list,
2037: p_commit => p_commit,

Line 2117: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;

2113: i NUMBER := 1;
2114: j NUMBER;
2115: l_qp_list_header_id NUMBER;
2116: l_error_location NUMBER;
2117: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2118: l_modifier_line_create_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2119: l_modifier_list_rec OZF_OFFER_PVT.MODIFIER_LIST_REC_TYPE;
2120: l_offer_type VARCHAR2(30) := 'VOLUME_OFFER';
2121:

Line 2118: l_modifier_line_create_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;

2114: j NUMBER;
2115: l_qp_list_header_id NUMBER;
2116: l_error_location NUMBER;
2117: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2118: l_modifier_line_create_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2119: l_modifier_list_rec OZF_OFFER_PVT.MODIFIER_LIST_REC_TYPE;
2120: l_offer_type VARCHAR2(30) := 'VOLUME_OFFER';
2121:
2122:

Line 2119: l_modifier_list_rec OZF_OFFER_PVT.MODIFIER_LIST_REC_TYPE;

2115: l_qp_list_header_id NUMBER;
2116: l_error_location NUMBER;
2117: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2118: l_modifier_line_create_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE;
2119: l_modifier_list_rec OZF_OFFER_PVT.MODIFIER_LIST_REC_TYPE;
2120: l_offer_type VARCHAR2(30) := 'VOLUME_OFFER';
2121:
2122:
2123: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 2176: OZF_OFFER_PVT.process_modifiers

2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);
2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);
2174:
2175: END LOOP;
2176: OZF_OFFER_PVT.process_modifiers
2177: (
2178: p_init_msg_list => FND_API.G_FALSE
2179: , p_api_version => 1.0
2180: , p_commit => FND_API.G_FALSE

Line 2269: OZF_OFFER_PVT.create_offer_tiers

2265: l_modifier_line_create_tbl(i).operation := 'CREATE';
2266: i := i + 1;
2267: END LOOP;
2268: dbms_output.put_line('Size is '||l_modifier_line_create_tbl.count);
2269: OZF_OFFER_PVT.create_offer_tiers
2270: (
2271: p_init_msg_list => p_init_msg_list
2272: ,p_api_version => p_api_version
2273: ,p_commit => p_commit

Line 2308: l_reln_rec OZF_OFFER_PVT.ozf_qp_reln_rec_type;

2304: AND f.product_attribute = e.product_attribute
2305: and f.product_attr_value = e.product_attr_value
2306: AND d.start_date_active >= b.effective_date
2307: AND a.offer_adjustment_id = p_offer_adjustment_id;
2308: l_reln_rec OZF_OFFER_PVT.ozf_qp_reln_rec_type;
2309: BEGIN
2310: FOR l_create_reln in c_create_reln(p_offer_adjustment_id ) LOOP
2311: l_reln_rec.pricing_attribute_id := l_create_reln.pricing_attribute_id;
2312: l_reln_rec.qp_list_line_id := l_create_reln.list_line_id;

Line 2319: OZF_OFFER_PVT.relate_qp_ozf_lines

2315: dbms_output.put_line('Prc attr : '||l_reln_rec.pricing_attribute_id);
2316: dbms_output.put_line('ListLIneId :'||l_reln_rec.qp_list_line_id);
2317: dbms_output.put_line('Discount line id :'||l_reln_rec.offer_discount_line_id);
2318: dbms_output.put_line('Prod id :'||l_reln_rec.off_discount_product_id);
2319: OZF_OFFER_PVT.relate_qp_ozf_lines
2320: (
2321: p_api_version_number => p_api_version,
2322: p_init_msg_list => p_init_msg_list,
2323: p_commit => p_commit,

Line 2637: OZF_OFFER_PVT.raise_offer_event(l_list_header_id, p_offer_adjustment_id);

2633: FROM ozf_offer_adjustments_b a
2634: WHERE offer_adjustment_id = p_offer_adjustment_id;
2635:
2636: --insert into ozf_events values('After process_adjustment'||p_offer_adjustment_id,sysdate);
2637: OZF_OFFER_PVT.raise_offer_event(l_list_header_id, p_offer_adjustment_id);
2638:
2639: IF p_commit = Fnd_Api.g_true
2640: THEN
2641: COMMIT WORK;