APPS.AMW_RISK_PVT dependencies on AMW_RISKS_ALL_VL

Line 46: FROM amw_risks_all_vl

42: l_dummy_risk_rec risk_rec_type := NULL;
43:
44: CURSOR c_name_exists (l_risk_name IN VARCHAR2) IS
45: SELECT risk_id
46: FROM amw_risks_all_vl
47: WHERE name = l_risk_name;
48: l_risk_id amw_risks_all_vl.risk_id%TYPE;
49:
50: CURSOR c_revision_exists (l_risk_id IN NUMBER) IS

Line 48: l_risk_id amw_risks_all_vl.risk_id%TYPE;

44: CURSOR c_name_exists (l_risk_name IN VARCHAR2) IS
45: SELECT risk_id
46: FROM amw_risks_all_vl
47: WHERE name = l_risk_name;
48: l_risk_id amw_risks_all_vl.risk_id%TYPE;
49:
50: CURSOR c_revision_exists (l_risk_id IN NUMBER) IS
51: SELECT count(*)
52: FROM amw_risks_b

Line 537: l_row_id amw_risks_all_vl.row_id%TYPE;

533: l_RISK_REV_ID NUMBER;
534: l_dummy NUMBER;
535: l_risk_rec risk_rec_type;
536: l_dummy_risk_rec risk_rec_type;
537: l_row_id amw_risks_all_vl.row_id%TYPE;
538:
539: CURSOR c_rev_id IS
540: SELECT AMW_RISK_REV_ID_S.NEXTVAL
541: FROM dual;

Line 1583: FROM amw_risks_all_vl

1579:
1580: CURSOR c_tl_complete IS
1581: SELECT name,
1582: description
1583: FROM amw_risks_all_vl
1584: WHERE risk_rev_id = p_risk_rec.risk_rev_id;
1585: l_risk_tl_rec c_tl_complete%ROWTYPE;
1586:
1587:

Line 2076: FROM amw_risks_all_vl

2072: l_dummy NUMBER;
2073:
2074: CURSOR c_name_exists (l_risk_name IN VARCHAR2) IS
2075: SELECT 1
2076: FROM amw_risks_all_vl
2077: WHERE name = l_risk_name;
2078:
2079: BEGIN
2080: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2168: FROM amw_risks_all_vl

2164: target_risk c_target_risk%ROWTYPE;
2165:
2166: CURSOR c_name_exists (l_risk_name IN VARCHAR2,l_risk_id IN NUMBER) IS
2167: SELECT 1
2168: FROM amw_risks_all_vl
2169: WHERE name = l_risk_name AND risk_id <> l_risk_id;
2170:
2171: BEGIN
2172: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2270: FROM amw_risks_all_vl

2266: target_risk c_target_risk%ROWTYPE;
2267:
2268: CURSOR c_get_name (l_risk_rev_id IN NUMBER) IS
2269: SELECT name
2270: FROM amw_risks_all_vl
2271: WHERE risk_rev_id = l_risk_rev_id;
2272: original_risk_name amw_risks_all_vl.name%TYPE;
2273:
2274: BEGIN

Line 2272: original_risk_name amw_risks_all_vl.name%TYPE;

2268: CURSOR c_get_name (l_risk_rev_id IN NUMBER) IS
2269: SELECT name
2270: FROM amw_risks_all_vl
2271: WHERE risk_rev_id = l_risk_rev_id;
2272: original_risk_name amw_risks_all_vl.name%TYPE;
2273:
2274: BEGIN
2275: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2276: