DBA Data[Home] [Help]

APPS.OZF_OFFER_PUB dependencies on OZF_OFFER_PVT

Line 46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
49: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
50: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
49: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
50: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
51:

Line 48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
49: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
50: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
51:
52: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS

Line 49: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;

45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
49: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
50: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
51:
52: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
53: SELECT offer_id, offer_type, custom_setup_id, offer_code, tier_level, object_version_number

Line 175: Ozf_Offer_Pvt.process_modifiers(

171: ELSE
172: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
173: END IF;
174:
175: Ozf_Offer_Pvt.process_modifiers(
176: p_init_msg_list => p_init_msg_list
177: ,p_api_version => p_api_version
178: ,p_commit => p_commit
179: ,x_return_status => x_return_status

Line 310: ozf_offer_pvt.process_exclusions(

306: END LOOP;
307: END IF;
308:
309: IF l_exclusion_tbl.COUNT > 0 THEN
310: ozf_offer_pvt.process_exclusions(
311: p_init_msg_list => p_init_msg_list
312: ,p_api_version => p_api_version
313: ,p_commit => p_commit
314: ,x_return_status => x_return_status

Line 897: Ozf_Offer_Pvt.process_modifiers(

893: END LOOP;
894: END IF;
895: END IF; -- end offer_type
896:
897: Ozf_Offer_Pvt.process_modifiers(
898: p_init_msg_list => p_init_msg_list
899: ,p_api_version => p_api_version
900: ,p_commit => p_commit
901: ,x_return_status => x_return_status

Line 1039: Ozf_Offer_Pvt.process_market_qualifiers(

1035: l_qualifiers_tbl(i).attribute14 := p_qualifier_tbl(i).attribute14;
1036: l_qualifiers_tbl(i).attribute15 := p_qualifier_tbl(i).attribute15;
1037: END LOOP;
1038:
1039: Ozf_Offer_Pvt.process_market_qualifiers(
1040: p_init_msg_list => p_init_msg_list
1041: ,p_api_version => p_api_version
1042: ,p_commit => p_commit
1043: ,x_return_status => x_return_status

Line 1128: Ozf_Offer_Pvt.process_modifiers(

1124: END IF;
1125: END LOOP;
1126: END IF;
1127: /*
1128: Ozf_Offer_Pvt.process_modifiers(
1129: p_init_msg_list => p_init_msg_list
1130: ,p_api_version => p_api_version
1131: ,p_commit => p_commit
1132: ,x_return_status => x_return_status

Line 1211: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1207:
1208: l_api_version CONSTANT NUMBER := 1.0;
1209: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1210:
1211: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1212: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1213: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1214: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1215: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 1212: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1208: l_api_version CONSTANT NUMBER := 1.0;
1209: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1210:
1211: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1212: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1213: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1214: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1215: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1216: l_vo_dis_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 1213: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;

1209: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1210:
1211: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1212: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1213: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1214: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1215: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1216: l_vo_dis_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1217: l_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

Line 1330: Ozf_Offer_Pvt.process_modifiers(

1326: ELSE
1327: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
1328: END IF;
1329:
1330: Ozf_Offer_Pvt.process_modifiers(
1331: p_init_msg_list => p_init_msg_list
1332: ,p_api_version => p_api_version
1333: ,p_commit => p_commit
1334: ,x_return_status => x_return_status

Line 1449: /* Ozf_Offer_Pvt.process_market_qualifiers(

1445: END IF;
1446: END IF;
1447: END LOOP;
1448:
1449: /* Ozf_Offer_Pvt.process_market_qualifiers(
1450: p_init_msg_list => p_init_msg_list
1451: ,p_api_version => p_api_version
1452: ,p_commit => p_commit
1453: ,x_return_status => x_return_status

Line 1820: Ozf_Offer_Pvt.process_modifiers(

1816: END IF;
1817: END LOOP;
1818: END IF; -- end market options
1819:
1820: Ozf_Offer_Pvt.process_modifiers(
1821: p_init_msg_list => p_init_msg_list
1822: ,p_api_version => p_api_version
1823: ,p_commit => p_commit
1824: ,x_return_status => x_return_status