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_PVT dependencies on QP_LIMITS

Line 175: -- Tue Apr 01 2008: nirprasa Added amount null check before calling qp_limits_pub.process_limits

171: -- for customers, truncated start and end dates for products
172: -- Wed Feb 13 2008: nirprasa fixed bug 6813556
173: -- Tue Fev 19 2008: nirprasa Added SDR validations: do not create offer header if there are no vendor approved lines.
174: -- Do not create offer if OZF_SD_DEFAULT_BUDGET profile is not set.
175: -- Tue Apr 01 2008: nirprasa Added amount null check before calling qp_limits_pub.process_limits
176: -- Tue Apr 15 2008: nirprasa fixed bug 6968932
177: -- Wed Apr 16 2008: nirprasa fixed bug 6974091
178: -- Wed Apr 30 2008: nirprasa fixed bug 7004273
179: -- Tue Aug 12 2008: nirprasa fixed bug 7321745

Line 2677: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type,

2673:
2674: --nirprasa
2675: PROCEDURE populate_limits_rec(
2676: p_limit_type IN VARCHAR2,
2677: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type,
2678: p_limit_exceed_action_code IN VARCHAR2 DEFAULT NULL) IS
2679: BEGIN
2680:
2681: IF p_limit_exceed_action_code IS NOT NULL AND p_limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN

Line 2744: FROM qp_limits

2740: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2741:
2742: CURSOR cur_does_limit_exist(p_limit_number NUMBER) IS
2743: SELECT count(limit_id)
2744: FROM qp_limits
2745: WHERE list_line_id = p_list_line_id
2746: AND limit_number = p_limit_number;
2747:
2748: l_limit_exists NUMBER;

Line 2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

2747:
2748: l_limit_exists NUMBER;
2749: l_limit_number NUMBER;
2750:
2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

Line 2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

2748: l_limit_exists NUMBER;
2749: l_limit_number NUMBER;
2750:
2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

2749: l_limit_number NUMBER;
2750:
2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

Line 2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

2750:
2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2758:

Line 2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

2751: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2758:
2759: BEGIN

Line 2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

2752: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2758:
2759: BEGIN
2760: x_return_status := fnd_api.g_ret_sts_success;

Line 2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

2753: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2754: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2755: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2756: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2757: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2758:
2759: BEGIN
2760: x_return_status := fnd_api.g_ret_sts_success;
2761:

Line 2806: -- ORA-01400: cannot insert NULL into ("QP"."QP_LIMITS"."AMOUNT") in Package QP_Limits_Util Procedure

2802: l_limits_rec.amount := p_limit_amount;
2803: END IF;
2804:
2805: -- as per suggetsion from Renuka and Karan for error message
2806: -- ORA-01400: cannot insert NULL into ("QP"."QP_LIMITS"."AMOUNT") in Package QP_Limits_Util Procedure
2807: -- added condition l_limits_rec.operation = 'DELETE' to allow to process delete operation if record is null
2808: IF (l_limits_rec.operation = 'DELETE'
2809: OR (l_limits_rec.amount IS NOT NULL AND
2810: l_limits_rec.amount <> FND_API.G_MISS_NUM)) THEN

Line 2814: QP_Limits_PUB.Process_Limits

2810: l_limits_rec.amount <> FND_API.G_MISS_NUM)) THEN
2811:
2812: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_limits before calling QP for list_header_id : '|| p_list_header_id);
2813:
2814: QP_Limits_PUB.Process_Limits
2815: ( p_init_msg_list => FND_API.g_true,
2816: p_api_version_number => 1.0,
2817: p_commit => FND_API.g_false,
2818: x_return_status => x_return_status,

Line 4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

Line 4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

Line 4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4462:

Line 4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4462:
4463: l_uk_flag VARCHAR2(1);

Line 4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4462:
4463: l_uk_flag VARCHAR2(1);
4464:

Line 4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

4457: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4458: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4459: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4460: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4461: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4462:
4463: l_uk_flag VARCHAR2(1);
4464:
4465: --nepanda : fix for bug 9149865

Line 4474: FROM qp_limits

4470:
4471: -- nepanda : Fix for Bug 12950967
4472: CURSOR c_qp_limit_line_id(p_limit_id NUMBER) IS
4473: SELECT list_line_id
4474: FROM qp_limits
4475: WHERE limit_id = p_limit_id;
4476:
4477: CURSOR get_offer_info_frm_hdr(l_list_hdr_id NUMBER) IS
4478: SELECT hdr.orig_org_id, hdr.global_flag

Line 4847: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits for list_header_id : '|| l_limits_rec.list_header_id);

4843: END IF;
4844: END IF;
4845: */
4846:
4847: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits for list_header_id : '|| l_limits_rec.list_header_id);
4848:
4849: QP_Limits_PUB.Process_Limits
4850: ( p_init_msg_list => FND_API.g_true,
4851: p_api_version_number => 1.0,

Line 4849: QP_Limits_PUB.Process_Limits

4845: */
4846:
4847: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits for list_header_id : '|| l_limits_rec.list_header_id);
4848:
4849: QP_Limits_PUB.Process_Limits
4850: ( p_init_msg_list => FND_API.g_true,
4851: p_api_version_number => 1.0,
4852: p_commit => FND_API.g_false,
4853: x_return_status => x_return_status,

Line 4922: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits2 for list_header_id : '|| l_limits_rec.list_header_id);

4918: l_limits_rec.amount := p_modifier_list_rec.max_no_of_uses;
4919: END IF;
4920: END IF;
4921:
4922: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits2 for list_header_id : '|| l_limits_rec.list_header_id);
4923:
4924: QP_Limits_PUB.Process_Limits
4925: ( p_init_msg_list => FND_API.g_true,
4926: p_api_version_number => 1.0,

Line 4924: QP_Limits_PUB.Process_Limits

4920: END IF;
4921:
4922: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_qp_list_header before calling QP_Limits_PUB.Process_Limits2 for list_header_id : '|| l_limits_rec.list_header_id);
4923:
4924: QP_Limits_PUB.Process_Limits
4925: ( p_init_msg_list => FND_API.g_true,
4926: p_api_version_number => 1.0,
4927: p_commit => FND_API.g_false,
4928: x_return_status => x_return_status,

Line 8069: FROM qp_limits

8065: l_accr_amount_limit_id NUMBER;
8066:
8067: CURSOR cur_get_accrual_limit_id(p_limit_number NUMBER,p_list_line_id NUMBER) IS
8068: SELECT limit_id
8069: FROM qp_limits
8070: WHERE limit_number = p_limit_number
8071: AND list_line_id = p_list_line_id;
8072:
8073: CURSOR c_modifier_id(l_id NUMBER) IS

Line 9339: FROM qp_limits

9335:
9336: -- nepanda : Fix for Bug 12950967
9337: CURSOR c_header_limit_exists(p_qp_list_header_id NUMBER) IS
9338: SELECT COUNT(*)
9339: FROM qp_limits
9340: WHERE list_header_id = p_qp_list_header_id
9341: AND list_line_id = -1 ;
9342: l_header_limit_exists NUMBER ;
9343:

Line 11408: FROM qp_limits

11404:
11405:
11406: CURSOR cur_get_limit_id(p_list_line_id NUMBER) IS
11407: SELECT limit_id
11408: FROM qp_limits
11409: WHERE list_line_id = p_list_line_id
11410: AND limit_number = 3;
11411:
11412: