APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on AMW_AUDIT_PROCEDURES_VL

Line 45: FROM amw_audit_procedures_vl

41: l_approval_date DATE;
42:
43: CURSOR c_name_exists (l_audit_procedure_name IN VARCHAR2) IS
44: SELECT audit_procedure_id
45: FROM amw_audit_procedures_vl
46: WHERE name = l_audit_procedure_name;
47: l_audit_procedure_id amw_audit_procedures_vl.audit_procedure_id%TYPE;
48:
49: CURSOR c_revision_exists (l_audit_procedure_id IN NUMBER) IS

Line 47: l_audit_procedure_id amw_audit_procedures_vl.audit_procedure_id%TYPE;

43: CURSOR c_name_exists (l_audit_procedure_name IN VARCHAR2) IS
44: SELECT audit_procedure_id
45: FROM amw_audit_procedures_vl
46: WHERE name = l_audit_procedure_name;
47: l_audit_procedure_id amw_audit_procedures_vl.audit_procedure_id%TYPE;
48:
49: CURSOR c_revision_exists (l_audit_procedure_id IN NUMBER) IS
50: SELECT count(*)
51: FROM amw_audit_procedures_b

Line 554: l_row_id amw_audit_procedures_vl.row_id%TYPE;

550: l_audit_procedure_rev_id NUMBER;
551: l_dummy NUMBER;
552: l_audit_procedure_rec audit_procedure_rec_type;
553: l_dummy_audit_procedure_rec audit_procedure_rec_type;
554: l_row_id amw_audit_procedures_vl.row_id%TYPE;
555:
556: CURSOR c_rev_id IS
557: SELECT amw_procedure_rev_s.nextval
558: FROM dual;

Line 1639: FROM amw_audit_procedures_vl

1635:
1636: CURSOR c_tl_complete IS
1637: SELECT name,
1638: description
1639: FROM amw_audit_procedures_vl
1640: WHERE audit_procedure_rev_id = p_audit_procedure_rec.audit_procedure_rev_id;
1641: l_audit_procedure_tl_rec c_tl_complete%ROWTYPE;
1642:
1643:

Line 2107: FROM amw_audit_procedures_vl

2103: l_dummy NUMBER;
2104:
2105: CURSOR c_name_exists (l_audit_procedure_name IN VARCHAR2) IS
2106: SELECT 1
2107: FROM amw_audit_procedures_vl
2108: WHERE name = l_audit_procedure_name;
2109:
2110: BEGIN
2111: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2199: FROM amw_audit_procedures_vl

2195: target_audit_procedure c_target_audit_procedure%ROWTYPE;
2196:
2197: CURSOR c_name_exists (l_audit_procedure_name IN VARCHAR2,l_audit_procedure_id IN NUMBER) IS
2198: SELECT 1
2199: FROM amw_audit_procedures_vl
2200: WHERE name = l_audit_procedure_name AND audit_procedure_id <> l_audit_procedure_id;
2201:
2202: BEGIN
2203: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2301: FROM amw_audit_procedures_vl

2297: target_audit_procedure c_target_audit_procedure%ROWTYPE;
2298:
2299: CURSOR c_get_name (l_audit_procedure_rev_id IN NUMBER) IS
2300: SELECT name
2301: FROM amw_audit_procedures_vl
2302: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2303: original_audit_procedure_name amw_audit_procedures_vl.name%TYPE;
2304:
2305: BEGIN

Line 2303: original_audit_procedure_name amw_audit_procedures_vl.name%TYPE;

2299: CURSOR c_get_name (l_audit_procedure_rev_id IN NUMBER) IS
2300: SELECT name
2301: FROM amw_audit_procedures_vl
2302: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2303: original_audit_procedure_name amw_audit_procedures_vl.name%TYPE;
2304:
2305: BEGIN
2306: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2307: