[Home] [Help]
290:
291: 8. 15-oct-2003 kpvs for bug # 3109138, version # 616.2
292: Changed the procedure to insert v_open_gl_date instead of trunc(sysdate)
293: as invoice_date into ap_invoices_interface and as accounting_date into
294: ap_invoice_lines_interface.
295: This is for the invoice_date and GL date of the SI created for
296: supplier on cancellation of the vendor invoice.
297:
298: 9. 29-oct-2003 Aparajita for bug#3205957. Version#616.3
742: );
743:
744: lv_statement_no := '10';
745: lv_lookup_type_code := 'ITEM'; --rchandan for bug#4428980
746: INSERT INTO ap_invoice_lines_interface
747: (
748: invoice_id,
749: invoice_line_id,
750: line_number,
761: )
762: VALUES
763: (
764: ap_invoices_interface_s.CURRVAL,
765: ap_invoice_lines_interface_s.NEXTVAL,
766: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
767: lv_lookup_type_code, --rchandan for bug#4428980
768: new_std_invoice_amount,
769: v_open_gl_date, -- bug 3109138 TRUNC( SYSDATE ),
1241: Cursor get_prepay_dist_date incorporated to get the GL date of the distribution line
1242: created in ap_invoice_distributions_all .
1243:
1244: This date is inserted as invoice_date into ap_invoices_interface
1245: and as accounting_date into ap_invoice_lines_interface.
1246: This would ensure that the invoice date and GL date of the TDS invoices
1247: are in sync with the date entered on Apply/Unapply prepayment screen if the
1248: user changes this date.
1249:
1525: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
1526: v_tds_inv_num := 'RTN/'||v_tds_inv_num||'/'||TO_CHAR(v_tds_inv_run_num);
1527: lv_description := 'RTN FOR TDS TAX AUTHORITY FOR TAX APPLIED BY ';
1528: lv_lookup_type_code := 'ITEM';
1529: INSERT INTO ap_invoice_lines_interface
1530: (
1531: invoice_id,
1532: invoice_line_id,
1533: line_number,
1544: )
1545: VALUES
1546: (
1547: ap_invoices_interface_s.CURRVAL,
1548: ap_invoice_lines_interface_s.NEXTVAL,
1549: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
1550: lv_lookup_type_code,
1551: v_insertion_amount_tds_si , -- insertion_amount, bug#3469847
1552: v_prepay_dist_date, -- bug 3112711 kpvs TRUNC( SYSDATE ),
1661: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
1662: v_sup_cm_num := for_std_inv_rec.invoice_num || 'CM/' ||TO_CHAR(v_sup_cm_run_num);
1663: lv_lookup_type_code := 'ITEM';
1664: lv_description := 'CM FOR SUPPLIER ON TDS AFTER UNAPPLY';
1665: INSERT INTO ap_invoice_lines_interface
1666: (
1667: invoice_id,
1668: invoice_line_id,
1669: line_number,
1680: )
1681: VALUES
1682: (
1683: ap_invoices_interface_s.CURRVAL,
1684: ap_invoice_lines_interface_s.NEXTVAL,
1685: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
1686: lv_lookup_type_code, --rchandan for bug#4428980
1687: (-1) * insertion_amount,
1688: v_prepay_dist_date, -- bug 3112711 kpvs TRUNC( SYSDATE ),
2388: distribution line created in ap_invoice_distributions_all when the prepay invoice
2389: is applied to a standard invoice.
2390:
2391: This date is inserted as invoice_date into ap_invoices_interface and as
2392: accounting_date into ap_invoice_lines_interface. This would ensure that the CM for
2393: TDS authority and SI for the supplier that get created on cancellation of a vendor
2394: invoice, would bear proper invoice date and GL date instead of sysdate.
2395:
2396: 18. 22/12/2003 Aparajita Bug#3218881. Version#618.1
2753:
2754: -- following line added by Aparajita for bug # 2439034.
2755: v_ap_tds_cm_num := v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
2756:
2757: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 1 : CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED');
2758: v_stage:=8;
2759:
2760:
2761: /* Modified by Ramananda for bug# 4407184 ,start */
2761: /* Modified by Ramananda for bug# 4407184 ,start */
2762:
2763: lv_credit_note_tds := 'CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED BY '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;
2764:
2765: INSERT INTO ap_invoice_lines_interface (
2766: invoice_id,
2767: invoice_line_id,
2768: line_number,
2769: line_type_lookup_code,
2778: last_update_login
2779:
2780: ) VALUES (
2781: v_ap_invoices_interface_no,
2782: ap_invoice_lines_interface_s.NEXTVAL,
2783: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
2784: 'ITEM',
2785: --(-1)*insertion_amount,--commented on 13-Dec-2001
2786: (-1)*insertion_amount * NVL(get_exchange_rate_base_inv_rec.exchange_rate,1), --added on 03-Jan-2002
2910:
2911: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
2912: v_ap_sup_inv_num := 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
2913:
2914: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
2915: v_stage:=10;
2916:
2917: /* Modified by Ramananda for bug# 4407184 , start */
2918: lv_standard_invoice_num := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;
2916:
2917: /* Modified by Ramananda for bug# 4407184 , start */
2918: lv_standard_invoice_num := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;
2919:
2920: INSERT INTO ap_invoice_lines_interface
2921: (
2922: invoice_id,
2923: invoice_line_id,
2924: line_number,
2935: )
2936: VALUES
2937: (
2938: v_ap_invoices_interface_no,
2939: ap_invoice_lines_interface_s.NEXTVAL,
2940: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
2941: 'ITEM',
2942: insertion_amount,
2943: v_prepay_dist_date, --bug 3112711 kpvs TRUNC( SYSDATE ),
3200:
3201: -- following line added by Aparajita for bug # 2439034.
3202: v_ap_tds_cm_num := for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
3203:
3204: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 3 :CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED' );
3205: v_stage:=14;
3206:
3207: /* Modified by Ramananda for bug# 4407184 , start */
3208: lv_credit_note_tds := 'CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED BY '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id);
3206:
3207: /* Modified by Ramananda for bug# 4407184 , start */
3208: lv_credit_note_tds := 'CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED BY '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id);
3209:
3210: INSERT INTO ap_invoice_lines_interface (
3211: invoice_id,
3212: invoice_line_id,
3213: line_number,
3214: line_type_lookup_code,
3222: last_update_date,
3223: last_update_login
3224: ) VALUES (
3225: v_ap_invoices_interface_no,
3226: ap_invoice_lines_interface_s.NEXTVAL,
3227: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
3228: 'ITEM',
3229: --(-1)*insertion_amount,--commented on 13-Dec-2001
3230: (-1)*insertion_amount * NVL(get_exchange_rate_base_inv_rec.exchange_rate,1), --added on 03-Jan-2002
3350:
3351: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
3352: v_ap_sup_inv_num := 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
3353:
3354: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
3355: v_stage:=15;
3356:
3357: /* Modified by Ramananda for bug# 4407184 , start */
3358: lv_standard_return_excess := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;
3356:
3357: /* Modified by Ramananda for bug# 4407184 , start */
3358: lv_standard_return_excess := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;
3359:
3360: INSERT INTO ap_invoice_lines_interface (
3361: invoice_id,
3362: invoice_line_id,
3363: line_number,
3364: line_type_lookup_code,
3372: last_update_date,
3373: last_update_login
3374: ) VALUES (
3375: v_ap_invoices_interface_no,
3376: ap_invoice_lines_interface_s.NEXTVAL,
3377: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
3378: 'ITEM',
3379: insertion_amount,
3380: v_prepay_dist_date, --bug 3112711 kpvs TRUNC( SYSDATE )