APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 891: l_mktelig_rec ams_act_market_segments_pvt.mks_rec_type;

887: l_errcode VARCHAR2(30);
888: l_errmsg VARCHAR2(4000);
889: l_access_exists NUMBER;
890: l_access_rec ams_access_pvt.access_rec_type;
891: l_mktelig_rec ams_act_market_segments_pvt.mks_rec_type;
892: l_segments_rec ams_act_market_segments_pvt.mks_rec_type;
893: l_terr_resource_id NUMBER;
894: l_terr_resource_type jtf_terr_rsc_all.resource_type%TYPE;
895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;

Line 892: l_segments_rec ams_act_market_segments_pvt.mks_rec_type;

888: l_errmsg VARCHAR2(4000);
889: l_access_exists NUMBER;
890: l_access_rec ams_access_pvt.access_rec_type;
891: l_mktelig_rec ams_act_market_segments_pvt.mks_rec_type;
892: l_segments_rec ams_act_market_segments_pvt.mks_rec_type;
893: l_terr_resource_id NUMBER;
894: l_terr_resource_type jtf_terr_rsc_all.resource_type%TYPE;
895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;
896:

Line 919: FROM ams_act_market_segments

915: AND jtra.terr_id = p_terr_id;
916:
917: CURSOR c_check_marketelig_unique(p_market_id NUMBER, p_fund_id NUMBER) IS
918: SELECT 1
919: FROM ams_act_market_segments
920: WHERE arc_act_market_segment_used_by = 'FUND'
921: AND act_market_segment_used_by_id = p_fund_id
922: AND market_segment_id = p_market_id
923: AND segment_type = 'TERRITORY';

Line 927: FROM ams_act_market_segments seg

923: AND segment_type = 'TERRITORY';
924:
925: CURSOR c_segments_cur(p_fund_id NUMBER, p_hierarchy_id NUMBER) IS
926: SELECT *
927: FROM ams_act_market_segments seg
928: WHERE arc_act_market_segment_used_by = 'FUND'
929: AND act_market_segment_used_by_id = p_fund_id
930: AND (segment_type <> 'TERRITORY'
931: OR (segment_type = 'TERRITORY'

Line 1112: ams_act_market_segments_pvt.create_market_segments (

1108: l_segments_rec.attribute15 := segments_rec.attribute15;
1109: l_segments_rec.segment_type := segments_rec.segment_type;
1110: l_segments_rec.exclude_flag := segments_rec.exclude_flag;
1111: l_segments_rec.group_code := segments_rec.group_code;
1112: ams_act_market_segments_pvt.create_market_segments (
1113: p_api_version => p_api_version
1114: , p_init_msg_list => fnd_api.g_true
1115: , p_commit => fnd_api.g_false
1116: , p_validation_level => fnd_api.g_valid_level_full

Line 1161: ams_act_market_segments_pvt.create_market_segments(

1157: l_mktelig_rec.act_market_segment_used_by_id := l_new_fund_id;
1158: l_mktelig_rec.segment_type := 'TERRITORY';
1159: l_mktelig_rec.exclude_flag := 'N';
1160: l_mktelig_rec.group_code := 'TERRITORY' || p_fund_rec.node_id;
1161: ams_act_market_segments_pvt.create_market_segments(
1162: p_api_version => p_api_version
1163: , p_init_msg_list => fnd_api.g_true
1164: , p_commit => fnd_api.g_false
1165: , p_validation_level => fnd_api.g_valid_level_full