APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_OFFER_PVT

Line 130: , p_qualifiers_rec IN OZF_OFFER_PVT.qualifiers_Rec_Type

126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129:
130: , p_qualifiers_rec IN OZF_OFFER_PVT.qualifiers_Rec_Type
131: )
132: IS
133: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
134: l_api_version_number CONSTANT NUMBER := 1.0;

Line 136: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;

132: IS
133: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
134: l_api_version_number CONSTANT NUMBER := 1.0;
135: l_api_name CONSTANT VARCHAR2(30) := 'create_vo_qualifier';
136: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;
137: l_qualifiers_rec OZF_OFFER_PVT.QUALIFIERS_REC_TYPE;
138: x_error_location NUMBER;
139: l_mo_id NUMBER;
140: l_Mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;

Line 137: l_qualifiers_rec OZF_OFFER_PVT.QUALIFIERS_REC_TYPE;

133: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
134: l_api_version_number CONSTANT NUMBER := 1.0;
135: l_api_name CONSTANT VARCHAR2(30) := 'create_vo_qualifier';
136: l_qualifiers_tbl OZF_OFFER_PVT.QUALIFIERS_TBL_TYPE;
137: l_qualifiers_rec OZF_OFFER_PVT.QUALIFIERS_REC_TYPE;
138: x_error_location NUMBER;
139: l_mo_id NUMBER;
140: l_Mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;
141:

Line 194: OZF_OFFER_PVT.process_market_qualifiers

190: -- if market optoin does not exist for the group, create the market option , get the market option id and then
191: -- create a market option-qualifier relation
192:
193: l_qualifiers_tbl(1).operation := 'CREATE';
194: OZF_OFFER_PVT.process_market_qualifiers
195: (
196: p_init_msg_list => p_init_msg_list
197: ,p_api_version => p_api_version_number
198: ,p_commit => p_commit

Line 379: , p_qualifiers_rec IN OZF_OFFER_PVT.qualifiers_Rec_Type

375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_msg_count OUT NOCOPY NUMBER
377: , x_msg_data OUT NOCOPY VARCHAR2
378:
379: , p_qualifiers_rec IN OZF_OFFER_PVT.qualifiers_Rec_Type
380: )
381: IS
382: l_api_name CONSTANT VARCHAR2(30) := 'update_vo_qualifier';
383: l_api_version_number CONSTANT NUMBER := 1.0;

Line 384: l_qualifiers_tbl OZF_OFFER_PVT.qualifiers_tbl_Type;

380: )
381: IS
382: l_api_name CONSTANT VARCHAR2(30) := 'update_vo_qualifier';
383: l_api_version_number CONSTANT NUMBER := 1.0;
384: l_qualifiers_tbl OZF_OFFER_PVT.qualifiers_tbl_Type;
385: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
386: x_error_location NUMBER;
387: l_group_number NUMBER := -5000;
388: l_operation VARCHAR2(30);

Line 456: OZF_OFFER_PVT.process_market_qualifiers

452:
453: l_qualifiers_tbl(1).operation := 'UPDATE';
454: -- update the qualifier
455: debug_message('Calling update');
456: OZF_OFFER_PVT.process_market_qualifiers
457: (
458: p_init_msg_list => p_init_msg_list
459: ,p_api_version => p_api_version_number
460: ,p_commit => p_commit

Line 687: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

683: WHERE qualifier_id = p_qualifier_id;
684: l_group_no c_group_no%ROWTYPE;
685: group_no NUMBER := 1000;
686:
687: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
688: l_qualifiers_tbl OZF_OFFER_PVT.qualifiers_TBL_Type;
689: x_error_location NUMBER;
690: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
691:

Line 688: l_qualifiers_tbl OZF_OFFER_PVT.qualifiers_TBL_Type;

684: l_group_no c_group_no%ROWTYPE;
685: group_no NUMBER := 1000;
686:
687: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
688: l_qualifiers_tbl OZF_OFFER_PVT.qualifiers_TBL_Type;
689: x_error_location NUMBER;
690: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
691:
692:

Line 745: OZF_OFFER_PVT.process_market_qualifiers

741: l_qualifiers_rec.qualifier_id := p_qualifier_id;
742: l_qualifiers_rec.operation := 'DELETE';
743: l_qualifiers_tbl(1) := l_qualifiers_rec;
744:
745: OZF_OFFER_PVT.process_market_qualifiers
746: (
747: p_init_msg_list => p_init_msg_list
748: ,p_api_version => p_api_version_number
749: ,p_commit => p_commit