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 2515: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type,

2511:
2512: --nirprasa
2513: PROCEDURE populate_limits_rec(
2514: p_limit_type IN VARCHAR2,
2515: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type,
2516: p_limit_exceed_action_code IN VARCHAR2 DEFAULT NULL) IS
2517: BEGIN
2518:
2519: IF p_limit_exceed_action_code IS NOT NULL AND p_limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN

Line 2582: FROM qp_limits

2578: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2579:
2580: CURSOR cur_does_limit_exist(p_limit_number NUMBER) IS
2581: SELECT count(limit_id)
2582: FROM qp_limits
2583: WHERE list_line_id = p_list_line_id
2584: AND limit_number = p_limit_number;
2585:
2586: l_limit_exists NUMBER;

Line 2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

2585:
2586: l_limit_exists NUMBER;
2587: l_limit_number NUMBER;
2588:
2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

Line 2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

2586: l_limit_exists NUMBER;
2587: l_limit_number NUMBER;
2588:
2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

2587: l_limit_number NUMBER;
2588:
2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

Line 2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

2588:
2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2596:

Line 2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

2589: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2596:
2597: BEGIN

Line 2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

2590: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2596:
2597: BEGIN
2598: x_return_status := fnd_api.g_ret_sts_success;

Line 2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

2591: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
2592: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
2593: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
2594: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
2595: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
2596:
2597: BEGIN
2598: x_return_status := fnd_api.g_ret_sts_success;
2599:

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

2640: l_limits_rec.amount := p_limit_amount;
2641: END IF;
2642:
2643: -- as per suggetsion from Renuka and Karan for error message
2644: -- ORA-01400: cannot insert NULL into ("QP"."QP_LIMITS"."AMOUNT") in Package QP_Limits_Util Procedure
2645:
2646: IF l_limits_rec.amount IS NOT NULL AND
2647: l_limits_rec.amount <> FND_API.G_MISS_NUM THEN
2648:

Line 2649: QP_Limits_PUB.Process_Limits

2645:
2646: IF l_limits_rec.amount IS NOT NULL AND
2647: l_limits_rec.amount <> FND_API.G_MISS_NUM THEN
2648:
2649: QP_Limits_PUB.Process_Limits
2650: ( p_init_msg_list => FND_API.g_true,
2651: p_api_version_number => 1.0,
2652: p_commit => FND_API.g_false,
2653: x_return_status => x_return_status,

Line 4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

Line 4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

Line 4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4247:

Line 4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4247:
4248: l_uk_flag VARCHAR2(1);

Line 4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4247:
4248: l_uk_flag VARCHAR2(1);
4249:

Line 4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

4242: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
4243: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
4244: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
4245: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
4246: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
4247:
4248: l_uk_flag VARCHAR2(1);
4249:
4250:

Line 4473: QP_Limits_PUB.Process_Limits

4469: END IF;
4470: END IF;
4471:
4472:
4473: QP_Limits_PUB.Process_Limits
4474: ( p_init_msg_list => FND_API.g_true,
4475: p_api_version_number => 1.0,
4476: p_commit => FND_API.g_false,
4477: x_return_status => x_return_status,

Line 4546: QP_Limits_PUB.Process_Limits

4542: l_limits_rec.amount := p_modifier_list_rec.max_no_of_uses;
4543: END IF;
4544: END IF;
4545:
4546: QP_Limits_PUB.Process_Limits
4547: ( p_init_msg_list => FND_API.g_true,
4548: p_api_version_number => 1.0,
4549: p_commit => FND_API.g_false,
4550: x_return_status => x_return_status,

Line 7535: FROM qp_limits

7531: l_accr_amount_limit_id NUMBER;
7532:
7533: CURSOR cur_get_accrual_limit_id(p_limit_number NUMBER,p_list_line_id NUMBER) IS
7534: SELECT limit_id
7535: FROM qp_limits
7536: WHERE limit_number = p_limit_number
7537: AND list_line_id = p_list_line_id;
7538:
7539: CURSOR c_modifier_id(l_id NUMBER) IS

Line 10811: FROM qp_limits

10807:
10808:
10809: CURSOR cur_get_limit_id(p_list_line_id NUMBER) IS
10810: SELECT limit_id
10811: FROM qp_limits
10812: WHERE list_line_id = p_list_line_id
10813: AND limit_number = 3;
10814:
10815: BEGIN