[Home] [Help]
19: 23-Jun-2005 Brathod , File Version 112.0 , Bug# 4445989
20: - Signature for procedure get_aportion_factor is modified to use invoice_id and
21: invoice_line_number
22: - Code modified to fetch the details from ap_invoice_lines_all
23: instead of ap_invoice_distributions_all
24:
25: 02-Sep-2005 Ramananda for Bug#4584221, File Version 120.2
26: Added the new function get_tds_invoice_batch
27: In the form regime registrations (JAIREGIM.fmb) attribute_value field is a free flowing text.
1543: WHERE invoice_id = inv_id;
1544: -- iSupplier porting
1545:
1546:
1547: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1548: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1544: -- iSupplier porting
1545:
1546:
1547: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1548: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1545:
1546:
1547: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1548: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1553: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1557:
1558: v_po_price po_line_locations_all.price_override%type;
1559: v_po_quantity po_line_locations_all.quantity%type;
1560:
1561: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1562: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1563:
1564: v_uom_conv_factor number;
1565:
1558: v_po_price po_line_locations_all.price_override%type;
1559: v_po_quantity po_line_locations_all.quantity%type;
1560:
1561: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1562: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1563:
1564: v_uom_conv_factor number;
1565:
1566:
2421:
2422: Cursor get_misc_lines (ln_dist_line_number in number,
2423: ln_invoice_id in number ) is
2424: select *
2425: from ap_invoice_distributions_all
2426: where invoice_id = ln_invoice_id
2427: and distribution_line_number = ln_dist_line_number;
2428:
2429:
2549: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);
2550:
2551: ln_tax_bipv := ln_tax_ipv * nvl(r_get_misc_lines.exchange_rate,1);
2552:
2553: update ap_invoice_distributions_all
2554: set invoice_price_variance = round(ln_tax_ipv,ln_inv_pre),
2555: base_invoice_price_variance = round(ln_tax_bipv, ln_base_pre),
2556: price_var_code_combination_id = P_price_var_ccid
2557: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;
2564:
2565: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2566: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2567:
2568: update ap_invoice_distributions_all
2569: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),
2570: rate_var_code_combination_id = P_rate_var_ccid
2571: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;
2572: End if;
2575: Else
2576:
2577: /* update ipv and bipv to 0. no need to update Var CCID */
2578:
2579: update ap_invoice_distributions_all
2580: set invoice_price_variance = 0,
2581: base_invoice_price_variance = 0,
2582: exchange_rate_variance = 0
2583: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;
2646:
2647: cursor c_base_inv_amt
2648: is
2649: select amount
2650: from ap_invoice_distributions_all
2651: where invoice_distribution_id = p_parent_dist_id
2652: and invoice_id = p_invoice_id ;
2653:
2654: ln_line_amt number ;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2993:
2994: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;
2995: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
2996: ln_inv_org_id mtl_parameters.organization_id%TYPE;
2997: lv_inv_org_code mtl_parameters.organization_code%TYPE;
2998:
3053: SELECT
3054: dist_code_combination_id
3055: , amount
3056: FROM
3057: ap_invoice_distributions_all
3058: WHERE invoice_id = pn_invoice_id
3059: AND invoice_line_number = pn_invoice_line_num;
3060:
3061: BEGIN
3122: aila.line_number
3123: INTO
3124: ln_invoice_line_num
3125: FROM
3126: ap_invoice_distributions_all aida
3127: , ap_invoice_lines_all aila
3128: WHERE aida.invoice_distribution_id = pn_invoice_distribution_id
3129: AND aila.line_number = aida.invoice_line_number
3130: AND aila.invoice_id = pn_invoice_id
3181: COUNT(invoice_distribution_id)
3182: INTO
3183: ln_invoice_post_num
3184: FROM
3185: ap_invoice_distributions_all aida
3186: WHERE aida.invoice_id = pn_invoice_id
3187: AND aida.invoice_line_number = ln_invoice_line_num
3188: AND aida.posted_flag = 'Y';
3189:
3507:
3508: FUNCTION is_invoice_misc_missing(pn_invoice_id NUMBER) RETURN VARCHAR2 IS
3509: CURSOR c_check_dist_exists IS
3510: SELECT '1' FROM
3511: ap_invoice_distributions_all
3512: WHERE invoice_id = pn_invoice_id;
3513:
3514: lv_dist_exists_flag varchar2(1);
3515: is_invoice_misc_missing VARCHAR2(1);