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_PUB

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 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 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 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,