eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IAW_PKG dependencies on AP_INVOICES_ALL

Line 142: FROM ap_invoices_all

138: END IF;
139:
140: SELECT invoice_amount
141: INTO l_amount
142: FROM ap_invoices_all
143: WHERE invoice_id = l_invoice_id;
144:
145: l_debug_info := 'check AME if production rules should prevent approval';
146: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 223: UPDATE AP_INVOICES_ALL

219: G_MODULE_NAME||
220: l_api_name,l_debug_info);
221: END IF;
222:
223: UPDATE AP_INVOICES_ALL
224: SET WFApproval_Status = 'NOT REQUIRED'
225: WHERE Invoice_Id = l_invoice_id
226: AND WFApproval_Status = 'INITIATED';
227:

Line 290: UPDATE AP_INVOICES_ALL

286:
287: Insert_Header_History(
288: p_inv_aprvl_hist => l_h_hist);
289:
290: UPDATE AP_INVOICES_ALL
291: SET WFApproval_Status = 'REJECTED'
292: WHERE Invoice_Id = l_invoice_id
293: AND WFApproval_Status = 'INITIATED';
294:

Line 598: UPDATE AP_INVOICES_ALL

594: --None sent at all
595: IF l_sent = 0 and l_comp = 0 THEN
596:
597: --Set transaction statuses
598: UPDATE AP_INVOICES_ALL
599: SET WFApproval_Status = 'NOT REQUIRED'
600: WHERE Invoice_Id = l_invoice_id
601: AND WFApproval_Status = 'INITIATED';
602:

Line 633: UPDATE AP_INVOICES_ALL

629: --First set transaction statuses
630: --to approved for header and lines
631: --only set the header to approved, if it was actually
632: --approved in the process.
633: UPDATE AP_INVOICES_ALL
634: SET WFApproval_Status = 'WFAPPROVED'
635: WHERE WFApproval_Status = 'INITIATED'
636: AND Invoice_Id IN (SELECT DISTINCT Invoice_ID
637: FROM AP_APINV_APPROVERS

Line 666: UPDATE AP_INVOICES_ALL

662: --process. By default, the only ones
663: -- that have not been set to 'Rejected'
664: --or 'Approved', are still
665: --'Initiated'
666: UPDATE AP_INVOICES_ALL
667: SET WFApproval_Status = 'NOT REQUIRED'
668: WHERE Invoice_Id = l_invoice_id
669: AND WFApproval_Status = 'INITIATED';
670:

Line 1954: ap_invoices_all AI,

1950: l_invoice_date,
1951: l_invoice_description,
1952: l_supplier_role
1953: FROM
1954: ap_invoices_all AI,
1955: po_vendors PV,
1956: po_vendor_sites_all PVS,
1957: fnd_user u
1958: WHERE

Line 2165: ap_invoices_all AI,

2161: l_invoice_description,
2162: l_invoice_total,
2163: l_invoice_currency_code
2164: FROM
2165: ap_invoices_all AI,
2166: po_vendors PV,
2167: po_vendor_sites_all PVS
2168: WHERE
2169: AI.invoice_id = l_invoice_id AND

Line 2655: l_amount ap_invoices_all.invoice_amount%TYPE;

2651: l_invoice_id NUMBER(15);
2652: l_iteration NUMBER(15);
2653: l_result VARCHAR2(50);
2654: l_comments VARCHAR2(240);
2655: l_amount ap_invoices_all.invoice_amount%TYPE;
2656: l_status VARCHAR2(50);
2657: l_org_id NUMBER(15);
2658: l_user_id NUMBER(15);
2659: l_login_id NUMBER(15);

Line 2802: l_amount ap_invoices_all.invoice_amount%TYPE;

2798:
2799: l_invoice_id NUMBER(15);
2800: l_result VARCHAR2(50);
2801: l_comments VARCHAR2(240);
2802: l_amount ap_invoices_all.invoice_amount%TYPE;
2803: l_status VARCHAR2(50);
2804: l_org_id NUMBER(15);
2805: l_user_id NUMBER(15);
2806: l_login_id NUMBER(15);

Line 3235: UPDATE ap_invoices_all

3231: WHERE wfapproval_status in ('INITIATED','REQUIRED','REJECTED',
3232: 'NEEDS REAPPROVAL','STOPPED');
3233:
3234: --Set the header status
3235: UPDATE ap_invoices_all
3236: SET wfapproval_status = 'NOT REQUIRED'
3237: WHERE wfapproval_status in ('INITIATED','REQUIRED','REJECTED',
3238: 'NEEDS REAPPROVAL','STOPPED');
3239:

Line 3366: FROM ap_invoices_all

3362: SELECT organization
3363: INTO l_return_val
3364: FROM PA_EXP_ORGS_IT
3365: WHERE organization_id=(SELECT expenditure_organization_id
3366: FROM ap_invoices_all
3367: WHERE invoice_id = p_invoice_id);
3368:
3369: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
3370:

Line 3877: l_org_id ap_invoices_all.org_id%TYPE;

3873: p_mapping_tbl IN tLineApprovers,
3874: p_invoice_source IN VARCHAR2,
3875: p_ext_user_name IN VARCHAR2) as
3876:
3877: l_org_id ap_invoices_all.org_id%TYPE;
3878: l_notif_key ap_apinv_approvers.notification_key%TYPE;
3879: l_notif_iter ap_apinv_approvers.notification_iteration%TYPE;
3880: l_api_name CONSTANT VARCHAR2(200) := 'insert_approver_rec';
3881: l_debug_info VARCHAR2(2000);

Line 3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;

3966: resultout OUT NOCOPY VARCHAR2) AS
3967:
3968: l_po_header_id po_headers_all.po_header_id%TYPE;
3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%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;

Line 3972: l_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

3968: l_po_header_id po_headers_all.po_header_id%TYPE;
3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%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;

Line 3973: l_internal_contact_email ap_invoices_all.internal_contact_email%TYPE;

3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%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;

Line 3974: l_source ap_invoices_all.source%TYPE;

3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%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;

Line 4000: ap_invoices_all ai,

3996: cursor owners_csr is
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')

Line 4016: ap_invoices_all ai,

4012: cursor buyers_csr is
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')

Line 4036: ap_invoices_all ai,

4032: -- level to pick a random one
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')

Line 4050: ap_invoices_all ai,

4046: -- 4. po project managers
4047: cursor proj_managers_csr is
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

Line 4091: from ap_invoices_all ai,

4087: select ai.invoice_type_lookup_code, ai.internal_contact_email,
4088: ai.source, u.user_name
4089: into l_invoice_type, l_internal_contact_email,
4090: l_source, l_ext_user_name
4091: from ap_invoices_all ai,
4092: fnd_user u
4093: where invoice_id = l_invoice_id
4094: and u.user_id = ai.created_by
4095: and trunc(sysdate) between trunc(u.start_date)

Line 4292: ap_invoices_all i,

4288:
4289: cursor internal_reps is
4290: select distinct il.line_owner_role, i.source, u.user_name
4291: from ap_invoice_lines_all il,
4292: ap_invoices_all i,
4293: fnd_user u
4294: where il.line_owner_role is not null
4295: and il.line_type_lookup_code = 'ITEM'
4296: and i.invoice_id = l_invoice_id

Line 4449: where exists( select 'e' from ap_invoices_all

4445: begin
4446: select 'X'
4447: into l_f
4448: from dual
4449: where exists( select 'e' from ap_invoices_all
4450: where invoice_id = l_invoice_id and
4451: org_id = l_org_id and wfapproval_status = 'REJECTED'
4452: union all
4453: select 'e' from ap_invoice_lines_all

Line 4475: l_invoice_id ap_invoices_all.invoice_id%TYPE;

4471: itemkey IN VARCHAR2,
4472: actid IN NUMBER,
4473: funcmode IN VARCHAR2,
4474: resultout OUT NOCOPY VARCHAR2) as
4475: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4476: l_rowid rowid := null;
4477: l_notification_key varchar2(320);
4478: l_org_id number;
4479: l_iteration number;

Line 4544: ap_invoices_all AI,

4540: l_invoice_number,
4541: l_invoice_date,
4542: l_invoice_description
4543: FROM
4544: ap_invoices_all AI,
4545: po_vendors PV,
4546: po_vendor_sites_all PVS
4547: WHERE
4548: AI.invoice_id = l_invoice_id AND

Line 4696: from ap_invoices_all

4692: cursor invoice is
4693: select gl_date,
4694: last_updated_by,
4695: last_update_login
4696: from ap_invoices_all
4697: where invoice_id = l_invoice_id
4698: and org_id = l_org_id;
4699: begin
4700: if(funcmode = 'RUN') then

Line 4909: from ap_invoices_all

4905: 'ORG_ID');
4906: begin
4907: select invoice_type_lookup_code
4908: into l_type
4909: from ap_invoices_all
4910: where invoice_id = l_invoice_id
4911: and org_id = l_org_id;
4912: exception
4913: when no_data_found then

Line 4938: update ap_invoices_all

4934: 'INVOICE_ID');
4935: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4936: itemkey,
4937: 'ORG_ID');
4938: update ap_invoices_all
4939: set invoice_type_lookup_code =
4940: decode(invoice_type_lookup_code,
4941: 'INVOICE REQUEST', 'STANDARD',
4942: 'CREDIT MEMO REQUEST', 'CREDIT', 'STANDARD')

Line 5019: ap_invoices_all AI,

5015: l_invoice_number,
5016: l_invoice_date,
5017: l_invoice_description
5018: FROM
5019: ap_invoices_all AI,
5020: po_vendors PV,
5021: po_vendor_sites_all PVS
5022: WHERE
5023: AI.invoice_id = l_invoice_id AND

Line 5108: l_invoice_id ap_invoices_all.invoice_id%TYPE;

5104: itemkey IN VARCHAR2,
5105: actid IN NUMBER,
5106: funcmode IN VARCHAR2,
5107: resultout OUT NOCOPY VARCHAR2) as
5108: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5109: l_vendor_id ap_invoices_all.vendor_id%TYPE;
5110: l_org_id ap_invoices_all.org_id%TYPE;
5111: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE;
5112: l_holds_count NUMBER;

Line 5109: l_vendor_id ap_invoices_all.vendor_id%TYPE;

5105: actid IN NUMBER,
5106: funcmode IN VARCHAR2,
5107: resultout OUT NOCOPY VARCHAR2) as
5108: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5109: l_vendor_id ap_invoices_all.vendor_id%TYPE;
5110: l_org_id ap_invoices_all.org_id%TYPE;
5111: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE;
5112: l_holds_count NUMBER;
5113: l_approval_status VARCHAR2(240);

Line 5110: l_org_id ap_invoices_all.org_id%TYPE;

5106: funcmode IN VARCHAR2,
5107: resultout OUT NOCOPY VARCHAR2) as
5108: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5109: l_vendor_id ap_invoices_all.vendor_id%TYPE;
5110: l_org_id ap_invoices_all.org_id%TYPE;
5111: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE;
5112: l_holds_count NUMBER;
5113: l_approval_status VARCHAR2(240);
5114: l_funds_return_code VARCHAR(240);

Line 5111: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE;

5107: resultout OUT NOCOPY VARCHAR2) as
5108: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5109: l_vendor_id ap_invoices_all.vendor_id%TYPE;
5110: l_org_id ap_invoices_all.org_id%TYPE;
5111: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE;
5112: l_holds_count NUMBER;
5113: l_approval_status VARCHAR2(240);
5114: l_funds_return_code VARCHAR(240);
5115:

Line 5133: from ap_invoices_all

5129: itemkey,
5130: 'ORG_ID');
5131: select vendor_id, set_of_books_id
5132: into l_vendor_id, l_set_of_books_id
5133: from ap_invoices_all
5134: where invoice_id = l_invoice_id;
5135:
5136: ap_approval_pkg.approve(
5137: p_run_option => 'All',