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 801: OZF_OFFER_PVT.process_modifiers

797:
798: END LOOP;
799:
800: -- call api to create new header
801: OZF_OFFER_PVT.process_modifiers
802: (
803: p_init_msg_list => FND_API.G_FALSE
804: ,p_api_version => 1.0
805: ,p_commit => FND_API.G_FALSE

Line 1550: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1546: l_src_list_header_id NUMBER;
1547: l_new_list_header_id NUMBER;
1548: l_index1 NUMBER := 0;
1549: l_index2 NUMBER := 0;
1550: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1551:
1552: l_return_status VARCHAR2(1);
1553:
1554: l_errnum NUMBER;

Line 1690: l_qualifier_tbl ozf_offer_pvt.qualifiers_tbl_type;

1686: ,start_date_active
1687: ,end_date_active
1688: FROM qp_qualifiers
1689: WHERE list_header_id = p_source_object_id;
1690: l_qualifier_tbl ozf_offer_pvt.qualifiers_tbl_type;
1691:
1692: CURSOR c_adv_options IS
1693: SELECT modifier_level_code
1694: ,pricing_phase_id

Line 1701: l_adv_options_rec Ozf_Offer_Pvt.Advanced_Option_Rec_Type;

1697: ,pricing_group_sequence
1698: ,print_on_invoice_flag
1699: FROM qp_list_lines
1700: WHERE list_header_id = p_source_object_id;
1701: l_adv_options_rec Ozf_Offer_Pvt.Advanced_Option_Rec_Type;
1702:
1703: -- bug 3747303
1704: CURSOR c_vol_off_discount IS
1705: SELECT discount_type_code, discount

Line 2667: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list => p_init_msg_list

2663: l_qualifier_tbl(l_index2).operation := 'CREATE';
2664: END LOOP;
2665:
2666: IF l_index2 > 0 THEN -- if no market elig l_index2=0
2667: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list => p_init_msg_list
2668: ,p_api_version => p_api_version
2669: ,p_commit => p_commit
2670: ,x_return_status => x_return_status
2671: ,x_msg_count => x_msg_count