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.PV_OFFER_PUB dependencies on OZF_OFFER_PUB

Line 88: lp_budget_tbl ozf_offer_pub.budget_tbl_type;

84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2
86: )
87: IS
88: lp_budget_tbl ozf_offer_pub.budget_tbl_type;
89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;

Line 89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;

85: x_msg_data OUT NOCOPY VARCHAR2
86: )
87: IS
88: lp_budget_tbl ozf_offer_pub.budget_tbl_type;
89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

Line 90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

86: )
87: IS
88: lp_budget_tbl ozf_offer_pub.budget_tbl_type;
89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;

Line 92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;

88: lp_budget_tbl ozf_offer_pub.budget_tbl_type;
89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

Line 93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

89: lp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

Line 94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;

90: lp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:

Line 95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

91:
92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:
99:

Line 96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

92: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:
99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

Line 97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

93: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
94: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
95: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:
99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

Line 100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

96: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:
99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
102: l_budget_tbl ozf_offer_pub.budget_tbl_type;
103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

Line 101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

97: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
98:
99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
102: l_budget_tbl ozf_offer_pub.budget_tbl_type;
103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
105:

Line 102: l_budget_tbl ozf_offer_pub.budget_tbl_type;

98:
99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
102: l_budget_tbl ozf_offer_pub.budget_tbl_type;
103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
105:
106: l_profile_value VARCHAR2(50);

Line 103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;

99:
100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
102: l_budget_tbl ozf_offer_pub.budget_tbl_type;
103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
105:
106: l_profile_value VARCHAR2(50);
107:

Line 104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

100: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
101: l_empty_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
102: l_budget_tbl ozf_offer_pub.budget_tbl_type;
103: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
104: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
105:
106: l_profile_value VARCHAR2(50);
107:
108: -- ----------------------------------------------------------------

Line 112: l_del_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

108: -- ----------------------------------------------------------------
109: -- Used for deleting offer-related items.
110: -- ----------------------------------------------------------------
111: l_qp_list_header_id NUMBER;
112: l_del_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
113: l_del_budget_tbl ozf_offer_pub.budget_tbl_type;
114: l_del_discount_tbl ozf_offer_pub.discount_line_tbl_type;
115: l_del_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
116: i NUMBER;

Line 113: l_del_budget_tbl ozf_offer_pub.budget_tbl_type;

109: -- Used for deleting offer-related items.
110: -- ----------------------------------------------------------------
111: l_qp_list_header_id NUMBER;
112: l_del_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
113: l_del_budget_tbl ozf_offer_pub.budget_tbl_type;
114: l_del_discount_tbl ozf_offer_pub.discount_line_tbl_type;
115: l_del_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
116: i NUMBER;
117:

Line 114: l_del_discount_tbl ozf_offer_pub.discount_line_tbl_type;

110: -- ----------------------------------------------------------------
111: l_qp_list_header_id NUMBER;
112: l_del_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
113: l_del_budget_tbl ozf_offer_pub.budget_tbl_type;
114: l_del_discount_tbl ozf_offer_pub.discount_line_tbl_type;
115: l_del_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
116: i NUMBER;
117:
118: ----------------------------

Line 115: l_del_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

111: l_qp_list_header_id NUMBER;
112: l_del_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
113: l_del_budget_tbl ozf_offer_pub.budget_tbl_type;
114: l_del_discount_tbl ozf_offer_pub.discount_line_tbl_type;
115: l_del_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
116: i NUMBER;
117:
118: ----------------------------
119: --used for bug# 3738487

Line 263: ozf_offer_pub.process_modifiers(

259: -- Delete Offer-related Items
260: -- ----------------------------------------------------------
261: Debug('Deleting offer-related items..........................');
262:
263: ozf_offer_pub.process_modifiers(
264: p_init_msg_list => FND_API.g_false,
265: p_api_version => 1.0,
266: p_commit => FND_API.g_false,
267: x_return_status => x_return_status,

Line 417: ozf_offer_pub.process_modifiers(

413: ELSE
414: Debug('Re-create offer-related items.............................');
415: END IF;
416:
417: ozf_offer_pub.process_modifiers(
418: p_init_msg_list => FND_API.g_false,
419: p_api_version => 1.0,
420: p_commit => FND_API.g_false,
421: x_return_status => x_return_status,

Line 492: ozf_offer_pub.process_modifiers(

488:
489: Debug('l_modifier_list_rec.QP_LIST_HEADER_ID = ' ||
490: l_modifier_list_rec.QP_LIST_HEADER_ID);
491:
492: ozf_offer_pub.process_modifiers(
493: p_init_msg_list => FND_API.g_false,
494: p_api_version => 1.0,
495: p_commit => FND_API.g_false,
496: x_return_status => x_return_status,