[Home] [Help]
4496: SELECT
4497: jai_ap_invoice_lines_s.NEXTVAL
4498: INTO
4499: ln_jai_inv_line_id
4500: FROM DUAL;
4501:
4502: EXECUTE IMMEDIATE lv_insert_jai_inv_sql
4503: USING ln_jai_inv_line_id
4504: , pn_organization_id
4739: SELECT
4740: jai_cmn_document_taxes_s.nextval
4741: INTO
4742: ln_doc_tax_id
4743: FROM DUAL;
4744:
4745: EXECUTE IMMEDIATE lv_insert_jai_tax_sql
4746: USING ln_doc_tax_id
4747: , ln_max_tax_line_num
4909: SELECT
4910: jai_ap_invoice_lines_s.NEXTVAL
4911: INTO
4912: ln_jai_inv_line_id
4913: FROM DUAL;
4914:
4915: --insert into eric_log values (7.81,'jai_doc_taxes_rec.inc_tax_flag =''N'' Branch ',sysdate);
4916: --insert into jai_ap_invoice_lines
4917: EXECUTE IMMEDIATE lv_insert_jai_inv_sql
5001: SELECT
5002: ap_invoice_distributions_s.NEXTVAL
5003: INTO
5004: ln_inv_dist_id
5005: FROM DUAL;
5006:
5007: IF (ap_invoice_dist_rec.assets_tracking_flag = 'N')
5008: THEN
5009: ln_chargeble_acct_ccid :=NULL;
5131: SELECT
5132: jai_ap_invoice_lines_s.NEXTVAL
5133: INTO
5134: ln_jai_inv_line_id
5135: FROM DUAL;
5136:
5137: EXECUTE IMMEDIATE lv_insert_jai_inv_sql
5138: USING ln_jai_inv_line_id
5139: , pn_organization_id
5200: SELECT
5201: ap_invoice_distributions_s.NEXTVAL
5202: INTO
5203: ln_inv_dist_id
5204: FROM DUAL;
5205:
5206: IF (ap_invoice_dist_rec.assets_tracking_flag = 'N')
5207: THEN
5208: ln_chargeble_acct_ccid :=NULL;
5276: SELECT
5277: jai_ap_invoice_lines_s.NEXTVAL
5278: INTO
5279: ln_jai_inv_line_id
5280: FROM DUAL;
5281:
5282: --insert into eric_log values (7.94,'prepare to insert ositive line with no project info ',sysdate);
5283:
5284: EXECUTE IMMEDIATE lv_insert_jai_inv_sql
5347: SELECT
5348: ap_invoice_distributions_s.NEXTVAL
5349: INTO
5350: ln_inv_dist_id
5351: FROM DUAL;
5352:
5353: IF (ap_invoice_dist_rec.assets_tracking_flag = 'N')
5354: THEN
5355: ln_chargeble_acct_ccid :=NULL;