DBA Data[Home] [Help]

APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on AMW_CONSTRAINTS_TL

Line 648: -- from interface table to AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

644: -- Procedure name
645: -- create_constraints
646: -- Purpose
647: -- import constraints
648: -- from interface table to AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
649: -- Notes
650: -- this procedure is called in Concurrent Executable
651: -- History
652: -- 09.13.2005 tsho: consider group_code, object_type of constraint entries

Line 697: FROM amw_constraints_b b, amw_constraints_tl tl

693:
694: -- check if the constraint already existed
695: CURSOR c_constraint_exists (l_cst_name IN VARCHAR2) IS
696: SELECT b.constraint_id, b.constraint_rev_id, b.approval_status
697: FROM amw_constraints_b b, amw_constraints_tl tl
698: WHERE tl.name = l_cst_name
699: AND tl.language = USERENV('LANG')
700: AND tl.constraint_id = b.constraint_id;
701: