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_ADJ_PVT dependencies on QP_LIST_LINES

Line 130: ,qp_list_lines l

126: ,l_lineStDt
127: ,l_effectiveDt
128: FROM ozf_offer_adjustments_b a
129: ,qp_list_headers_b h
130: ,qp_list_lines l
131: WHERE a.list_header_id = h.list_header_id
132: and a.list_header_id = l.list_header_id
133: and l.list_line_id = p_listLineId
134: and a.offer_adjustment_id = p_offerAdjustmentId;

Line 365: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

361: CURSOR c_discounts(cp_offerAdjustmentId NUMBER, cp_pbhListLineId NUMBER) IS
362: SELECT
363: nvl(a.modified_discount,c.operand) discount
364: FROM
365: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c
366: WHERE
367: a.list_line_id (+) = b.to_rltd_modifier_id
368: AND b.to_rltd_modifier_id = c.list_line_id
369: AND b.from_rltd_modifier_id = cp_pbhListLineId

Line 455: FROM qp_list_lines

451: )
452: IS
453: CURSOR c_listHeaderId (cp_listLineId NUMBER) IS
454: SELECT list_header_id
455: FROM qp_list_lines
456: WHERE list_line_id = cp_listLineId;
457: l_listHeaderId NUMBER;
458: BEGIN
459: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 994: FROM qp_list_lines

990: IS
991: CURSOR c_listLineDetails(cp_listLineId NUMBER) IS
992: SELECT
993: list_line_id
994: FROM qp_list_lines
995: WHERE list_line_id = cp_listLineId;
996: i NUMBER;
997: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
998: BEGIN

Line 1139: FROM ozf_offer_adjustment_lines adjl, qp_list_lines qpl

1135: CURSOR c_listLineId IS
1136: SELECT adjl.list_line_id
1137: ,qpl.list_line_no
1138: ,adjl.modified_discount
1139: FROM ozf_offer_adjustment_lines adjl, qp_list_lines qpl
1140: WHERE offer_adjustment_line_id = p_offerAdjustmentLineId
1141: AND qpl.list_header_id = adjl.list_header_id
1142: AND adjl.list_line_id = qpl.list_line_id ;
1143:

Line 1403: /*OZF_OFFER_PVT.process_qp_list_lines

1399: x_listLineId := x_modifier_line_tbl(i).list_line_id;
1400: END IF;
1401: END LOOP;
1402: END IF;
1403: /*OZF_OFFER_PVT.process_qp_list_lines
1404: (
1405: x_return_status OUT NOCOPY VARCHAR2
1406: ,x_msg_count OUT NOCOPY NUMBER
1407: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1623: FROM ozf_offer_adjustment_lines a, qp_list_lines b

1619: IS
1620: CURSOR c_adjustmentLines(cp_offerAdjustmentId NUMBER)
1621: IS
1622: SELECT a.list_line_id, b.list_line_type_code , a.offer_adjustment_line_id
1623: FROM ozf_offer_adjustment_lines a, qp_list_lines b
1624: WHERE
1625: a.list_line_id = b.list_line_id
1626: AND b.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26, 28, 30, 32)
1627: AND offer_adjustment_id = cp_offerAdjustmentId;

Line 1692: This cursor probably may have issues and we may have to join qp_list_lines and put a filter on list_line_type_code = PRG

1688: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1689: )
1690: IS
1691: /**
1692: This cursor probably may have issues and we may have to join qp_list_lines and put a filter on list_line_type_code = PRG
1693: */
1694: CURSOR c_getPrgLineId(cp_listLineId NUMBER) IS
1695: SELECT from_rltd_modifier_id
1696: FROM qp_rltd_modifiers

Line 2055: qp_list_lines a

2051: , a.list_line_id
2052: , decode(nvl(a.accrual_flag,'N'),'N',a.arithmetic_operator, c.arithmetic_operator) operator
2053: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
2054: FROM
2055: qp_list_lines a
2056: , ozf_related_deal_lines b
2057: , qp_list_lines c
2058: WHERE
2059: a.list_line_id = b.MODIFIER_ID

Line 2057: , qp_list_lines c

2053: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
2054: FROM
2055: qp_list_lines a
2056: , ozf_related_deal_lines b
2057: , qp_list_lines c
2058: WHERE
2059: a.list_line_id = b.MODIFIER_ID
2060: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)
2061: AND a.list_line_id =cp_listLineId;

Line 2175: qp_list_lines a

2171: , b.related_deal_lines_id
2172: , b.object_version_number
2173: , a.start_date_active
2174: FROM
2175: qp_list_lines a
2176: , ozf_related_deal_lines b
2177: , qp_list_lines c
2178: , qp_list_headers_b d
2179: WHERE

Line 2177: , qp_list_lines c

2173: , a.start_date_active
2174: FROM
2175: qp_list_lines a
2176: , ozf_related_deal_lines b
2177: , qp_list_lines c
2178: , qp_list_headers_b d
2179: WHERE
2180: a.list_line_id = b.modifier_id
2181: AND b.related_modifier_id = c.list_line_id(+)

Line 2276: ozf_offer_pvt.process_qp_list_lines

2272: RAISE FND_API.G_EXC_ERROR;
2273: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2275: END IF;
2276: ozf_offer_pvt.process_qp_list_lines
2277: (
2278: x_return_status => x_return_status
2279: ,x_msg_count => x_msg_count
2280: ,x_msg_data => x_msg_data

Line 2567: Relates a trade deal Discount rule to a group of qp_list_lines. these qp_list_lines are actually the components of a single trade deal discount rule.

2563: END getTdLine;
2564:
2565:
2566: /**
2567: Relates a trade deal Discount rule to a group of qp_list_lines. these qp_list_lines are actually the components of a single trade deal discount rule.
2568: * p_offerAdjustmentId The Adjustment under which the Relation was created
2569: * p_listLineId the primary list_line_id of the Trade Deal Discount Rule.
2570: * p_modifier_tbl the Table used to fetch the newly created list lines into which the Qualifiers are to be copied
2571: */

Line 2585: FROM qp_list_lines

2581: IS
2582: CURSOR c_accrualFlag(cp_listLineId NUMBER)
2583: IS
2584: SELECT accrual_flag
2585: FROM qp_list_lines
2586: WHERE list_line_id = cp_listLineId;
2587: BEGIN
2588: x_return_status := FND_API.G_RET_STS_SUCCESS;
2589: -- get accrual flag for given list line

Line 2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);

2759: RAISE FND_API.G_EXC_ERROR;
2760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2762: END IF;
2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2764: ozf_offer_pvt.process_qp_list_lines
2765: (
2766: x_return_status => x_return_status
2767: ,x_msg_count => x_msg_count

Line 2764: ozf_offer_pvt.process_qp_list_lines

2760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2762: END IF;
2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2764: ozf_offer_pvt.process_qp_list_lines
2765: (
2766: x_return_status => x_return_status
2767: ,x_msg_count => x_msg_count
2768: ,x_msg_data => x_msg_data

Line 2775: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);

2771: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2772: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2773: ,x_error_location => l_errorLocation
2774: );
2775: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);
2776: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2777: RAISE FND_API.G_EXC_ERROR;
2778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3099: OZF_OFFER_PVT.process_qp_list_lines

3095: RAISE FND_API.G_EXC_ERROR;
3096: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3098: END IF;
3099: OZF_OFFER_PVT.process_qp_list_lines
3100: (
3101: x_return_status => x_return_status
3102: ,x_msg_count => x_msg_count
3103: ,x_msg_data => x_msg_data

Line 3327: OZF_OFFER_PVT.process_qp_list_lines

3323: RAISE FND_API.G_EXC_ERROR;
3324: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: END IF;
3327: OZF_OFFER_PVT.process_qp_list_lines
3328: (
3329: x_return_status => x_return_status
3330: ,x_msg_count => x_msg_count
3331: ,x_msg_data => x_msg_data

Line 3782: -- create qp_list_lines

3778:
3779: BEGIN
3780: -- initialize
3781: -- populate discounts
3782: -- create qp_list_lines
3783: -- create ozf_offer_adjustment_lines with created from adjustments = y -- required only for processing with bugets
3784: -- need to look at relating offer_adj_new_line_id with the qp list_line_id created. may be useful later for audit reporting and Sarbines-Auxley compliance.
3785: x_return_status := FND_API.G_RET_STS_SUCCESS;
3786: l_modifier_line_tbl.delete;

Line 3842: OZF_OFFER_PVT.process_qp_list_lines

3838: END IF;
3839:
3840: END IF;
3841:
3842: OZF_OFFER_PVT.process_qp_list_lines
3843: (
3844: x_return_status => x_return_status
3845: ,x_msg_count => x_msg_count
3846: ,x_msg_data => x_msg_data

Line 3918: FROM qp_list_lines

3914: , pricing_group_sequence
3915: , pricing_phase_id
3916: , print_on_invoice_flag
3917: , incompatibility_grp_code
3918: FROM qp_list_lines
3919: WHERE list_header_id = cp_listHeaderId
3920: AND rownum < 2;
3921: BEGIN
3922: x_return_status := FND_API.G_RET_STS_SUCCESS;