APPS.OZF_FUNDS_PUB dependencies on AMS_ACT_MARKET_SEGMENTS

Line 1388: FROM ams_act_market_segments

1384: l_segment_id_exists NUMBER := NULL;
1385:
1386: CURSOR c_act_mkt_exists (p_activity_market_segment_id IN NUMBER) IS
1387: SELECT 1
1388: FROM ams_act_market_segments
1389: WHERE activity_market_segment_id = p_activity_market_segment_id;
1390:
1391: CURSOR c_segment_used_by_exists (p_segment_used_by_id IN NUMBER) IS
1392: SELECT 1

Line 1632: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;

1628: IS
1629: l_api_name VARCHAR(30) := 'create_market_segment';
1630: l_mode VARCHAR2(6) := 'CREATE';
1631: l_mks_rec mks_rec_type := p_mks_rec;
1632: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;
1633: l_api_version NUMBER := p_api_version;
1634: l_init_msg_list VARCHAR2(100) := p_init_msg_list;
1635: l_validation_level NUMBER := p_validation_level;
1636: l_commit VARCHAR2(1) := p_commit;

Line 1659: ams_act_market_segments_pvt.create_market_segments(p_api_version => l_api_version

1655: l_seg_rec.segment_type := l_mks_rec.segment_type;
1656: l_seg_rec.object_version_number := l_mks_rec.object_version_number;
1657: l_seg_rec.exclude_flag := l_mks_rec.exclude_flag;
1658:
1659: ams_act_market_segments_pvt.create_market_segments(p_api_version => l_api_version
1660: ,p_init_msg_list => l_init_msg_list
1661: ,p_commit => l_commit
1662: ,p_validation_level => l_validation_level
1663: ,p_mks_rec => l_seg_rec

Line 1742: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;

1738: IS
1739: l_api_name VARCHAR(30) := 'update_market_segment';
1740: l_mode VARCHAR2(6) := 'UPDATE';
1741: l_mks_rec mks_rec_type := p_mks_rec;
1742: l_seg_rec ams_act_market_segments_pvt.mks_rec_type;
1743: l_api_version NUMBER := p_api_version;
1744: l_init_msg_list VARCHAR2(100) := p_init_msg_list;
1745: l_validation_level NUMBER := p_validation_level;
1746: l_commit VARCHAR2(1) := p_commit;

Line 1756: FROM ams_act_market_segments

1752:
1753: CURSOR c_mkt_seg_details (p_act_mkt_seg_id IN NUMBER) IS
1754: SELECT act_market_segment_used_by_id, segment_type, market_segment_id,
1755: object_version_number, exclude_flag
1756: FROM ams_act_market_segments
1757: WHERE activity_market_segment_id = p_act_mkt_seg_id;
1758:
1759: BEGIN
1760:

Line 1793: ams_act_market_segments_pvt.update_market_segments(p_api_version => l_api_version

1789: l_seg_rec.market_segment_id := l_mks_rec.market_segment_id;
1790: l_seg_rec.object_version_number := l_mks_rec.object_version_number;
1791: l_seg_rec.exclude_flag := l_mks_rec.exclude_flag;
1792:
1793: ams_act_market_segments_pvt.update_market_segments(p_api_version => l_api_version
1794: ,p_init_msg_list => l_init_msg_list
1795: ,p_commit => l_commit
1796: ,p_validation_level => l_validation_level
1797: ,p_mks_rec => l_seg_rec

Line 1894: FROM ams_act_market_segments

1890: l_object_version NUMBER := NULL;
1891:
1892: CURSOR c_valid_act_mks_id IS
1893: SELECT object_version_number
1894: FROM ams_act_market_segments
1895: WHERE activity_market_segment_id = p_act_mks_id;
1896:
1897: BEGIN
1898:

Line 1925: ams_act_market_segments_pvt.delete_market_segments(p_api_version => l_api_version

1921: RAISE fnd_api.g_exc_error;
1922: END IF;
1923:
1924: --delete market segment
1925: ams_act_market_segments_pvt.delete_market_segments(p_api_version => l_api_version
1926: ,p_init_msg_list => l_init_msg_list
1927: ,p_commit => l_commit
1928: ,p_act_mks_id => p_act_mks_id
1929: ,p_object_version => l_object_version