DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on AMS_ACT_MARKET_SEGMENTS_PVT

Line 1662: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;

1658: IS
1659: l_api_name VARCHAR(30) := 'create_market_segment';
1660: l_mode VARCHAR2(6) := 'CREATE';
1661: l_mks_rec mks_rec_type := p_mks_rec;
1662: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;
1663: l_api_version NUMBER := p_api_version;
1664: l_init_msg_list VARCHAR2(100) := p_init_msg_list;
1665: l_validation_level NUMBER := p_validation_level;
1666: l_commit VARCHAR2(1) := p_commit;

Line 1689: ams_act_market_segments_pvt.create_market_segments(p_api_version => l_api_version

1685: l_seg_rec.segment_type := l_mks_rec.segment_type;
1686: l_seg_rec.object_version_number := l_mks_rec.object_version_number;
1687: l_seg_rec.exclude_flag := l_mks_rec.exclude_flag;
1688:
1689: ams_act_market_segments_pvt.create_market_segments(p_api_version => l_api_version
1690: ,p_init_msg_list => l_init_msg_list
1691: ,p_commit => l_commit
1692: ,p_validation_level => l_validation_level
1693: ,p_mks_rec => l_seg_rec

Line 1772: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;

1768: IS
1769: l_api_name VARCHAR(30) := 'update_market_segment';
1770: l_mode VARCHAR2(6) := 'UPDATE';
1771: l_mks_rec mks_rec_type := p_mks_rec;
1772: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;
1773: l_api_version NUMBER := p_api_version;
1774: l_init_msg_list VARCHAR2(100) := p_init_msg_list;
1775: l_validation_level NUMBER := p_validation_level;
1776: l_commit VARCHAR2(1) := p_commit;

Line 1823: ams_act_market_segments_pvt.update_market_segments(p_api_version => l_api_version

1819: l_seg_rec.market_segment_id := l_mks_rec.market_segment_id;
1820: l_seg_rec.object_version_number := l_mks_rec.object_version_number;
1821: l_seg_rec.exclude_flag := l_mks_rec.exclude_flag;
1822:
1823: ams_act_market_segments_pvt.update_market_segments(p_api_version => l_api_version
1824: ,p_init_msg_list => l_init_msg_list
1825: ,p_commit => l_commit
1826: ,p_validation_level => l_validation_level
1827: ,p_mks_rec => l_seg_rec

Line 1955: ams_act_market_segments_pvt.delete_market_segments(p_api_version => l_api_version

1951: RAISE fnd_api.g_exc_error;
1952: END IF;
1953:
1954: --delete market segment
1955: ams_act_market_segments_pvt.delete_market_segments(p_api_version => l_api_version
1956: ,p_init_msg_list => l_init_msg_list
1957: ,p_commit => l_commit
1958: ,p_act_mks_id => p_act_mks_id
1959: ,p_object_version => l_object_version

Line 2715: l_seg_rec AMS_ACT_MARKET_SEGMENTS_PVT.mks_rec_type;

2711: l_fund_id NUMBER := l_fund_rec.fund_id;
2712: l_error_location NUMBER;
2713:
2714: x_act_mks_id NUMBER;
2715: l_seg_rec AMS_ACT_MARKET_SEGMENTS_PVT.mks_rec_type;
2716: k NUMBER :=1;
2717:
2718: l_qualifier_id number;
2719: l_uom VARCHAR2(3);

Line 3602: AMS_ACT_MARKET_SEGMENTS_PVT.create_market_segments(

3598: l_seg_rec.arc_act_market_segment_used_by := 'FUND';
3599: l_seg_rec.segment_type := 'CUSTOMER';
3600: l_seg_rec.object_version_number := 1.0;
3601:
3602: AMS_ACT_MARKET_SEGMENTS_PVT.create_market_segments(
3603: p_api_version => l_api_version
3604: ,p_init_msg_list => l_init_msg_list
3605: ,p_commit => l_commit
3606: ,p_validation_level => l_validation_level

Line 3656: ams_act_market_segments_pvt.Init_Mks_Rec(l_seg_rec);

3652: IF l_fund_rec.fund_type = 'FIXED' THEN
3653: IF p_qualifier_tbl.COUNT > 0 THEN
3654: FOR i IN p_qualifier_tbl.FIRST..p_qualifier_tbl.LAST LOOP
3655:
3656: ams_act_market_segments_pvt.Init_Mks_Rec(l_seg_rec);
3657:
3658: l_seg_rec.market_segment_id := p_qualifier_tbl(i).qualifier_attr_value;
3659: l_seg_rec.act_market_segment_used_by_id := l_fund_rec.fund_id;
3660: l_seg_rec.arc_act_market_segment_used_by := 'FUND';

Line 3669: AMS_ACT_MARKET_SEGMENTS_PVT.update_market_segments(

3665: OPEN c_market_segment(l_seg_rec.act_market_segment_used_by_id);
3666: FETCH c_market_segment INTO l_seg_rec.activity_market_segment_id,l_seg_rec.object_version_number;
3667: CLOSE c_market_segment;
3668:
3669: AMS_ACT_MARKET_SEGMENTS_PVT.update_market_segments(
3670: p_api_version => l_api_version
3671: ,p_init_msg_list => l_init_msg_list
3672: ,p_commit => l_commit
3673: ,p_validation_level => l_validation_level