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

Line 1: PACKAGE BODY IGI_SLS_SECURE_TABLES_AU_PKG AS

1: PACKAGE BODY IGI_SLS_SECURE_TABLES_AU_PKG AS
2: /* $Header: igislsbb.pls 120.6.12000000.1 2007/09/03 17:22:03 vspuli ship $ */
3:
4: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: l_path VARCHAR2(50) := 'IGI.PLSQL.igislsbb.IGI_SLS_SECURE_TABLES_AU_PKG.';

7: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: l_path VARCHAR2(50) := 'IGI.PLSQL.igislsbb.IGI_SLS_SECURE_TABLES_AU_PKG.';
12:
13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE

Line 13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE

9: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: l_path VARCHAR2(50) := 'IGI.PLSQL.igislsbb.IGI_SLS_SECURE_TABLES_AU_PKG.';
12:
13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE

Line 14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE

10: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: l_path VARCHAR2(50) := 'IGI.PLSQL.igislsbb.IGI_SLS_SECURE_TABLES_AU_PKG.';
12:
13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE

Line 15: ,p_description IN igi_sls_secure_tables.description%TYPE

11: l_path VARCHAR2(50) := 'IGI.PLSQL.igislsbb.IGI_SLS_SECURE_TABLES_AU_PKG.';
12:
13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE

Line 16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE

12:
13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE

Line 17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE

13: PROCEDURE Insert_Row(p_owner IN igi_sls_secure_tables.owner%TYPE
14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE

Line 18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE

14: ,p_table_name IN igi_sls_secure_tables.table_name%TYPE
15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE

Line 19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE

15: ,p_description IN igi_sls_secure_tables.description%TYPE
16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE

Line 20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE

16: ,p_sls_table_name IN igi_sls_secure_tables.sls_table_name%TYPE
17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE

Line 21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE

17: ,p_update_allowed IN igi_sls_secure_tables.update_allowed%TYPE
18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE

Line 22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE

18: ,p_date_enabled IN igi_sls_secure_tables.date_enabled%TYPE
19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE

Line 23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE

19: ,p_date_disabled IN igi_sls_secure_tables.date_disabled%TYPE
20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE

Line 24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE

20: ,p_date_removed IN igi_sls_secure_tables.date_removed%TYPE
21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE
28: ,p_rowid IN OUT NOCOPY VARCHAR2

Line 25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE

21: ,p_date_object_created IN igi_sls_secure_tables.date_object_created%TYPE
22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE
28: ,p_rowid IN OUT NOCOPY VARCHAR2
29: ,p_calling_sequence IN OUT NOCOPY VARCHAR2)

Line 26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE

22: ,p_date_security_applied IN igi_sls_secure_tables.date_security_applied%TYPE
23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE
28: ,p_rowid IN OUT NOCOPY VARCHAR2
29: ,p_calling_sequence IN OUT NOCOPY VARCHAR2)
30: IS

Line 27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE

23: ,p_creation_date IN igi_sls_secure_tables.creation_date%TYPE
24: ,p_created_by IN igi_sls_secure_tables.created_by%TYPE
25: ,p_last_update_date IN igi_sls_secure_tables.last_update_date%TYPE
26: ,p_last_updated_by IN igi_sls_secure_tables.last_updated_by%TYPE
27: ,p_last_update_login IN igi_sls_secure_tables.last_update_login%TYPE
28: ,p_rowid IN OUT NOCOPY VARCHAR2
29: ,p_calling_sequence IN OUT NOCOPY VARCHAR2)
30: IS
31:

Line 36: FROM igi_sls_secure_tables_audit

32: l_debug_info VARCHAR2(100);
33:
34: CURSOR c_insert IS
35: SELECT rowid
36: FROM igi_sls_secure_tables_audit
37: WHERE owner = p_owner
38: AND table_name = p_table_name;
39:
40: BEGIN

Line 42: p_calling_sequence := 'IGI_SLS_SECURE_TABLES_AU_PKG.Insert_Row<-' ||

38: AND table_name = p_table_name;
39:
40: BEGIN
41: -- Update the calling sequence
42: p_calling_sequence := 'IGI_SLS_SECURE_TABLES_AU_PKG.Insert_Row<-' ||
43: p_calling_sequence;
44:
45: l_debug_info := 'Inserting into IGI_SLS_SECURE_TABLES_AUDIT';
46:

Line 45: l_debug_info := 'Inserting into IGI_SLS_SECURE_TABLES_AUDIT';

41: -- Update the calling sequence
42: p_calling_sequence := 'IGI_SLS_SECURE_TABLES_AU_PKG.Insert_Row<-' ||
43: p_calling_sequence;
44:
45: l_debug_info := 'Inserting into IGI_SLS_SECURE_TABLES_AUDIT';
46:
47: INSERT INTO igi_sls_secure_tables_audit
48: (owner
49: ,table_name

Line 47: INSERT INTO igi_sls_secure_tables_audit

43: p_calling_sequence;
44:
45: l_debug_info := 'Inserting into IGI_SLS_SECURE_TABLES_AUDIT';
46:
47: INSERT INTO igi_sls_secure_tables_audit
48: (owner
49: ,table_name
50: ,description
51: ,sls_table_name

Line 108: END IGI_SLS_SECURE_TABLES_AU_PKG;

104: APP_EXCEPTION.Raise_Exception;
105:
106: END Insert_Row;
107:
108: END IGI_SLS_SECURE_TABLES_AU_PKG;