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.AMS_DM_TARGET_PVT dependencies on AMS_DM_TARGETS_B

Line 63: SELECT AMS_DM_TARGETS_B_s.NEXTVAL

59: l_dummy NUMBER;
60: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := p_dm_target_rec;
61:
62: CURSOR c_id IS
63: SELECT AMS_DM_TARGETS_B_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1

Line 159: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Insert_Row)

155:
156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Insert_Row)
160: AMS_DM_TARGETS_B_PKG.Insert_Row(
161: px_target_id => l_dm_target_rec.target_id,
162: p_last_update_date => SYSDATE,
163: p_last_updated_by => G_USER_ID,

Line 160: AMS_DM_TARGETS_B_PKG.Insert_Row(

156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Insert_Row)
160: AMS_DM_TARGETS_B_PKG.Insert_Row(
161: px_target_id => l_dm_target_rec.target_id,
162: p_last_update_date => SYSDATE,
163: p_last_updated_by => G_USER_ID,
164: p_creation_date => SYSDATE,

Line 440: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Update_Row)

436: AMS_UTILITY_PVT.debug_message('p_description = ' || l_tar_dm_target_rec.description);
437: END IF;
438:
439: BEGIN
440: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Update_Row)
441: AMS_DM_TARGETS_B_PKG.Update_Row(
442: p_target_id => l_tar_dm_target_rec.target_id,
443: p_last_update_date => SYSDATE,
444: p_last_updated_by => G_USER_ID,

Line 441: AMS_DM_TARGETS_B_PKG.Update_Row(

437: END IF;
438:
439: BEGIN
440: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Update_Row)
441: AMS_DM_TARGETS_B_PKG.Update_Row(
442: p_target_id => l_tar_dm_target_rec.target_id,
443: p_last_update_date => SYSDATE,
444: p_last_updated_by => G_USER_ID,
445: p_creation_date => SYSDATE,

Line 660: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Delete_Row)

656:
657: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
658: END IF;
659:
660: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Delete_Row)
661: AMS_DM_TARGETS_B_PKG.Delete_Row(
662: p_TARGET_ID => p_TARGET_ID);
663:
664: /* obsoleted rosharma 11.5.10 for Audience data source uptake

Line 661: AMS_DM_TARGETS_B_PKG.Delete_Row(

657: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
658: END IF;
659:
660: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Delete_Row)
661: AMS_DM_TARGETS_B_PKG.Delete_Row(
662: p_TARGET_ID => p_TARGET_ID);
663:
664: /* obsoleted rosharma 11.5.10 for Audience data source uptake
665: -- After successfully deleteing the target, check if there are no more

Line 764: FROM AMS_DM_TARGETS_B

760: l_TARGET_ID NUMBER;
761:
762: CURSOR c_Dmtarget IS
763: SELECT TARGET_ID
764: FROM AMS_DM_TARGETS_B
765: WHERE TARGET_ID = p_TARGET_ID
766: AND object_version_number = p_object_version
767: FOR UPDATE NOWAIT;
768:

Line 912: 'AMS_DM_TARGETS_B',

908:
909: --Validate unique target_id
910: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
911: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
912: 'AMS_DM_TARGETS_B',
913: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||''''
914: );
915: ELSE
916: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 917: 'AMS_DM_TARGETS_B',

913: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||''''
914: );
915: ELSE
916: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
917: 'AMS_DM_TARGETS_B',
918: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||
919: ''' AND TARGET_ID <> ' || p_dm_target_rec.TARGET_ID
920: );
921: END IF;

Line 1560: UPDATE ams_dm_targets_b

1556: FROM ams_user_statuses_vl
1557: WHERE user_status_id = p_user_status_id;
1558:
1559: BEGIN
1560: UPDATE ams_dm_targets_b
1561: SET active_flag = 'N',
1562: last_update_date = SYSDATE,
1563: last_updated_by = FND_GLOBAL.user_id
1564: WHERE (data_source_id = p_data_source_id OR target_source_id = p_data_source_id)

Line 1585: from ams_dm_targets_b b

1581: a.status_date = SYSDATE
1582: WHERE a.status_code = 'AVAILABLE'
1583: AND (EXISTS
1584: (SELECT 1
1585: from ams_dm_targets_b b
1586: where b.target_id=a.target_id
1587: and b.data_source_id=p_data_source_id)
1588: OR EXISTS
1589: (SELECT 1

Line 1628: UPDATE ams_dm_targets_b a

1624: L_API_NAME CONSTANT VARCHAR2(30) := 'Handle_Data_Source_Enabling';
1625: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1626:
1627: BEGIN
1628: UPDATE ams_dm_targets_b a
1629: SET a.active_flag = 'Y',
1630: a.last_update_date = SYSDATE,
1631: a.last_updated_by = FND_GLOBAL.user_id
1632: WHERE (a.data_source_id = p_data_source_id OR a.target_source_id = p_data_source_id)

Line 1675: UPDATE ams_dm_targets_b a

1671: L_API_NAME CONSTANT VARCHAR2(30) := 'Handle_DS_Assoc_Enabling';
1672: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1673:
1674: BEGIN
1675: UPDATE ams_dm_targets_b a
1676: SET a.active_flag = 'Y',
1677: a.last_update_date = SYSDATE,
1678: a.last_updated_by = FND_GLOBAL.user_id
1679: WHERE (a.data_source_id = p_master_source_id AND a.target_source_id = p_sub_source_id)

Line 1738: UPDATE ams_dm_targets_b

1734: FROM ams_user_statuses_vl
1735: WHERE user_status_id = p_user_status_id;
1736:
1737: BEGIN
1738: UPDATE ams_dm_targets_b
1739: SET active_flag = 'N',
1740: last_update_date = SYSDATE,
1741: last_updated_by = FND_GLOBAL.user_id
1742: WHERE (data_source_id = p_master_source_id AND target_source_id = p_sub_source_id)

Line 1763: from ams_dm_targets_b b

1759: a.status_date = SYSDATE
1760: WHERE a.status_code = 'AVAILABLE'
1761: AND (EXISTS
1762: (SELECT 1
1763: from ams_dm_targets_b b
1764: where b.target_id=a.target_id
1765: and b.data_source_id=p_master_source_id)
1766: OR EXISTS
1767: (SELECT 1

Line 1773: WHERE target_id IN (SELECT target_id FROM ams_dm_targets_b WHERE data_source_id = p_master_source_id AND target_source_id <> p_sub_source_id)

1769: where c.target_id=a.target_id
1770: and c.data_source_id=p_sub_source_id));
1771:
1772: DELETE FROM ams_dm_target_sources
1773: WHERE target_id IN (SELECT target_id FROM ams_dm_targets_b WHERE data_source_id = p_master_source_id AND target_source_id <> p_sub_source_id)
1774: AND data_source_id = p_sub_source_id
1775: ;
1776:
1777: End Handle_DS_Assoc_Disabling;

Line 1789: SELECT active_flag from ams_dm_targets_b where target_id = p_tgt_id;

1785:
1786: l_target_status VARCHAR2(1);
1787:
1788: CURSOR c_target_status(p_tgt_id IN NUMBER) IS
1789: SELECT active_flag from ams_dm_targets_b where target_id = p_tgt_id;
1790:
1791: BEGIN
1792: x_is_enabled := FALSE;
1793: