APPS.AMW_CONSTRAINT_PVT dependencies on AMW_CONSTRAINTS_B

Line 1458: FROM amw_constraints_b

1454: l_type_code VARCHAR2(30) := p_type_code;
1455: -- 01.06.2005 tsho: find the constraint by specified constraint_rev_id
1456: CURSOR c_constraint (l_constraint_rev_id IN NUMBER) IS
1457: SELECT type_code
1458: FROM amw_constraints_b
1459: WHERE constraint_rev_id=l_constraint_rev_id;
1460:
1461: TYPE userVioCurTyp IS REF CURSOR;
1462: c_user_vio_dynamic_sql userVioCurTyp;

Line 2034: FROM amw_constraints_b

2030:
2031: -- 01.06.2005 tsho: find the constraint by specified constraint_rev_id
2032: CURSOR c_constraint (l_constraint_rev_id IN NUMBER) IS
2033: SELECT type_code
2034: FROM amw_constraints_b
2035: WHERE constraint_rev_id=l_constraint_rev_id;
2036:
2037: i NUMBER;
2038: l_user_id NUMBER;

Line 2246: FROM amw_constraints_b

2242:
2243: -- 01.06.2005 tsho: find the constraint by specified constraint_rev_id
2244: CURSOR c_constraint (l_constraint_rev_id IN NUMBER) IS
2245: SELECT type_code
2246: FROM amw_constraints_b
2247: WHERE constraint_rev_id=l_constraint_rev_id;
2248:
2249: TYPE userVioCurTyp IS REF CURSOR;
2250: c_user_vio_dynamic_sql userVioCurTyp;

Line 6551: -- then don't need to search for type_code against AMW_CONSTRAINTS_B again.

6547: -- p_type_code := the type_code(constraint type) of specified constraint_rev_id
6548: --
6549: -- Notes
6550: -- if at calling time, already know the type_code(constraint type),
6551: -- then don't need to search for type_code against AMW_CONSTRAINTS_B again.
6552: --
6553: -- what if the specified constraint is not a valid constraint?
6554: --
6555: -- 12.21.2004 tsho: fix for performance bug 4036679

Line 6578: FROM amw_constraints_b

6574: SELECT constraint_rev_id,
6575: start_date,
6576: end_date,
6577: type_code
6578: FROM amw_constraints_b
6579: WHERE constraint_rev_id=l_constraint_rev_id;
6580: l_constraint c_constraint%ROWTYPE;
6581:
6582:

Line 6755: FROM amw_constraints_b

6751: -- find all valid constraints
6752: CURSOR c_all_valid_constraints IS
6753: SELECT constraint_rev_id,
6754: type_code
6755: FROM amw_constraints_b
6756: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate);
6757: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
6758:
6759: CURSOR c_constraint_set_details IS

Line 6762: FROM amw_constraints_b a,

6758:
6759: CURSOR c_constraint_set_details IS
6760: SELECT a.constraint_rev_id,
6761: a.type_code
6762: FROM amw_constraints_b a,
6763: amw_constraint_set_details cs
6764: WHERE cs.constraint_set_code = p_constraint_set
6765: AND cs.constraint_id = a.constraint_id;
6766: l_constraint_set_details c_constraint_set_details%ROWTYPE;

Line 6879: FROM amw_constraints_b cst

6875: -- find the constraint related to this violation
6876: CURSOR c_constraint(l_violation_id IN NUMBER) IS
6877: SELECT cst.constraint_rev_id
6878: ,cst.type_code
6879: FROM amw_constraints_b cst
6880: ,amw_violations v
6881: WHERE v.violation_id = l_violation_id
6882: AND v.constraint_rev_id = cst.constraint_rev_id;
6883: l_constraint c_constraint%ROWTYPE;