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.IGI_SLS_SECURITY_PKG dependencies on FND_PROFILE

Line 53: Fnd_Profile.Get('RESP_ID', l_resp_id);

49:
50: l_resp_id NUMBER;
51: BEGIN
52:
53: Fnd_Profile.Get('RESP_ID', l_resp_id);
54:
55: OPEN c_sch_name (l_resp_id);
56: FETCH c_sch_name INTO p_schema_name;
57: CLOSE c_sch_name;

Line 526: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

522: rt_c_get_sectab.table_name ||' updating igi_sls_secure_tables');
523:
524: UPDATE igi_sls_secure_tables
525: SET date_object_created = SYSDATE,
526: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
527: last_update_date = SYSDATE,
528: last_updated_by = to_number(fnd_profile.value('USER_ID'))
529: WHERE table_name = rt_c_get_sectab.table_name
530: AND owner = rt_c_get_sectab.owner;

Line 528: last_updated_by = to_number(fnd_profile.value('USER_ID'))

524: UPDATE igi_sls_secure_tables
525: SET date_object_created = SYSDATE,
526: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
527: last_update_date = SYSDATE,
528: last_updated_by = to_number(fnd_profile.value('USER_ID'))
529: WHERE table_name = rt_c_get_sectab.table_name
530: AND owner = rt_c_get_sectab.owner;
531:
532: l_date_security_applied := SYSDATE;

Line 723: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

719: ' for '|| rt_c_get_sectab.sls_table_name);
720:
721: UPDATE igi_sls_secure_tables
722: SET date_security_applied = l_date_security_applied,
723: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
724: last_update_date = SYSDATE,
725: last_updated_by = to_number(fnd_profile.value('USER_ID'))
726: WHERE table_name = rt_c_get_sectab.table_name
727: AND owner = rt_c_get_sectab.owner;

Line 725: last_updated_by = to_number(fnd_profile.value('USER_ID'))

721: UPDATE igi_sls_secure_tables
722: SET date_security_applied = l_date_security_applied,
723: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
724: last_update_date = SYSDATE,
725: last_updated_by = to_number(fnd_profile.value('USER_ID'))
726: WHERE table_name = rt_c_get_sectab.table_name
727: AND owner = rt_c_get_sectab.owner;
728:
729: -- Update the audit table only if the current row is

Line 1129: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1125: LOOP
1126: UPDATE igi_sls_allocations
1127: SET date_removed = rt_c_del_table.date_removed,
1128: date_disabled = Nvl(date_disabled, rt_c_del_table.date_removed),
1129: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1130: last_update_date = SYSDATE,
1131: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1132: WHERE sls_allocation = rt_c_del_table.table_name
1133: AND sls_allocation_type = 'T'

Line 1131: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1127: SET date_removed = rt_c_del_table.date_removed,
1128: date_disabled = Nvl(date_disabled, rt_c_del_table.date_removed),
1129: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1130: last_update_date = SYSDATE,
1131: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1132: WHERE sls_allocation = rt_c_del_table.table_name
1133: AND sls_allocation_type = 'T'
1134: AND date_removed IS NULL;
1135:

Line 1187: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1183: LOOP
1184: UPDATE igi_sls_allocations
1185: SET date_removed = rt_c_del_group.date_removed,
1186: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1187: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1188: last_update_date = SYSDATE,
1189: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1190: WHERE sls_group = rt_c_del_group.sls_group
1191: AND sls_group_type = rt_c_del_group.sls_group_type

Line 1189: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1185: SET date_removed = rt_c_del_group.date_removed,
1186: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1187: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1188: last_update_date = SYSDATE,
1189: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1190: WHERE sls_group = rt_c_del_group.sls_group
1191: AND sls_group_type = rt_c_del_group.sls_group_type
1192: AND date_removed IS NULL;
1193:

Line 1242: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1238: THEN
1239: UPDATE igi_sls_allocations
1240: SET date_removed = rt_c_del_group.date_removed,
1241: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1242: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1243: last_update_date = SYSDATE,
1244: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1245: WHERE sls_allocation = rt_c_del_group.sls_group
1246: AND sls_group_type = rt_c_del_group.sls_group_type

Line 1244: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1240: SET date_removed = rt_c_del_group.date_removed,
1241: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1242: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1243: last_update_date = SYSDATE,
1244: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1245: WHERE sls_allocation = rt_c_del_group.sls_group
1246: AND sls_group_type = rt_c_del_group.sls_group_type
1247: AND date_removed IS NULL;
1248:

Line 1345: delete from FND_PROFILE_OPTION_VALUES

1341: EXECUTE IMMEDIATE l_sql_stmt USING rt_c_del_alloc.sls_group;
1342:
1343: write_to_log (l_state_level, 'cleanup_data', 'After Exec. Immediate');
1344:
1345: delete from FND_PROFILE_OPTION_VALUES
1346: where PROFILE_OPTION_ID = (select profile_option_id from fnd_profile_options where
1347: profile_option_name = 'IGI_SLS_SECURITY_GROUP')
1348: and APPLICATION_ID = ( select application_id from fnd_application_vl where
1349: application_short_name = 'IGI' )

Line 1346: where PROFILE_OPTION_ID = (select profile_option_id from fnd_profile_options where

1342:
1343: write_to_log (l_state_level, 'cleanup_data', 'After Exec. Immediate');
1344:
1345: delete from FND_PROFILE_OPTION_VALUES
1346: where PROFILE_OPTION_ID = (select profile_option_id from fnd_profile_options where
1347: profile_option_name = 'IGI_SLS_SECURITY_GROUP')
1348: and APPLICATION_ID = ( select application_id from fnd_application_vl where
1349: application_short_name = 'IGI' )
1350: and profile_option_value = rt_c_del_alloc.sls_group ;

Line 1433: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1429: FOR rt_c_all_group IN c_all_group
1430: LOOP
1431: UPDATE igi_sls_groups
1432: SET date_security_applied = SYSDATE,
1433: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1434: last_update_date = SYSDATE,
1435: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1436: WHERE CURRENT OF c_all_group;
1437:

Line 1435: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1431: UPDATE igi_sls_groups
1432: SET date_security_applied = SYSDATE,
1433: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1434: last_update_date = SYSDATE,
1435: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1436: WHERE CURRENT OF c_all_group;
1437:
1438: -- Update the audit table only if the current row is
1439: -- enabled or disabled.

Line 1461: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1457: FOR rt_c_all_alloc IN c_all_alloc
1458: LOOP
1459: UPDATE igi_sls_allocations
1460: SET date_security_applied = SYSDATE,
1461: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1462: last_update_date = SYSDATE,
1463: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1464: WHERE CURRENT OF c_all_alloc;
1465:

Line 1463: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1459: UPDATE igi_sls_allocations
1460: SET date_security_applied = SYSDATE,
1461: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1462: last_update_date = SYSDATE,
1463: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1464: WHERE CURRENT OF c_all_alloc;
1465:
1466: -- Update the audit table only if the current row is
1467: -- enabled or disabled.

Line 1722: to_number(fnd_profile.value('USER_ID')),

1718: l_date_disabled,
1719: NULL,
1720: NULL,
1721: SYSDATE,
1722: to_number(fnd_profile.value('USER_ID')),
1723: to_number(fnd_profile.value('LOGIN_ID')),
1724: SYSDATE,
1725: to_number(fnd_profile.value('USER_ID')));
1726: END IF; -- record with the same allocation does not already exist.

Line 1723: to_number(fnd_profile.value('LOGIN_ID')),

1719: NULL,
1720: NULL,
1721: SYSDATE,
1722: to_number(fnd_profile.value('USER_ID')),
1723: to_number(fnd_profile.value('LOGIN_ID')),
1724: SYSDATE,
1725: to_number(fnd_profile.value('USER_ID')));
1726: END IF; -- record with the same allocation does not already exist.
1727:

Line 1725: to_number(fnd_profile.value('USER_ID')));

1721: SYSDATE,
1722: to_number(fnd_profile.value('USER_ID')),
1723: to_number(fnd_profile.value('LOGIN_ID')),
1724: SYSDATE,
1725: to_number(fnd_profile.value('USER_ID')));
1726: END IF; -- record with the same allocation does not already exist.
1727:
1728: END LOOP; -- rt_c_grp_alloc
1729:

Line 1737: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1733: UPDATE igi_sls_groups
1734: SET date_disabled = Nvl(date_disabled, l_sysdate),
1735: date_removed = SYSDATE,
1736: date_security_applied = NULL,
1737: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1738: last_update_date = SYSDATE,
1739: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1740: WHERE sls_group = rt_c_cons_recs.from_sls_security_group
1741: AND date_removed IS NULL;

Line 1739: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1735: date_removed = SYSDATE,
1736: date_security_applied = NULL,
1737: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1738: last_update_date = SYSDATE,
1739: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1740: WHERE sls_group = rt_c_cons_recs.from_sls_security_group
1741: AND date_removed IS NULL;
1742:
1743: -- Since the group is being marked for deletion, enter a record

Line 1777: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

1773: AND date_removed = l_sysdate;
1774:
1775: UPDATE igi_sls_consolidate_groups
1776: SET date_security_applied = SYSDATE,
1777: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1778: last_update_date = SYSDATE,
1779: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1780: WHERE date_security_applied IS NULL;
1781:

Line 1779: last_updated_by = to_number(fnd_profile.value('USER_ID'))

1775: UPDATE igi_sls_consolidate_groups
1776: SET date_security_applied = SYSDATE,
1777: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1778: last_update_date = SYSDATE,
1779: last_updated_by = to_number(fnd_profile.value('USER_ID'))
1780: WHERE date_security_applied IS NULL;
1781:
1782: COMMIT;
1783: