APPS.AP_IAW_PKG dependencies on WF_LOCAL_ROLES

Line 3976: l_adhoc_role_name wf_local_roles.name%TYPE;

3972: l_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
3973: l_internal_contact_email ap_invoices_all.internal_contact_email%TYPE;
3974: l_source ap_invoices_all.source%TYPE;
3975: l_ext_user_name fnd_user.user_name%TYPE;
3976: l_adhoc_role_name wf_local_roles.name%TYPE;
3977: l_adhoc_display_name wf_local_roles.display_name%TYPE;
3978: l_fallback_role_name wf_local_roles.name%TYPE;
3979: -- l_line_appr_rec rLineApproverMappings;
3980: l_line_appr_tbl tLineApprovers;

Line 3977: l_adhoc_display_name wf_local_roles.display_name%TYPE;

3973: l_internal_contact_email ap_invoices_all.internal_contact_email%TYPE;
3974: l_source ap_invoices_all.source%TYPE;
3975: l_ext_user_name fnd_user.user_name%TYPE;
3976: l_adhoc_role_name wf_local_roles.name%TYPE;
3977: l_adhoc_display_name wf_local_roles.display_name%TYPE;
3978: l_fallback_role_name wf_local_roles.name%TYPE;
3979: -- l_line_appr_rec rLineApproverMappings;
3980: l_line_appr_tbl tLineApprovers;
3981: l_adhoc_role_count NUMBER;

Line 3978: l_fallback_role_name wf_local_roles.name%TYPE;

3974: l_source ap_invoices_all.source%TYPE;
3975: l_ext_user_name fnd_user.user_name%TYPE;
3976: l_adhoc_role_name wf_local_roles.name%TYPE;
3977: l_adhoc_display_name wf_local_roles.display_name%TYPE;
3978: l_fallback_role_name wf_local_roles.name%TYPE;
3979: -- l_line_appr_rec rLineApproverMappings;
3980: l_line_appr_tbl tLineApprovers;
3981: l_adhoc_role_count NUMBER;
3982:

Line 4001: wf_local_roles wfr

3997: select ail.line_number, pll.work_approver_id, wfr.name
3998: from ap_invoice_lines_all ail,
3999: po_line_locations_all pll,
4000: ap_invoices_all ai,
4001: wf_local_roles wfr
4002: where ai.invoice_id = l_invoice_id
4003: and ai.invoice_id = ail.invoice_id
4004: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4005: and ail.line_type_lookup_code = 'ITEM'

Line 4017: wf_local_roles wfr

4013: select ph.agent_id, ail.line_number, wfr.name
4014: from ap_invoice_lines_all ail,
4015: po_headers_all ph,
4016: ap_invoices_all ai,
4017: wf_local_roles wfr
4018: where ai.invoice_id = l_invoice_id
4019: and ai.invoice_id = ail.invoice_id
4020: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4021: and ail.line_type_lookup_code = 'ITEM'

Line 4037: wf_local_roles wfr

4033: cursor requesters_csr is
4034: select ail.requester_id, ail.line_number, wfr.name
4035: from ap_invoice_lines_all ail,
4036: ap_invoices_all ai,
4037: wf_local_roles wfr
4038: where ai.invoice_id = l_invoice_id
4039: and ai.invoice_id = ail.invoice_id
4040: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4041: and ail.line_type_lookup_code = 'ITEM'

Line 4052: wf_local_roles wfr

4048: select pt.task_manager_person_id, ail.line_number, wfr.name
4049: from ap_invoice_lines_all ail,
4050: ap_invoices_all ai,
4051: pa_tasks pt,
4052: wf_local_roles wfr
4053: where ai.invoice_id = l_invoice_id
4054: and ai.invoice_id = ail.invoice_id
4055: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4056: and ail.line_type_lookup_code = 'ITEM'

Line 4129: from wf_local_roles

4125:
4126: -- check if the same ad-hoc role has already been created
4127: select count(*)
4128: into l_adhoc_role_count
4129: from wf_local_roles
4130: where name = l_adhoc_role_name
4131: and display_name = l_adhoc_display_name;
4132:
4133: IF ( l_adhoc_role_count <= 0 ) THEN