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.JAI_AP_MATCH_TAX_PROC_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 315: r_ap_inv_dist_item ap_invoice_distributions_all%ROWTYPE;

311: ,pn_shipment_hdr_id NUMBER
312: ,pn_shipment_line_id NUMBER
313: )IS
314: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;
315: r_ap_inv_dist_item ap_invoice_distributions_all%ROWTYPE;
316: r_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
317: lv_tax_type VARCHAR2(10);
318: lv_is_item_an_expense VARCHAR2(1);
319: lv_accrue_on_receipt_flag VARCHAR2(1);

Line 316: r_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;

312: ,pn_shipment_line_id NUMBER
313: )IS
314: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;
315: r_ap_inv_dist_item ap_invoice_distributions_all%ROWTYPE;
316: r_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
317: lv_tax_type VARCHAR2(10);
318: lv_is_item_an_expense VARCHAR2(1);
319: lv_accrue_on_receipt_flag VARCHAR2(1);
320: ln_lines_to_insert NUMBER;

Line 338: ap_invoice_distributions_all

334: AND LINE_NUMBER = pn_invoice_line_num;
335:
336: CURSOR c_inv_dist IS
337: SELECT * FROM
338: ap_invoice_distributions_all
339: WHERE invoice_id = pn_invoice_id
340: AND invoice_line_number = pn_invoice_line_num
341: AND distribution_line_number = ( SELECT min(distribution_line_number)
342: FROM ap_invoice_distributions_all apid

Line 342: FROM ap_invoice_distributions_all apid

338: ap_invoice_distributions_all
339: WHERE invoice_id = pn_invoice_id
340: AND invoice_line_number = pn_invoice_line_num
341: AND distribution_line_number = ( SELECT min(distribution_line_number)
342: FROM ap_invoice_distributions_all apid
343: WHERE apid.invoice_id = Pn_invoice_id
344: AND apid.invoice_line_number = pn_invoice_line_num);
345: CURSOR c_inv_source IS
346: SELECT SOURCE FROM

Line 475: ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE

471: */
472: PROCEDURE populate_tax_to_ap
473: (
474: pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
475: ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
476: ,pr_ap_inv_dist_tax IN ap_invoice_distributions_all%ROWTYPE
477: ,p_tax_line_rec IN l_tax_line_rec_type
478: ,pv_rematch IN VARCHAR2
479: ,pv_source IN VARCHAR2

Line 476: ,pr_ap_inv_dist_tax IN ap_invoice_distributions_all%ROWTYPE

472: PROCEDURE populate_tax_to_ap
473: (
474: pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
475: ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
476: ,pr_ap_inv_dist_tax IN ap_invoice_distributions_all%ROWTYPE
477: ,p_tax_line_rec IN l_tax_line_rec_type
478: ,pv_rematch IN VARCHAR2
479: ,pv_source IN VARCHAR2
480: ,pn_lines_to_insert IN NUMBER

Line 503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';

499: ln_invoice_id NUMBER := pr_ap_inv_line_item.invoice_id ;
500: ln_inv_line_num NUMBER;
501: ln_user_id NUMBER := fnd_global.user_id;
502: ln_login_id NUMBER := fnd_global.login_id;
503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;

Line 504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';

500: ln_inv_line_num NUMBER;
501: ln_user_id NUMBER := fnd_global.user_id;
502: ln_login_id NUMBER := fnd_global.login_id;
503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;
508: lr_ap_inv_line_tax ap_invoice_lines%ROWTYPE;

Line 505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;

501: ln_user_id NUMBER := fnd_global.user_id;
502: ln_login_id NUMBER := fnd_global.login_id;
503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;
508: lr_ap_inv_line_tax ap_invoice_lines%ROWTYPE;
509: lr_ap_inv_line_incl_tax ap_invoice_lines%ROWTYPE;

Line 506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;

502: ln_login_id NUMBER := fnd_global.login_id;
503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;
508: lr_ap_inv_line_tax ap_invoice_lines%ROWTYPE;
509: lr_ap_inv_line_incl_tax ap_invoice_lines%ROWTYPE;
510: lr_ap_inv_line_liability ap_invoice_lines%ROWTYPE;

Line 507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;

503: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
504: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
505: lr_ap_inv_dist_tax ap_invoice_distributions_all%ROWTYPE;
506: lr_ap_inv_dist_incl_tax ap_invoice_distributions_all%ROWTYPE;
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;
508: lr_ap_inv_line_tax ap_invoice_lines%ROWTYPE;
509: lr_ap_inv_line_incl_tax ap_invoice_lines%ROWTYPE;
510: lr_ap_inv_line_liability ap_invoice_lines%ROWTYPE;
511: lr_jai_ap_match_taxes JAI_AP_MATCH_INV_TAXES%ROWTYPE;

Line 517: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

513: ln_task_id ap_invoice_lines.task_id%TYPE;
514: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
515: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;
516: ln_exp_organization_id ap_invoice_lines.expenditure_organization_id%TYPE;
517: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
518: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
519: v_distribution_no NUMBER;
520: lv_match_type VARCHAR2(15) := 'NOT_MATCHED';
521: ln_dist_code_combination_id NUMBER;

Line 518: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

514: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
515: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;
516: ln_exp_organization_id ap_invoice_lines.expenditure_organization_id%TYPE;
517: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
518: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
519: v_distribution_no NUMBER;
520: lv_match_type VARCHAR2(15) := 'NOT_MATCHED';
521: ln_dist_code_combination_id NUMBER;
522: v_tax_variance_inv_cur NUMBER;

Line 591: FROM ap_invoice_distributions_all a,

587: a.org_id
588: ,project_accounting_context
589: ,pa_addition_flag
590: ,a.dist_match_type
591: FROM ap_invoice_distributions_all a,
592: ap_invoice_lines_all b
593: WHERE a.invoice_id = ln_invoice_id
594: AND a.invoice_line_number = pr_ap_inv_line_item.line_number
595: AND b.invoice_id = ln_invoice_id

Line 630: ap_invoice_distributions_all apd,

626: api.last_update_date,
627: api.last_updated_by,
628: api.invoice_date
629: FROM ap_invoices_all api,
630: ap_invoice_distributions_all apd,
631: po_distributions_all pod,
632: po_headers_all poh
633: WHERE apd.invoice_id = api.invoice_id
634: AND pod.po_header_id = poh.po_header_id

Line 1507: REM pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE Y Indiate which invoice line is processed.

1503: REM
1504: REM Parameter IN/OUT Type Required Description and Purpose
1505: REM ------------------------------ ------ ---------------------------------------- ---------- ------------------------------------
1506: REM pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE Y Indiate which invoice is processed.
1507: REM pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE Y Indiate which invoice line is processed.
1508: REM pr_tax_line_rec IN/OUT l_tax_line_tbl_type Y The taxes to be copied to invoice.
1509: REM pv_rematch IN VARCHAR2 Y Match type of the invoice line
1510: REM pn_shipment_hdr_id IN NUMBER Y shipment hdr id of the PO.
1511: REM pn_shipment_line_id IN NUMBER Y shipment line id of the PO.

Line 1524: REM pr_ap_inv_dist_tax OUT ap_invoice_distributions_all%ROWTYPE Y The AP dist line with prepared data.

1520: REM pn_inclurec_tax_amt OUT NUMBER Y inclusive recoverable tax amount
1521: REM pn_currency_precision OUT NUMBER Y currency precision.
1522: REM pn_rvs_charge_liability_acct OUT NUMBER Y reverse charge liablity account id.
1523: REM pn_incls_acct_id OUT NUMBER Y inclusive tax account id.
1524: REM pr_ap_inv_dist_tax OUT ap_invoice_distributions_all%ROWTYPE Y The AP dist line with prepared data.
1525: REM
1526: REM CALLED BY copy_tax_from_po_rcv
1527: REM -------------------------------------------------------------------------------------------------------------------------------------
1528: REM | | = 1 | Exclusive tax or inlcusive tax without project info

Line 1548: ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE

1544: REM |pn_currency_precision | = Precision setup for this currency
1545: REM +===========================================================================================================================================+
1546: */
1547: PROCEDURE prepare_copy_tax(pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
1548: ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
1549: ,pr_tax_line_rec IN OUT NOCOPY l_tax_line_rec_type
1550: ,pv_rematch IN VARCHAR2
1551: ,pn_shipment_hdr_id IN NUMBER
1552: ,pn_shipment_line_id IN NUMBER

Line 1563: ,pr_ap_inv_dist_tax OUT NOCOPY ap_invoice_distributions_all%ROWTYPE

1559: ,pn_inclurec_tax_amt OUT NOCOPY NUMBER
1560: ,pn_currency_precision OUT NOCOPY NUMBER
1561: ,pn_rvs_charge_liability_acct OUT NOCOPY NUMBER
1562: ,pn_incls_acct_id OUT NOCOPY NUMBER
1563: ,pr_ap_inv_dist_tax OUT NOCOPY ap_invoice_distributions_all%ROWTYPE
1564: ) IS
1565:
1566:
1567:

Line 1653: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

1649: ln_task_id ap_invoice_lines.task_id%TYPE;
1650: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
1651: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;
1652: ln_exp_organization_id ap_invoice_lines.expenditure_organization_id%TYPE;
1653: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
1654: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
1655:
1656:
1657: ln_user_id NUMBER := fnd_global.user_id;

Line 1654: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

1650: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
1651: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;
1652: ln_exp_organization_id ap_invoice_lines.expenditure_organization_id%TYPE;
1653: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
1654: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
1655:
1656:
1657: ln_user_id NUMBER := fnd_global.user_id;
1658: ln_login_id NUMBER := fnd_global.login_id;

Line 1659: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';

1655:
1656:
1657: ln_user_id NUMBER := fnd_global.user_id;
1658: ln_login_id NUMBER := fnd_global.login_id;
1659: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
1660: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
1661:
1662:
1663:

Line 1660: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';

1656:
1657: ln_user_id NUMBER := fnd_global.user_id;
1658: ln_login_id NUMBER := fnd_global.login_id;
1659: lv_misc ap_invoice_distributions_all.line_type_lookup_code%TYPE := 'MISCELLANEOUS';
1660: lv_dist_class ap_invoice_distributions_all.distribution_class%TYPE := 'PERMANENT';
1661:
1662:
1663:
1664: l_api_name CONSTANT VARCHAR2(30) := 'prepare_copy_tax';

Line 2520: p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE

2516: app_exception.raise_exception;
2517: END insert_ap_inv_line;
2518:
2519: FUNCTION insert_ap_inv_dist(
2520: p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE
2521: )RETURN NUMBER IS
2522: CURSOR c_get_inv_dist_id IS
2523: select ap_invoice_distributions_s.nextval
2524: from dual;

Line 2536: INSERT INTO ap_invoice_distributions_all

2532: END IF;
2533: OPEN c_get_inv_dist_id;
2534: FETCH c_get_inv_dist_id INTO ln_dist_id;
2535: CLOSE c_get_inv_dist_id;
2536: INSERT INTO ap_invoice_distributions_all
2537: (ACCOUNTING_DATE
2538: ,ACCRUAL_POSTED_FLAG
2539: ,ASSETS_ADDITION_FLAG
2540: ,ASSETS_TRACKING_FLAG

Line 3338: FROM ap_invoice_distributions_all

3334:
3335: -- get the corresponding base line amount in original invoice
3336: CURSOR c_check_orig_item_line(p_price_correct_inv_id NUMBER, p_po_distribution_id NUMBER) IS
3337: SELECT amount, invoice_distribution_id
3338: FROM ap_invoice_distributions_all
3339: WHERE invoice_id = p_price_correct_inv_id AND
3340: po_distribution_id = p_po_distribution_id AND
3341: line_type_lookup_code = 'ITEM';
3342:

Line 3550: from ap_invoice_lines_all la, ap_invoice_distributions_all da

3546: la.po_distribution_id,
3547: da.invoice_distribution_id,
3548: la.rcv_transaction_id,
3549: la.line_number invoice_line_number
3550: from ap_invoice_lines_all la, ap_invoice_distributions_all da
3551: where la.invoice_id = p_invoice_id
3552: and la.invoice_id = da.invoice_id
3553: and la.line_number = da.invoice_line_number
3554: and la.line_type_lookup_code = 'MISCELLANEOUS'

Line 3619: from ap_invoice_distributions_all

3615: project_accounting_context,
3616: pa_addition_flag,
3617: distribution_class,
3618: dist_match_type
3619: from ap_invoice_distributions_all
3620: where invoice_id = ln_invoice_id
3621: and invoice_distribution_id = ln_invoice_distribution_id;
3622:
3623: Cursor c_inv_dist_tax_lines_ers(ln_invoice_id number,

Line 3670: from ap_invoice_distributions_all

3666: project_accounting_context,
3667: pa_addition_flag,
3668: distribution_class,
3669: dist_match_type
3670: from ap_invoice_distributions_all
3671: where invoice_id = ln_invoice_id
3672: and po_distribution_id = ln_po_distribution_id
3673: and line_type_lookup_code = 'MISCELLANEOUS';
3674:

Line 3683: lc_inv_dist ap_invoice_distributions_all%rowtype;

3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;
3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
3685:
3686: BEGIN
3687: ln_invoice_id := pr_ap_invoice_line_rec.invoice_id;

Line 3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;

3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;
3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
3685:
3686: BEGIN
3687: ln_invoice_id := pr_ap_invoice_line_rec.invoice_id;
3688: ln_po_dist_id := pr_ap_invoice_line_rec.po_distribution_id;

Line 3704: --INSERT INTO ap_invoice_distributions_all

3700: ln_po_dist_id) Loop
3701:
3702: For ins_reverse_dist_lines in c_inv_dist_tax_lines(ident_rec.invoice_id,
3703: ident_rec.invoice_distribution_id) Loop
3704: --INSERT INTO ap_invoice_distributions_all
3705: lc_inv_dist := null;
3706: lc_inv_dist.accounting_date := ins_reverse_dist_lines.accounting_date;
3707: lc_inv_dist.accrual_posted_flag := ins_reverse_dist_lines.accrual_posted_flag;
3708: lc_inv_dist.assets_addition_flag := ins_reverse_dist_lines.assets_addition_flag;

Line 3771: --INSERT INTO ap_invoice_distributions_all

3767: End Loop;
3768: Elsif lv_discard_flag = 'Y' and lv_source = 'ERS' Then
3769: For ins_reverse_dist_lines_ers in c_inv_dist_tax_lines_ers(ln_invoice_id,
3770: ln_po_dist_id) Loop
3771: --INSERT INTO ap_invoice_distributions_all
3772: lc_inv_dist := null;
3773: lc_inv_dist.accounting_date := ins_reverse_dist_lines_ers.accounting_date;
3774: lc_inv_dist.accrual_posted_flag := ins_reverse_dist_lines_ers.accrual_posted_flag;
3775: lc_inv_dist.assets_addition_flag := ins_reverse_dist_lines_ers.assets_addition_flag;