APPS.AMW_AP_APPROVAL_PVT dependencies on AMW_AUDIT_PROCEDURES_VL

Line 69: FROM amw_audit_procedures_vl

65: l_object_meaning VARCHAR2 (80);
66: l_requestor_name VARCHAR2 (260);
67: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
68: SELECT audit_procedure_id, NAME, creation_date, requestor_id
69: FROM amw_audit_procedures_vl
70: WHERE audit_procedure_rev_id = p_ap_rev_id;
71: BEGIN
72: IF g_debug THEN
73: amw_utility_pvt.debug_message ( l_api_name

Line 236: FROM amw_audit_procedures_vl

232: l_approval_date DATE;
233: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
234: SELECT audit_procedure_id, NAME, creation_date,
235: requestor_id -- --s hould be a name
236: FROM amw_audit_procedures_vl
237: WHERE audit_procedure_rev_id = p_ap_rev_id;
238: BEGIN
239: IF g_debug THEN
240: amw_utility_pvt.debug_message ( l_api_name

Line 402: FROM amw_audit_procedures_vl

398: l_object_meaning VARCHAR2 (80);
399: l_requestor_id NUMBER;
400: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
401: SELECT audit_procedure_id, NAME, creation_date, requestor_id
402: FROM amw_audit_procedures_vl
403: WHERE audit_procedure_rev_id = p_ap_rev_id;
404: BEGIN
405: IF g_debug THEN
406: amw_utility_pvt.debug_message ( l_api_name

Line 569: FROM amw_audit_procedures_vl

565: l_requestor_name VARCHAR2 (360);
566: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
567: SELECT audit_procedure_id, NAME, creation_date,
568: requestor_id -- needs to be the name
569: FROM amw_audit_procedures_vl
570: WHERE audit_procedure_rev_id = p_ap_rev_id;
571: BEGIN
572: IF g_debug THEN
573: amw_utility_pvt.debug_message ( l_api_name

Line 748: FROM amw_audit_procedures_vl

744: l_object_meaning VARCHAR2 (80);
745: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
746: SELECT audit_procedure_id, NAME,
747: creation_date requestor_id -- needs to be the name
748: FROM amw_audit_procedures_vl
749: WHERE audit_procedure_rev_id = p_ap_rev_id;
750: BEGIN
751: IF g_debug THEN
752: amw_utility_pvt.debug_message ( l_api_name

Line 937: FROM amw_audit_procedures_vl

933: l_string VARCHAR2 (3000);
934: l_lookup_meaning VARCHAR2 (240);
935: CURSOR c_ap_rec (p_ap_rev_id IN NUMBER) IS
936: SELECT audit_procedure_id, NAME, creation_date
937: FROM amw_audit_procedures_vl
938: WHERE audit_procedure_rev_id = p_ap_rev_id;
939: BEGIN
940: fnd_msg_pub.initialize;
941: l_object_id :=