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 128: ,qp_list_lines l

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

Line 363: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

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

Line 453: FROM qp_list_lines

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

Line 992: FROM qp_list_lines

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

Line 1169: /*OZF_OFFER_PVT.process_qp_list_lines

1165: x_listLineId := x_modifier_line_tbl(i).list_line_id;
1166: END IF;
1167: END LOOP;
1168: END IF;
1169: /*OZF_OFFER_PVT.process_qp_list_lines
1170: (
1171: x_return_status OUT NOCOPY VARCHAR2
1172: ,x_msg_count OUT NOCOPY NUMBER
1173: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1372: FROM ozf_offer_adjustment_lines a, qp_list_lines b

1368: IS
1369: CURSOR c_adjustmentLines(cp_offerAdjustmentId NUMBER)
1370: IS
1371: SELECT a.list_line_id, b.list_line_type_code , a.offer_adjustment_line_id
1372: FROM ozf_offer_adjustment_lines a, qp_list_lines b
1373: WHERE
1374: a.list_line_id = b.list_line_id
1375: AND b.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26, 28, 30, 32)
1376: AND offer_adjustment_id = cp_offerAdjustmentId;

Line 1441: 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

1437: , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
1438: )
1439: IS
1440: /**
1441: 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
1442: */
1443: CURSOR c_getPrgLineId(cp_listLineId NUMBER) IS
1444: SELECT from_rltd_modifier_id
1445: FROM qp_rltd_modifiers

Line 1804: qp_list_lines a

1800: , a.list_line_id
1801: , decode(nvl(a.accrual_flag,'N'),'N',a.arithmetic_operator, c.arithmetic_operator) operator
1802: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
1803: FROM
1804: qp_list_lines a
1805: , ozf_related_deal_lines b
1806: , qp_list_lines c
1807: WHERE
1808: a.list_line_id = b.MODIFIER_ID

Line 1806: , qp_list_lines c

1802: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
1803: FROM
1804: qp_list_lines a
1805: , ozf_related_deal_lines b
1806: , qp_list_lines c
1807: WHERE
1808: a.list_line_id = b.MODIFIER_ID
1809: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)
1810: AND a.list_line_id =cp_listLineId;

Line 1891: qp_list_lines a

1887: , b.related_deal_lines_id
1888: , b.object_version_number
1889: , a.start_date_active
1890: FROM
1891: qp_list_lines a
1892: , ozf_related_deal_lines b
1893: , qp_list_lines c
1894: , qp_list_headers_b d
1895: WHERE

Line 1893: , qp_list_lines c

1889: , a.start_date_active
1890: FROM
1891: qp_list_lines a
1892: , ozf_related_deal_lines b
1893: , qp_list_lines c
1894: , qp_list_headers_b d
1895: WHERE
1896: a.list_line_id = b.modifier_id
1897: AND b.related_modifier_id = c.list_line_id(+)

Line 1992: ozf_offer_pvt.process_qp_list_lines

1988: RAISE FND_API.G_EXC_ERROR;
1989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1991: END IF;
1992: ozf_offer_pvt.process_qp_list_lines
1993: (
1994: x_return_status => x_return_status
1995: ,x_msg_count => x_msg_count
1996: ,x_msg_data => x_msg_data

Line 2283: 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.

2279: END getTdLine;
2280:
2281:
2282: /**
2283: 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.
2284: * p_offerAdjustmentId The Adjustment under which the Relation was created
2285: * p_listLineId the primary list_line_id of the Trade Deal Discount Rule.
2286: * p_modifier_tbl the Table used to fetch the newly created list lines into which the Qualifiers are to be copied
2287: */

Line 2301: FROM qp_list_lines

2297: IS
2298: CURSOR c_accrualFlag(cp_listLineId NUMBER)
2299: IS
2300: SELECT accrual_flag
2301: FROM qp_list_lines
2302: WHERE list_line_id = cp_listLineId;
2303: BEGIN
2304: x_return_status := FND_API.G_RET_STS_SUCCESS;
2305: -- get accrual flag for given list line

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

2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2480: ozf_offer_pvt.process_qp_list_lines
2481: (
2482: x_return_status => x_return_status
2483: ,x_msg_count => x_msg_count

Line 2480: ozf_offer_pvt.process_qp_list_lines

2476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2480: ozf_offer_pvt.process_qp_list_lines
2481: (
2482: x_return_status => x_return_status
2483: ,x_msg_count => x_msg_count
2484: ,x_msg_data => x_msg_data

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

2487: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2488: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2489: ,x_error_location => l_errorLocation
2490: );
2491: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);
2492: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2815: OZF_OFFER_PVT.process_qp_list_lines

2811: RAISE FND_API.G_EXC_ERROR;
2812: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END IF;
2815: OZF_OFFER_PVT.process_qp_list_lines
2816: (
2817: x_return_status => x_return_status
2818: ,x_msg_count => x_msg_count
2819: ,x_msg_data => x_msg_data

Line 3043: OZF_OFFER_PVT.process_qp_list_lines

3039: RAISE FND_API.G_EXC_ERROR;
3040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: END IF;
3043: OZF_OFFER_PVT.process_qp_list_lines
3044: (
3045: x_return_status => x_return_status
3046: ,x_msg_count => x_msg_count
3047: ,x_msg_data => x_msg_data

Line 3292: -- create qp_list_lines

3288: l_errorLocation NUMBER;
3289: BEGIN
3290: -- initialize
3291: -- populate discounts
3292: -- create qp_list_lines
3293: -- create ozf_offer_adjustment_lines with created from adjustments = y -- required only for processing with bugets
3294: -- 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.
3295: x_return_status := FND_API.G_RET_STS_SUCCESS;
3296: l_modifier_line_tbl.delete;

Line 3323: OZF_OFFER_PVT.process_qp_list_lines

3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323: OZF_OFFER_PVT.process_qp_list_lines
3324: (
3325: x_return_status => x_return_status
3326: ,x_msg_count => x_msg_count
3327: ,x_msg_data => x_msg_data

Line 3372: FROM qp_list_lines

3368: , pricing_group_sequence
3369: , pricing_phase_id
3370: , print_on_invoice_flag
3371: , incompatibility_grp_code
3372: FROM qp_list_lines
3373: WHERE list_header_id = cp_listHeaderId
3374: AND rownum < 2;
3375: BEGIN
3376: x_return_status := FND_API.G_RET_STS_SUCCESS;