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

Line 779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

775: ,p_fund_rec IN fund_rec_type
776: ,x_fund_id OUT NOCOPY NUMBER
777: )
778: IS
779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;

Line 780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;

776: ,x_fund_id OUT NOCOPY NUMBER
777: )
778: IS
779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

Line 781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;

777: )
778: IS
779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

Line 782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;

778: IS
779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
786:

Line 783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;

779: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
786:
787: BEGIN

Line 784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

780: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
786:
787: BEGIN
788:

Line 785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

781: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
782: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
783: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
784: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
785: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
786:
787: BEGIN
788:
789: create_fund(p_api_version => p_api_version

Line 829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type

825: ,x_return_status OUT NOCOPY VARCHAR2
826: ,x_msg_count OUT NOCOPY NUMBER
827: ,x_msg_data OUT NOCOPY VARCHAR2
828: ,p_fund_rec IN fund_rec_type
829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

Line 830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type

826: ,x_msg_count OUT NOCOPY NUMBER
827: ,x_msg_data OUT NOCOPY VARCHAR2
828: ,p_fund_rec IN fund_rec_type
829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

Line 831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type

827: ,x_msg_data OUT NOCOPY VARCHAR2
828: ,p_fund_rec IN fund_rec_type
829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

Line 832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type

828: ,p_fund_rec IN fund_rec_type
829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
836: ,x_fund_id OUT NOCOPY NUMBER

Line 833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

829: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
836: ,x_fund_id OUT NOCOPY NUMBER
837: )

Line 834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

830: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
836: ,x_fund_id OUT NOCOPY NUMBER
837: )
838: IS

Line 835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

831: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
832: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
833: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
834: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
835: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
836: ,x_fund_id OUT NOCOPY NUMBER
837: )
838: IS
839: l_api_name VARCHAR(30) := 'Create_Fund';

Line 845: l_budget_tbl ozf_offer_pub.budget_tbl_type;

841: l_pvt_fund_rec OZF_Funds_PVT.fund_rec_type;
842: l_qp_list_header_id NUMBER;
843: l_error_location NUMBER;
844: l_mode VARCHAR2(6) := 'CREATE';
845: l_budget_tbl ozf_offer_pub.budget_tbl_type;
846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

Line 846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;

842: l_qp_list_header_id NUMBER;
843: l_error_location NUMBER;
844: l_mode VARCHAR2(6) := 'CREATE';
845: l_budget_tbl ozf_offer_pub.budget_tbl_type;
846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

Line 847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;

843: l_error_location NUMBER;
844: l_mode VARCHAR2(6) := 'CREATE';
845: l_budget_tbl ozf_offer_pub.budget_tbl_type;
846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

Line 848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

844: l_mode VARCHAR2(6) := 'CREATE';
845: l_budget_tbl ozf_offer_pub.budget_tbl_type;
846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;

Line 849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

845: l_budget_tbl ozf_offer_pub.budget_tbl_type;
846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;
853:

Line 850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

846: l_act_product_tbl ozf_offer_pub.act_product_tbl_type;
847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;
853:
854: CURSOR c_list_header_id (p_fund_id IN NUMBER) IS

Line 851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

847: l_discount_tbl ozf_offer_pub.discount_line_tbl_type;
848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;
853:
854: CURSOR c_list_header_id (p_fund_id IN NUMBER) IS
855: SELECT plan_id

Line 852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;

848: l_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
849: l_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
850: l_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
851: l_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;
853:
854: CURSOR c_list_header_id (p_fund_id IN NUMBER) IS
855: SELECT plan_id
856: FROM ozf_funds_all_b

Line 963: ozf_offer_pub.process_modifiers(p_init_msg_list => p_init_msg_list

959: END IF;
960:
961: IF l_pvt_fund_rec.accrual_phase = 'ACCRUAL' THEN --accrual offer
962:
963: ozf_offer_pub.process_modifiers(p_init_msg_list => p_init_msg_list
964: ,p_api_version => p_api_version
965: ,p_commit => p_commit
966: ,x_return_status => x_return_status
967: ,x_msg_count => x_msg_count

Line 987: ozf_offer_pub.process_vo(p_init_msg_list => p_init_msg_list

983:
984:
985: ELSIF l_pvt_fund_rec.accrual_phase = 'VOLUME' THEN --volume offer
986:
987: ozf_offer_pub.process_vo(p_init_msg_list => p_init_msg_list
988: ,p_api_version => p_api_version
989: ,p_commit => p_commit
990: ,x_return_status => x_return_status
991: ,x_msg_count => x_msg_count

Line 1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type

1169: ,x_return_status OUT NOCOPY VARCHAR2
1170: ,x_msg_count OUT NOCOPY NUMBER
1171: ,x_msg_data OUT NOCOPY VARCHAR2
1172: ,p_fund_rec IN fund_rec_type
1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

Line 1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type

1170: ,x_msg_count OUT NOCOPY NUMBER
1171: ,x_msg_data OUT NOCOPY VARCHAR2
1172: ,p_fund_rec IN fund_rec_type
1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

Line 1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type

1171: ,x_msg_data OUT NOCOPY VARCHAR2
1172: ,p_fund_rec IN fund_rec_type
1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

Line 1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type

1172: ,p_fund_rec IN fund_rec_type
1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1180: )

Line 1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

1173: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1180: )
1181: IS

Line 1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

1174: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1180: )
1181: IS
1182: l_api_name VARCHAR(30) := 'Update_Fund';

Line 1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

1175: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1176: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1177: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1178: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1179: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1180: )
1181: IS
1182: l_api_name VARCHAR(30) := 'Update_Fund';
1183: l_fund_rec fund_rec_type := p_fund_rec;

Line 2675: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type

2671: ,x_msg_count OUT NOCOPY NUMBER
2672: ,x_msg_data OUT NOCOPY VARCHAR2
2673: ,p_source IN VARCHAR2 := 'SIEBEL'
2674: ,p_fund_rec IN fund_rec_type
2675: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
2676: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
2677: ,x_fund_id OUT NOCOPY NUMBER
2678: ,x_msg_tbl OUT NOCOPY OZF_Utility_PVT.ozf_msg_tbl_type
2679: ,x_line_tbl OUT NOCOPY ozf_offer_pub.list_line_tbl_type

Line 2676: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

2672: ,x_msg_data OUT NOCOPY VARCHAR2
2673: ,p_source IN VARCHAR2 := 'SIEBEL'
2674: ,p_fund_rec IN fund_rec_type
2675: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
2676: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
2677: ,x_fund_id OUT NOCOPY NUMBER
2678: ,x_msg_tbl OUT NOCOPY OZF_Utility_PVT.ozf_msg_tbl_type
2679: ,x_line_tbl OUT NOCOPY ozf_offer_pub.list_line_tbl_type
2680: ) IS

Line 2679: ,x_line_tbl OUT NOCOPY ozf_offer_pub.list_line_tbl_type

2675: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
2676: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
2677: ,x_fund_id OUT NOCOPY NUMBER
2678: ,x_msg_tbl OUT NOCOPY OZF_Utility_PVT.ozf_msg_tbl_type
2679: ,x_line_tbl OUT NOCOPY ozf_offer_pub.list_line_tbl_type
2680: ) IS
2681:
2682: l_api_version CONSTANT NUMBER := 1.0;
2683: l_api_name VARCHAR(30) := 'process_fund_from_adapter';

Line 2696: l_modifier_list_rec OZF_OFFER_PUB.modifier_list_rec_type;

2692: l_pvt_fund_rec OZF_FUNDS_PVT.fund_rec_type;
2693: l_pvt_fund_rec2 OZF_FUNDS_PVT.fund_rec_type;
2694: l_pvt_fund_rec3 OZF_FUNDS_PVT.fund_rec_type;
2695:
2696: l_modifier_list_rec OZF_OFFER_PUB.modifier_list_rec_type;
2697: l_offer_hdr_rec OZF_OFFER_PVT.modifier_list_rec_type;
2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;

Line 2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;

2694: l_pvt_fund_rec3 OZF_FUNDS_PVT.fund_rec_type;
2695:
2696: l_modifier_list_rec OZF_OFFER_PUB.modifier_list_rec_type;
2697: l_offer_hdr_rec OZF_OFFER_PVT.modifier_list_rec_type;
2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;

Line 2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;

2695:
2696: l_modifier_list_rec OZF_OFFER_PUB.modifier_list_rec_type;
2697: l_offer_hdr_rec OZF_OFFER_PVT.modifier_list_rec_type;
2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;

Line 2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;

2696: l_modifier_list_rec OZF_OFFER_PUB.modifier_list_rec_type;
2697: l_offer_hdr_rec OZF_OFFER_PVT.modifier_list_rec_type;
2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;

Line 2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;

2697: l_offer_hdr_rec OZF_OFFER_PVT.modifier_list_rec_type;
2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;

Line 2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;

2698: l_budget_tbl OZF_OFFER_PUB.budget_tbl_type;
2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;
2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;

Line 2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;

2699: l_act_product_tbl OZF_OFFER_PUB.act_product_tbl_type;
2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;
2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;
2707:

Line 2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;

2700: l_discount_tbl OZF_OFFER_PUB.discount_line_tbl_type;
2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;
2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;
2707:
2708: l_qp_list_header_id NUMBER;

Line 2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;

2701: l_excl_tbl OZF_OFFER_PUB.excl_rec_tbl_type;
2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;
2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;
2707:
2708: l_qp_list_header_id NUMBER;
2709: l_mode VARCHAR2(6);

Line 2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;

2702: l_offer_tier_tbl OZF_OFFER_PUB.offer_tier_tbl_type;
2703: l_prod_tbl OZF_OFFER_PUB.prod_rec_tbl_type;
2704: l_na_qualifier_tbl OZF_OFFER_PUB.na_qualifier_tbl_type;
2705: l_modifier_line_tbl OZF_OFFER_PUB.modifier_line_tbl_type ;
2706: l_qualifier_tbl OZF_OFFER_PUB.qualifiers_tbl_type ;
2707:
2708: l_qp_list_header_id NUMBER;
2709: l_mode VARCHAR2(6);
2710:

Line 3535: OZF_OFFER_PUB.process_modifiers(p_init_msg_list => p_init_msg_list

3531: END IF;
3532: RAISE fnd_api.g_exc_error;
3533: END IF;
3534:
3535: OZF_OFFER_PUB.process_modifiers(p_init_msg_list => p_init_msg_list
3536: ,p_api_version => l_api_version
3537: ,p_commit => p_commit
3538: ,x_return_status => l_return_status
3539: ,x_msg_count => x_msg_count

Line 3834: OZF_OFFER_PUB.process_modifiers(p_init_msg_list => p_init_msg_list

3830: OPEN c_old_list_lines(l_qp_list_header_id);
3831: FETCH c_old_list_lines BULK COLLECT INTO l_list_line_tbl_type;
3832: CLOSE c_old_list_lines;
3833:
3834: OZF_OFFER_PUB.process_modifiers(p_init_msg_list => p_init_msg_list
3835: ,p_api_version => p_api_version
3836: ,p_commit => p_commit
3837: ,x_return_status => x_return_status
3838: ,x_msg_count => x_msg_count