APPS.GMA_PURGE_DDL dependencies on ALL_CONSTRAINTS

Line 417: -- disable or enable all constraints for named table

413: p_owner user_users.username%TYPE,
414: p_appl_short_name fnd_application.application_short_name%TYPE,
415: p_action VARCHAR2,
416: p_debug_flag BOOLEAN) IS
417: -- disable or enable all constraints for named table
418:
419: CURSOR l_tablename_cur(P_purge_id sy_purg_mst.purge_id%TYPE) IS
420: SELECT table_name,archive_action
421: FROM sy_purg_def_act

Line 435: FROM all_constraints a, all_constraints b

431: a_tablecount number(3);
432:
433: CURSOR l_constraints_cur (c_tablename user_tables.table_name%TYPE) IS
434: SELECT b.table_name pk_table_name,a.owner, a.table_name,a.CONSTRAINT_NAME,a.status
435: FROM all_constraints a, all_constraints b
436: WHERE a.r_constraint_name = b.constraint_name
437: -- AND a.constraint_type = 'R'
438: -- AND b.constraint_type = 'P'
439: AND a.r_owner=b.owner

Line 445: pk_table_name all_constraints.table_name%TYPE,

441: AND b.table_name = upper(c_tablename)
442: ORDER by b.TABLE_NAME;
443:
444: TYPE constraint_table_rec_type IS RECORD(
445: pk_table_name all_constraints.table_name%TYPE,
446: owner all_constraints.owner%TYPE,
447: table_name all_constraints.table_name%TYPE,
448: constraint_name all_constraints.constraint_name%TYPE,
449: status all_constraints.status%TYPE

Line 446: owner all_constraints.owner%TYPE,

442: ORDER by b.TABLE_NAME;
443:
444: TYPE constraint_table_rec_type IS RECORD(
445: pk_table_name all_constraints.table_name%TYPE,
446: owner all_constraints.owner%TYPE,
447: table_name all_constraints.table_name%TYPE,
448: constraint_name all_constraints.constraint_name%TYPE,
449: status all_constraints.status%TYPE
450: );

Line 447: table_name all_constraints.table_name%TYPE,

443:
444: TYPE constraint_table_rec_type IS RECORD(
445: pk_table_name all_constraints.table_name%TYPE,
446: owner all_constraints.owner%TYPE,
447: table_name all_constraints.table_name%TYPE,
448: constraint_name all_constraints.constraint_name%TYPE,
449: status all_constraints.status%TYPE
450: );
451:

Line 448: constraint_name all_constraints.constraint_name%TYPE,

444: TYPE constraint_table_rec_type IS RECORD(
445: pk_table_name all_constraints.table_name%TYPE,
446: owner all_constraints.owner%TYPE,
447: table_name all_constraints.table_name%TYPE,
448: constraint_name all_constraints.constraint_name%TYPE,
449: status all_constraints.status%TYPE
450: );
451:
452: TYPE constraint_tab_type IS TABLE OF constraint_table_rec_type index by binary_integer;

Line 449: status all_constraints.status%TYPE

445: pk_table_name all_constraints.table_name%TYPE,
446: owner all_constraints.owner%TYPE,
447: table_name all_constraints.table_name%TYPE,
448: constraint_name all_constraints.constraint_name%TYPE,
449: status all_constraints.status%TYPE
450: );
451:
452: TYPE constraint_tab_type IS TABLE OF constraint_table_rec_type index by binary_integer;
453: l_constraint constraint_tab_type;