DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on OZF_OFFER_PVT

Line 230: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;

226: , attribute15
227: FROM qp_qualifiers
228: WHERE list_header_id = cp_listHeaderId;
229:
230: l_qualifiers_rec OZF_OFFER_PVT.qualifiers_Rec_Type;
231: l_api_version_number CONSTANT NUMBER := 1.0;
232: l_api_name CONSTANT VARCHAR2(30) := 'copy_vo_qualifiers';
233: BEGIN
234: -- initialize

Line 649: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type ;

645: , p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
646: , p_custom_setup_id IN NUMBER
647: )
648: IS
649: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type ;
650: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE ;
651: l_listHeaderId NUMBER;
652: l_errLoc NUMBER;
653: l_api_version_number CONSTANT NUMBER := 1.0;

Line 650: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE ;

646: , p_custom_setup_id IN NUMBER
647: )
648: IS
649: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type ;
650: l_modifier_line_tbl OZF_OFFER_PVT.MODIFIER_LINE_TBL_TYPE ;
651: l_listHeaderId NUMBER;
652: l_errLoc NUMBER;
653: l_api_version_number CONSTANT NUMBER := 1.0;
654: l_api_name CONSTANT VARCHAR2(30) := 'copy_vo_header';

Line 828: OZF_OFFER_PVT.process_modifiers

824:
825: END LOOP;
826:
827: -- call api to create new header
828: OZF_OFFER_PVT.process_modifiers
829: (
830: p_init_msg_list => FND_API.G_FALSE
831: ,p_api_version => 1.0
832: ,p_commit => FND_API.G_FALSE

Line 1577: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1573: l_src_list_header_id NUMBER;
1574: l_new_list_header_id NUMBER;
1575: l_index1 NUMBER := 0;
1576: l_index2 NUMBER := 0;
1577: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1578:
1579: l_return_status VARCHAR2(1);
1580:
1581: l_errnum NUMBER;

Line 1722: l_qualifier_tbl ozf_offer_pvt.qualifiers_tbl_type;

1718: ,start_date_active
1719: ,end_date_active
1720: FROM qp_qualifiers
1721: WHERE list_header_id = p_source_object_id;
1722: l_qualifier_tbl ozf_offer_pvt.qualifiers_tbl_type;
1723:
1724: CURSOR c_adv_options IS
1725: SELECT modifier_level_code
1726: ,pricing_phase_id

Line 1733: l_adv_options_rec Ozf_Offer_Pvt.Advanced_Option_Rec_Type;

1729: ,pricing_group_sequence
1730: ,print_on_invoice_flag
1731: FROM qp_list_lines
1732: WHERE list_header_id = p_source_object_id;
1733: l_adv_options_rec Ozf_Offer_Pvt.Advanced_Option_Rec_Type;
1734:
1735: -- bug 3747303
1736: CURSOR c_vol_off_discount IS
1737: SELECT discount_type_code, discount

Line 2736: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list => p_init_msg_list

2732: l_qualifier_tbl(l_index2).operation := 'CREATE';
2733: END LOOP;
2734:
2735: IF l_index2 > 0 THEN -- if no market elig l_index2=0
2736: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list => p_init_msg_list
2737: ,p_api_version => p_api_version
2738: ,p_commit => p_commit
2739: ,x_return_status => x_return_status
2740: ,x_msg_count => x_msg_count