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_SECURE_TABLES_PKG dependencies on IGI_SLS_SECURE_TABLES

Line 1: PACKAGE BODY IGI_SLS_SECURE_TABLES_PKG AS

1: PACKAGE BODY IGI_SLS_SECURE_TABLES_PKG AS
2: /* $Header: igislscb.pls 120.3.12000000.1 2007/09/03 17:22:10 vspuli ship $ */
3:
4:
5: -- This procedure is called from the ON-DELETE trigger of form IGISLSST.

Line 7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE

3:
4:
5: -- This procedure is called from the ON-DELETE trigger of form IGISLSST.
6: -- It updates the date disabled and the date_removed in the table
7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE
8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE

Line 8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE

4:
5: -- This procedure is called from the ON-DELETE trigger of form IGISLSST.
6: -- It updates the date disabled and the date_removed in the table
7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE
8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE

Line 9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE

5: -- This procedure is called from the ON-DELETE trigger of form IGISLSST.
6: -- It updates the date disabled and the date_removed in the table
7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE
8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)

Line 10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE

6: -- It updates the date disabled and the date_removed in the table
7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE
8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)
14: IS

Line 11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE

7: PROCEDURE Update_Row_On_Delete(p_owner IN igi_sls_secure_tables.owner%TYPE
8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)
14: IS
15: BEGIN

Line 12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE

8: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)
14: IS
15: BEGIN
16: UPDATE igi_sls_secure_tables

Line 13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)

9: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
10: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
11: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)
14: IS
15: BEGIN
16: UPDATE igi_sls_secure_tables
17: SET date_disabled = p_date_disabled

Line 16: UPDATE igi_sls_secure_tables

12: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
13: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE)
14: IS
15: BEGIN
16: UPDATE igi_sls_secure_tables
17: SET date_disabled = p_date_disabled
18: ,date_removed = p_date_removed
19: ,last_update_date = p_last_update_date
20: ,last_updated_by = p_last_updated_by

Line 31: END IGI_SLS_SECURE_TABLES_PKG;

27: RAISE No_Data_Found;
28: END IF;
29: END Update_Row_On_Delete;
30:
31: END IGI_SLS_SECURE_TABLES_PKG;