APPS.FND_OAM_DSCFG_PROC_LIBRARY_PKG dependencies on DBMS_SQL

Line 88: l_table_owners DBMS_SQL.VARCHAR2_TABLE;

84: PROCEDURE DISABLE_TARGET_TABLES_TRIGGERS
85: IS
86: l_ctxt VARCHAR2(60) := PKG_NAME||'DISABLE_TARGET_TABLES_TRIGGERS';
87:
88: l_table_owners DBMS_SQL.VARCHAR2_TABLE;
89: l_table_names DBMS_SQL.VARCHAR2_TABLE;
90:
91: l_object_id NUMBER;
92: l_property_id NUMBER;

Line 89: l_table_names DBMS_SQL.VARCHAR2_TABLE;

85: IS
86: l_ctxt VARCHAR2(60) := PKG_NAME||'DISABLE_TARGET_TABLES_TRIGGERS';
87:
88: l_table_owners DBMS_SQL.VARCHAR2_TABLE;
89: l_table_names DBMS_SQL.VARCHAR2_TABLE;
90:
91: l_object_id NUMBER;
92: l_property_id NUMBER;
93:

Line 188: l_object_ids DBMS_SQL.NUMBER_TABLE;

184: PROCEDURE RE_ENABLE_DISABLED_TRIGGERS
185: IS
186: l_ctxt VARCHAR2(60) := PKG_NAME||'RE_ENABLE_DISABLED_TRIGGERS';
187:
188: l_object_ids DBMS_SQL.NUMBER_TABLE;
189:
190: l_trigger_owner VARCHAR2(30);
191: l_trigger_name VARCHAR2(30);
192:

Line 280: l_table_owners DBMS_SQL.VARCHAR2_TABLE;

276: PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942);
277: NO_PRIMARY_KEY_DEFINED EXCEPTION;
278: PRAGMA EXCEPTION_INIT(NO_PRIMARY_KEY_DEFINED, -2433);
279:
280: l_table_owners DBMS_SQL.VARCHAR2_TABLE;
281: l_table_names DBMS_SQL.VARCHAR2_TABLE;
282:
283: l_object_id NUMBER;
284: l_property_id NUMBER;

Line 281: l_table_names DBMS_SQL.VARCHAR2_TABLE;

277: NO_PRIMARY_KEY_DEFINED EXCEPTION;
278: PRAGMA EXCEPTION_INIT(NO_PRIMARY_KEY_DEFINED, -2433);
279:
280: l_table_owners DBMS_SQL.VARCHAR2_TABLE;
281: l_table_names DBMS_SQL.VARCHAR2_TABLE;
282:
283: l_object_id NUMBER;
284: l_property_id NUMBER;
285: l_disabled NUMBER := 0;

Line 386: l_object_ids DBMS_SQL.NUMBER_TABLE;

382: PROCEDURE ENABLE_DISABLED_PRIMARY_KEYS
383: IS
384: l_ctxt VARCHAR2(60) := PKG_NAME||'ENABLE_DISABLED_PRIMARY_KEYS';
385:
386: l_object_ids DBMS_SQL.NUMBER_TABLE;
387:
388: l_table_owner VARCHAR2(30);
389: l_table_name VARCHAR2(30);
390: l_enabled NUMBER := 0;