[Home] [Help]
2453:
2454: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N') THEN
2455:
2456: SELECT jai_ap_invoice_lines_s.NEXTVAL
2457: INTO ln_jai_inv_line_id FROM DUAL;
2458:
2459: lv_service_type_code_tmp := null;
2460: OPEN get_service_type (ln_invoice_id, ap_invoice_lines_rec.line_number);
2461: FETCH get_service_type INTO lv_service_type_code_tmp, lv_organization_id,lv_location_id ;
2564: SELECT
2565: ap_invoice_distributions_s.NEXTVAL
2566: INTO
2567: ln_inv_dist_id
2568: FROM DUAL;
2569:
2570: select invoice_distribution_id into lv_invoice_distribution_id
2571: FROM ap_invoice_distributions_all
2572: WHERE invoice_id = pn_invoice_id
2791: SELECT
2792: jai_ap_invoice_lines_s.NEXTVAL
2793: INTO
2794: ln_jai_inv_line_id
2795: FROM DUAL;
2796:
2797: lv_service_type_code_tmp := null;
2798: OPEN get_service_type (ln_invoice_id, ap_invoice_lines_rec.line_number);
2799: FETCH get_service_type INTO lv_service_type_code_tmp, lv_organization_id,lv_location_id ;
2891: SELECT
2892: ap_invoice_distributions_s.NEXTVAL
2893: INTO
2894: ln_inv_dist_id
2895: FROM DUAL;
2896: select invoice_distribution_id into lv_invoice_distribution_id
2897: FROM ap_invoice_distributions_all
2898: WHERE invoice_id = pn_invoice_id
2899: AND invoice_line_number = pn_line_number
3536:
3537: -- Start add for bug#3632810
3538: CURSOR c_get_invoice_distribution is -- bug#3332988
3539: select ap_invoice_distributions_s.nextval
3540: from dual;
3541:
3542: -- start addition by ssumaith -bug# 3127834
3543:
3544: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5630: FOR UPDATE OF DISTRIBUTION_LINE_NUMBER;
5631:
5632: cursor c_get_invoice_distribution is -- bug#3332988
5633: select ap_invoice_distributions_s.nextval
5634: from dual;
5635:
5636: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5637: select precision
5638: from fnd_currencies