DBA Data[Home] [Help]

APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_SECURITY_PKG

Line 1: PACKAGE BODY igi_sls_security_pkg AS

1: PACKAGE BODY igi_sls_security_pkg AS
2: -- $Header: igislsdb.pls 120.12.12010000.2 2008/08/04 13:07:01 sasukuma 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.igislsdb.igi_sls_security_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.igislsdb.igi_sls_security_pkg.';
12:
13:
14: /*-----------------------------------------------------------------
15: This procedure writes to the error log.

Line 85: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

81: /*------------------------------------------------------------------
82: This proecdure gets the schema names for the Multilingual and
83: Multi currency application
84:
85: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
86: ------------------------------------------------------------------*/
87: PROCEDURE get_mrc_mls_schemanames (p_mls_schema_name IN OUT NOCOPY VARCHAR2,
88: p_mrc_schema_name IN OUT NOCOPY VARCHAR2,
89: errbuf IN OUT NOCOPY VARCHAR2,

Line 225: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

221:
222: /*------------------------------------------------------------------
223: This function checks if allocations exist for the table
224:
225: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
226: ------------------------------------------------------------------*/
227: FUNCTION check_allocation_exists ( p_table_name IN igi_sls_secure_tables.table_name%TYPE)
228: RETURN BOOLEAN
229: IS

Line 296: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

292: /*------------------------------------------------------------------
293: This proecdure creates , disables, drops the sls objects depending
294: on their status in the igi_sls_secure_tables.
295:
296: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
297: ------------------------------------------------------------------*/
298: PROCEDURE create_drop_sls_objects ( p_mls_schema_name IN VARCHAR2,
299: p_mrc_schema_name IN VARCHAR2,
300: errbuf IN OUT NOCOPY VARCHAR2,

Line 771: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

767: /*------------------------------------------------------------------
768: This proecdure re-compiles i.e refreshes the triggers and procedures
769: for only the enabled tables in the igi_sls_secure_tables
770:
771: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
772: ------------------------------------------------------------------*/
773: PROCEDURE refresh_sls_objects ( p_mls_schema_name IN VARCHAR2,
774: p_mrc_schema_name IN VARCHAR2,
775: errbuf IN OUT NOCOPY VARCHAR2,

Line 1010: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

1006: /*------------------------------------------------------------------
1007: This proecdure populates the igi_sls_security_group_alloc table with the most
1008: uptodate data
1009:
1010: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
1011: ------------------------------------------------------------------*/
1012: PROCEDURE populate_group_alloc ( errbuf IN OUT NOCOPY VARCHAR2,
1013: retcode IN OUT NOCOPY NUMBER)
1014: IS

Line 1054: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

1050: /*------------------------------------------------------------------
1051: This proecdure cleans up the data in the security tables after all
1052: the objets have been created.
1053:
1054: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
1055: ------------------------------------------------------------------*/
1056: PROCEDURE cleanup_data ( errbuf IN OUT NOCOPY VARCHAR2,
1057: retcode IN OUT NOCOPY NUMBER)
1058: IS

Line 1399: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.

1395: /*------------------------------------------------------------------
1396: This proecdure stamps the data with date_security_applied on the
1397: group and allocations table
1398:
1399: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
1400: ------------------------------------------------------------------*/
1401: PROCEDURE stamp_records ( errbuf IN OUT NOCOPY VARCHAR2,
1402: retcode IN OUT NOCOPY NUMBER)
1403: IS

Line 2065: END igi_sls_security_pkg ;

2061: END secure_existing_data;
2062:
2063:
2064:
2065: END igi_sls_security_pkg ;