APPS.AMW_CTRL_APPROVAL_PVT dependencies on AMW_CONTROLS_ALL_VL

Line 76: FROM amw_Controls_all_vl

72:
73: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
74: SELECT Control_id, name, creation_date,
75: requestor_id
76: FROM amw_Controls_all_vl
77: WHERE control_rev_id = p_CTRL_rev_id;
78: BEGIN
79: IF G_DEBUG THEN
80: amw_utility_pvt.debug_message (

Line 257: FROM amw_controls_all_vl

253: l_approval_date DATE ;
254: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
255: SELECT control_id, name, creation_date,
256: requestor_id -- --s hould be a name
257: FROM amw_controls_all_vl
258: WHERE control_rev_id = p_CTRL_rev_id;
259: BEGIN
260: IF G_DEBUG THEN
261: amw_utility_pvt.debug_message (

Line 444: FROM amw_controls_all_vl

440: l_requestor_id NUMBER;
441:
442: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
443: SELECT control_id, name, creation_date, requestor_id
444: FROM amw_controls_all_vl
445: WHERE Control_rev_id = p_CTRL_rev_id;
446: BEGIN
447: IF G_DEBUG THEN
448: amw_utility_pvt.debug_message (

Line 632: FROM amw_controls_all_vl

628:
629: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
630: SELECT control_id, name, creation_date,
631: requestor_id -- needs to be the name
632: FROM amw_controls_all_vl
633: WHERE control_rev_id = p_CTRL_rev_id;
634: BEGIN
635: IF G_DEBUG THEN
636: amw_utility_pvt.debug_message (

Line 820: FROM amw_controls_all_vl

816: l_object_meaning VARCHAR2 (80);
817: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
818: SELECT control_id, name, creation_date
819: requestor_id -- needs to be the name
820: FROM amw_controls_all_vl
821: WHERE control_rev_id = p_CTRL_rev_id;
822: BEGIN
823: IF G_DEBUG THEN
824: amw_utility_pvt.debug_message (

Line 1022: FROM amw_controls_all_vl

1018: l_lookup_meaning VARCHAR2(240);
1019:
1020: CURSOR c_CTRL_rec (p_CTRL_rev_id IN NUMBER) IS
1021: SELECT control_id, name, creation_date
1022: FROM amw_controls_all_vl
1023: WHERE control_rev_id = p_CTRL_rev_id;
1024: BEGIN
1025: fnd_msg_pub.initialize;
1026: l_OBJECT_id :=