[Home] [Help]
92: AND pv.vendor_id = jibh.vendor_id;
93:
94: CURSOR for_invoice_num IS
95: SELECT 'PLA/Invoice/'||TO_CHAR(p_org_id) inv_num
96: FROM DUAL;
97:
98: /* Bug 4928860. Added by Lakshmi Gopalsami
99: Removed select and added cursor.
100: */
154: END IF;
155:
156: Select ap_invoices_interface_s.nextval
157: Into inv_interface_id
158: From dual;
159:
160: SELECT ap_invoice_lines_interface_s.NEXTVAL
161: INTO inv_line_interface_id
162: FROM DUAL;
158: From dual;
159:
160: SELECT ap_invoice_lines_interface_s.NEXTVAL
161: INTO inv_line_interface_id
162: FROM DUAL;
163:
164: Select currency_code
165: Into p_currency_code
166: From gl_sets_of_books
355: WHERE invoice_id = inv_id;
356:
357: CURSOR for_invoice_num IS
358: SELECT 'BOE/Invoice/'||TO_CHAR(p_org_id)||'/'||TO_CHAR(P_BOE_ID) inv_num
359: FROM DUAL; --Added on 21-Feb-2002
360:
361: /* Bug 4928860. Added by Lakshmi Gopalsami
362: Removed select and added cursor.
363: */
465: END IF;
466:
467: SELECT ap_invoices_interface_s.NEXTVAL
468: INTO inv_interface_id
469: FROM dual;
470:
471: SELECT ap_invoice_lines_interface_s.NEXTVAL
472: INTO inv_line_interface_id
473: FROM DUAL;
469: FROM dual;
470:
471: SELECT ap_invoice_lines_interface_s.NEXTVAL
472: INTO inv_line_interface_id
473: FROM DUAL;
474:
475: SELECT currency_code
476: INTO p_currency_code
477: FROM gl_sets_of_books
719: CLOSE counter_cur;
720:
721: SELECT ap_invoice_lines_interface_s.NEXTVAL
722: INTO inv_line_interface_id
723: FROM dual;
724:
725: lv_tax_account_code := jai_boe_general_pkg.get_boe_accounting(get_tax_amount_rec.tax_type,
726: 'PAID_PAYABLES',
727: ln_organization_id,
772: close counter_cur;
773:
774: SELECT ap_invoice_lines_interface_s.NEXTVAL
775: INTO inv_line_interface_id
776: FROM DUAL;
777:
778: insert into ap_invoice_lines_interface
779: (
780: invoice_id,
3545: )
3546: IS
3547: CURSOR tax_cat_id IS
3548: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval val_id
3549: FROM dual;
3550:
3551: CURSOR tax_cat is SELECT 'X' X
3552: FROM JAI_CMN_TAX_CTGS_ALL
3553: WHERE tax_category_name = p_tax_category_name
3732:
3733: --get category id from sequence
3734: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval
3735: INTO ln_val_id
3736: FROM dual;
3737:
3738: --create tax category header line
3739: INSERT INTO JAI_CMN_TAX_CTGS_ALL(
3740: TAX_CATEGORY_ID
3784: --@Create new tax code for base TDS tax
3785: --get tax code ID for base tax
3786: SELECT JAI_CMN_TAXES_ALL_S.nextval
3787: INTO ln_base_tax_id
3788: FROM dual;
3789:
3790: ln_prcd_cnt := 1;
3791: lv_name := SUBSTR(ln_base_tax_rate || '% TDS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3792: jai_cmn_taxes_all_rec := NULL;
3830:
3831: --get tax code ID for base tax
3832: SELECT JAI_CMN_TAXES_ALL_S.nextval
3833: INTO ln_cess_id
3834: FROM dual;
3835:
3836: IF NVL(ln_cess_rate,0) <> 0 THEN
3837: ln_prcd_cnt := ln_prcd_cnt + 1;
3838: --get tax code ID for TDS CESS tax
3837: ln_prcd_cnt := ln_prcd_cnt + 1;
3838: --get tax code ID for TDS CESS tax
3839: SELECT JAI_CMN_TAXES_ALL_S.nextval
3840: INTO ln_cess_id
3841: FROM dual;
3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3885: ln_prcd_cnt := ln_prcd_cnt + 1;
3886: --get tax code ID for TDS CESS tax
3887: SELECT JAI_CMN_TAXES_ALL_S.nextval
3888: INTO ln_sh_cess_id
3889: FROM dual;
3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3937: ln_prcd_cnt := ln_prcd_cnt + 1;
3938: --get tax code ID for TDS CESS tax
3939: SELECT JAI_CMN_TAXES_ALL_S.nextval
3940: INTO ln_surcharge_id
3941: FROM dual;
3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;