[Home] [Help]
1477: IS
1478: CURSOR Get_Service_Tax_Flag
1479: IS
1480: SELECT 'Y'
1481: FROM dual
1482: WHERE EXISTS (
1483: SELECT 'X'
1484: FROM jai_rgm_registrations
1485: WHERE registration_type = jai_constants.regn_type_tax_types
5357: SELECT
5358: jai_ap_invoice_lines_s.NEXTVAL
5359: INTO
5360: ln_jai_inv_line_id
5361: FROM DUAL;
5362: /* Bug 13535569 -added the below cursor call and the if condition*/
5363: open c_exists_jai_ap_invoice_lines(item_line_rec.invoice_id,item_line_rec.line_number);
5364: fetch c_exists_jai_ap_invoice_lines into ln_exists;
5365: close c_exists_jai_ap_invoice_lines;
5631: SELECT
5632: jai_cmn_document_taxes_s.nextval
5633: INTO
5634: ln_doc_tax_id
5635: FROM DUAL;
5636:
5637: EXECUTE IMMEDIATE lv_insert_jai_tax_sql
5638: USING ln_doc_tax_id
5639: , ln_max_tax_line_num
5823: SELECT
5824: jai_ap_invoice_lines_s.NEXTVAL
5825: INTO
5826: ln_jai_inv_line_id
5827: FROM DUAL;
5828:
5829: /*bug 9539642 - this cursor should be executed in all casses, to fetch
5830: the organization-location details. So changed the target variables and
5831: replaced the if-end if with nvl at the end*/
5981: SELECT
5982: ap_invoice_distributions_s.NEXTVAL
5983: INTO
5984: ln_inv_dist_id
5985: FROM DUAL;
5986:
5987: /* Bug 13793724 -start*/
5988: /* Commented by Qiong for bug15875609
5989: select invoice_distribution_id into lv_invoice_distribution_id
6168: SELECT
6169: jai_ap_invoice_lines_s.NEXTVAL
6170: INTO
6171: ln_jai_inv_line_id
6172: FROM DUAL;
6173:
6174: /*bug 9539642 - this cursor should be executed in all casses, to fetch
6175: the organization-location details. So changed the target variables and
6176: replaced the if-end if with nvl at the end*/
6310: SELECT
6311: ap_invoice_distributions_s.NEXTVAL
6312: INTO
6313: ln_inv_dist_id
6314: FROM DUAL;
6315: --start additions for bug#12946186
6316: ln_dist_lineno :=nvl(ln_dist_lineno,0)+1;
6317: select amount
6318: into ln_invoice_line_amt
6413: SELECT
6414: jai_ap_invoice_lines_s.NEXTVAL
6415: INTO
6416: ln_jai_inv_line_id
6417: FROM DUAL;
6418:
6419: --insert into eric_log values (7.94,'prepare to insert ositive line with no project info ',sysdate);
6420: /*bug 9539642 - this cursor should be executed in all casses, to fetch
6421: the organization-location details. So changed the target variables and
6559: SELECT
6560: ap_invoice_distributions_s.NEXTVAL
6561: INTO
6562: ln_inv_dist_id
6563: FROM DUAL;
6564: ln_chargeble_acct_ccid := null; /* Bug 13793724 - assets tracking flag is set to 'N' and hence setting ln_chargeble_acct_ccid to null */
6565: /* IF (ap_invoice_dist_rec.assets_tracking_flag = 'N')
6566: THEN
6567: ln_chargeble_acct_ccid :=NULL;