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.

[Home] [Help]

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 935: ozf_offer_pub.process_modifiers(p_init_msg_list => p_init_msg_list

931: END IF;
932:
933: IF l_pvt_fund_rec.accrual_phase = 'ACCRUAL' THEN --accrual offer
934:
935: ozf_offer_pub.process_modifiers(p_init_msg_list => p_init_msg_list
936: ,p_api_version => p_api_version
937: ,p_commit => p_commit
938: ,x_return_status => x_return_status
939: ,x_msg_count => x_msg_count

Line 959: ozf_offer_pub.process_vo(p_init_msg_list => p_init_msg_list

955:
956:
957: ELSIF l_pvt_fund_rec.accrual_phase = 'VOLUME' THEN --volume offer
958:
959: ozf_offer_pub.process_vo(p_init_msg_list => p_init_msg_list
960: ,p_api_version => p_api_version
961: ,p_commit => p_commit
962: ,x_return_status => x_return_status
963: ,x_msg_count => x_msg_count

Line 1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type

1141: ,x_return_status OUT NOCOPY VARCHAR2
1142: ,x_msg_count OUT NOCOPY NUMBER
1143: ,x_msg_data OUT NOCOPY VARCHAR2
1144: ,p_fund_rec IN fund_rec_type
1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

Line 1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type

1142: ,x_msg_count OUT NOCOPY NUMBER
1143: ,x_msg_data OUT NOCOPY VARCHAR2
1144: ,p_fund_rec IN fund_rec_type
1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

Line 1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type

1143: ,x_msg_data OUT NOCOPY VARCHAR2
1144: ,p_fund_rec IN fund_rec_type
1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

Line 1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type

1144: ,p_fund_rec IN fund_rec_type
1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1152: )

Line 1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type

1145: ,p_modifier_list_rec IN ozf_offer_pub.modifier_list_rec_type
1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1152: )
1153: IS

Line 1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type

1146: ,p_modifier_line_tbl IN ozf_offer_pub.modifier_line_tbl_type
1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1152: )
1153: IS
1154: l_api_name VARCHAR(30) := 'Update_Fund';

Line 1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type

1147: ,p_vo_pbh_tbl IN ozf_offer_pub.vo_disc_tbl_type
1148: ,p_vo_dis_tbl IN ozf_offer_pub.vo_disc_tbl_type
1149: ,p_vo_prod_tbl IN ozf_offer_pub.vo_prod_tbl_type
1150: ,p_qualifier_tbl IN ozf_offer_pub.qualifiers_tbl_type
1151: ,p_vo_mo_tbl IN ozf_offer_pub.vo_mo_tbl_type
1152: )
1153: IS
1154: l_api_name VARCHAR(30) := 'Update_Fund';
1155: l_fund_rec fund_rec_type := p_fund_rec;