[Home] [Help]
341:
342: Due to some internal exception, the out parameter corresponding to the the last_update_date is null
343:
344: Spoke to lgopalsa she was of the opinion that in the ap_cancel_pkg.Ap_Cancel_Single_Invoice API ,
345: the standard who columns are being set anyway and there is no need to set it explicitly in the
346: procedure.
347:
348: As part of this fix , removed the last_update_date from the columns in the update ap_invoices_all
349: table.
452: UPDATE ap_payment_schedules_all
453: SET gross_amount = 0,
454: amount_remaining = 0
455: -- , inv_curr_gross_amount = 0
456: -- base applications is not updating this field when a standard invoice is cancelled. so not updating this field in our code also
457: WHERE invoice_id in (select invoice_id
458: from ap_invoices_all
459: WHERE invoice_num = tds_invoices_rec.tds_invoice_num
460: AND vendor_id = vendor_rec.vendor_id
638:
639: End comment for bug#3536079 */
640:
641:
642: --GENERATE A STANDARD INVOICE FOR THE AMOUNT EQUAL TO THAT OF THE TDS INVOICE
643: lv_statement_no := '9';
644: -- start bug#3607133
645: open c_get_cm_status
646: (tds_invoices_rec.dm_invoice_num,
658: else
659: -- end bug#3607133
660: lv_invoice_num := 'CAN/'||SUBSTR(tds_invoices_rec.dm_invoice_num,1,47); --rchandan for bug#4428980
661: lv_description := 'Invoice Generated in lieu of Cancelled TDS Invoice'; --rchandan for bug#4428980
662: lv_lookup_type_code := 'STANDARD'; --rchandan for bug#4428980
663: lv_source := 'INDIA TDS'; --rchandan for bug#4428980
664:
665:
666: /* start additions by ssumaith - bug# 4448789 */
787: p_tax_amount => tds_invoices_rec.tds_amount,
788: p_vendor_id => for_std_invoice_rec.vendor_id,
789: p_vendor_site_id => for_std_invoice_rec.vendor_site_id,
790: p_invoice_vendor_num => 'CAN/'||SUBSTR(tds_invoices_rec.dm_invoice_num,1,47),
791: p_invoice_vendor_type => 'STANDARD',
792: p_invoice_vendor_curr => for_std_invoice_rec.invoice_currency_code,
793: p_invoice_vendor_amt => new_std_invoice_amount,
794: p_parent_inv_payment_priority => ln_prnt_pay_priority,
795: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
1198: /* ends additions by ssumaith - bug# 4448789*/
1199:
1200: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
1201:
1202: /* PrePayment to Standard */
1203:
1204: /*---------------------------------------------------------------------------------------------------------------------
1205: FILENAME: jai_ap_tds_old_pkg.process_prepayment_unapply.sql
1206:
1218: setup if the site setup does not exist for the vendor for pre approved TDS and CM. This was done
1219: to find out if the approval of TDS an CM concurrent needs to be submitted.
1220:
1221: 3. 08/08/2002 Aparajita for bug # 2461706. RCS version 615.3
1222: When a prepayment is applied to an unapproved standard invoice, tds related invoices get
1223: generated. But when the prepayment is unapplied, tds invoices were not getting generated. Modified
1224: the code to generate the tds related invoices at unapplying.
1225:
1226: 4. 24/09/2002 Aparajita Reopen issue - 1 for bug #2461706. RCS version 615.4
1252: Applied round function to the amount of the invoices that is being generated to be in sync
1253: with apply.
1254:
1255: 9. 08/03/2004 Aparajita for bug#3469847. Version#619.1
1256: For Prepeyment having forex, the amount for return standard invoice for TDS authority
1257: was not getting converted though the inv is always generated in INR.
1258:
1259: 10. 29/04/2004 Aparajita for bug#3583708. Version#619.2
1260: The Credit memo that is generated was not picking up the right dist_code_combination_id. It has to be the same as used in case of the
1360: END IF; -- check_for_tds_invoice_o%FOUND THEN --2
1361:
1362: -- following If added by Aparajita on 29th April for bug # 2338345
1363: IF v_tds_inv_num IS NULL THEN
1364: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
1365: -- the standard invoice is not approved yet.
1366: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
1367: v_tds_inv_num := for_std_invoice_rec.invoice_num || 'TDS';
1368: END IF;
1361:
1362: -- following If added by Aparajita on 29th April for bug # 2338345
1363: IF v_tds_inv_num IS NULL THEN
1364: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
1365: -- the standard invoice is not approved yet.
1366: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
1367: v_tds_inv_num := for_std_invoice_rec.invoice_num || 'TDS';
1368: END IF;
1369:
1362: -- following If added by Aparajita on 29th April for bug # 2338345
1363: IF v_tds_inv_num IS NULL THEN
1364: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
1365: -- the standard invoice is not approved yet.
1366: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
1367: v_tds_inv_num := for_std_invoice_rec.invoice_num || 'TDS';
1368: END IF;
1369:
1370: -- end the following else part is added on 08/08/2002 by Aparajita for bug # 2461706
1493: VALUES
1494: (
1495: ap_invoices_interface_s.NEXTVAL,
1496: lv_rtn_tds_inv, --'RTN/'|| v_tds_inv_num ||'/'||TO_CHAR(v_tds_inv_run_num),
1497: 'STANDARD',
1498: v_prepay_dist_date, -- bug 3112711 kpvs TRUNC( SYSDATE ), --for_std_inv_tds_rec.invoice_date,
1499: for_std_inv_tds_rec.vendor_id,
1500: for_std_inv_tds_rec.vendor_site_id,
1501: v_insertion_amount_tds_si , -- insertion_amount, bug#3469847
1705: p_tax_amount => ln_tax_amount,
1706: p_tds_authority_vendor_id => for_std_inv_tds_rec.vendor_id,
1707: p_tds_authority_vendor_site_id => for_std_inv_tds_rec.vendor_site_id,
1708: p_invoice_tds_authority_num => 'RTN/'|| v_tds_inv_num ||'/'||TO_CHAR(v_tds_inv_run_num),
1709: p_invoice_tds_authority_type => 'STANDARD',
1710: p_invoice_tds_authority_curr => for_std_inv_tds_rec.invoice_currency_code,
1711: p_invoice_tds_authority_amt => v_insertion_amount_tds_si,
1712: p_vendor_id => for_std_inv_rec.vendor_id,
1713: p_vendor_site_id => for_std_inv_rec.vendor_site_id,
2079: lv_tds_cm_num VARCHAR2(100);
2080: lv_credit_note_tds VARCHAR2(100);
2081: lv_invoice_num_cm VARCHAR2(100);
2082: lv_rtn_invoice_num VARCHAR2(100);
2083: lv_standard_invoice_num VARCHAR2(100);
2084: lv_rtn_std_invoice_num VARCHAR2(100);
2085: lv_invoice_num VARCHAR2(100);
2086: lv_credit_tds_auth VARCHAR2(100);
2087: lv_standard_return_excess VARCHAR2(100);
2083: lv_standard_invoice_num VARCHAR2(100);
2084: lv_rtn_std_invoice_num VARCHAR2(100);
2085: lv_invoice_num VARCHAR2(100);
2086: lv_credit_tds_auth VARCHAR2(100);
2087: lv_standard_return_excess VARCHAR2(100);
2088:
2089:
2090: /* start additions by ssumaith - bug# 4448789 */
2091: ln_legal_entity_id NUMBER;
2317: 4 11-Dec-01 RPK Code modified to fire this program when the payment is
2318: made/not made for the TDS Invoice of the Prepayment Invoice
2319:
2320: 5 08-Jan-02 RPK Credit memo invoice generation for TDS Authority,when prepayment
2321: in foreign currency is applied for foreign currency standard invoices,
2322: ie ,the credit memo should be generated with the functional currency.
2323:
2324: 6 05-FEB-02 RPK BUG # 2205735
2325: Code modified to generate the RTN invoice and the credit memos
2322: ie ,the credit memo should be generated with the functional currency.
2323:
2324: 6 05-FEB-02 RPK BUG # 2205735
2325: Code modified to generate the RTN invoice and the credit memos
2326: when the prepayment is applied to the unapproved standard invoices
2327:
2328: 7 20-Mar-2002 Aparajita Bug # 2272378
2329: Code modified to generate credit note and return invoice amount with correct tax
2330: when a prepayment is applied to a standard invoice.
2326: when the prepayment is applied to the unapproved standard invoices
2327:
2328: 7 20-Mar-2002 Aparajita Bug # 2272378
2329: Code modified to generate credit note and return invoice amount with correct tax
2330: when a prepayment is applied to a standard invoice.
2331:
2332:
2333: 8 26-APR-02 Aparajita Bug # 2338345
2334: The credit memo for Tax authority was getting generated starting with
2332:
2333: 8 26-APR-02 Aparajita Bug # 2338345
2334: The credit memo for Tax authority was getting generated starting with
2335: the prepayment invoice number when an prepayment is applied to an unapproved
2336: invoice, Changed it to start with the standard invoice number as the program for
2337: approving the credit memo (jai_ap_tds_old_pkg.approve_invoice),expects the name to start
2338: with standard invoice number.
2339:
2340: 9 14-may-2002 Aparajita Bug # 2364106
2334: The credit memo for Tax authority was getting generated starting with
2335: the prepayment invoice number when an prepayment is applied to an unapproved
2336: invoice, Changed it to start with the standard invoice number as the program for
2337: approving the credit memo (jai_ap_tds_old_pkg.approve_invoice),expects the name to start
2338: with standard invoice number.
2339:
2340: 9 14-may-2002 Aparajita Bug # 2364106
2341: This procedure was giving ORA-08002:sequence
2342: JAI_AP_TDS_INVOICE_NUM_S.CURRVAL is not yet defined in this session. Changed
2385:
2386: 17. 15/10/2003 kpvs bug # 3112711 kpvs, version 616.1
2387: Cursor get_prepay_dist_date incorporated to get the GL date of the negative
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
2397: Added inline function f_return_inv_amount to calculate the amount for the return
2398: invoices when the standard invoice on which the prepayment is being applied is
2399: approved.
2400:
2401: As per the requirements, the amount to be reversed is to be based on the standard
2402: invoice if the same is approved at the time of application. Application is for a
2397: Added inline function f_return_inv_amount to calculate the amount for the return
2398: invoices when the standard invoice on which the prepayment is being applied is
2399: approved.
2400:
2401: As per the requirements, the amount to be reversed is to be based on the standard
2402: invoice if the same is approved at the time of application. Application is for a
2403: distribution line of the prepayment and with this changed approach all
2404: distribution lines of the SI with TDS attached is considered in the first line
2405: first basis to check the amount that should be reversed.
2405: first basis to check the amount that should be reversed.
2406:
2407: 19. 09/02/2004 Aparajita Bug#3408429. Version#618.2
2408:
2409: Whenever the standard invoice and prepeyment are in foreign currency, the exchange rate
2410: should be populated if the exchange rate type is 'User'. This is hard coded as 'USER',
2411: where as the lookup code used by base is User. Changed the code to convert the rate
2412: type to upper case and compare it with 'USER'
2413:
2551: END IF;
2552:
2553: -- following If added by Aparajita on 29th April for bug # 2338345
2554: IF v_tds_cm_num IS NULL THEN
2555: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
2556: -- the standard invoice is not approved yet.
2557: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
2558: v_tds_cm_num := for_std_invoice_rec.invoice_num || 'TDS';
2559: END IF;
2552:
2553: -- following If added by Aparajita on 29th April for bug # 2338345
2554: IF v_tds_cm_num IS NULL THEN
2555: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
2556: -- the standard invoice is not approved yet.
2557: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
2558: v_tds_cm_num := for_std_invoice_rec.invoice_num || 'TDS';
2559: END IF;
2560:
2553: -- following If added by Aparajita on 29th April for bug # 2338345
2554: IF v_tds_cm_num IS NULL THEN
2555: -- the TDS invoice corrosponding to the standard invoice is not found, this would be when
2556: -- the standard invoice is not approved yet.
2557: -- the CM for TDS authortiy should then should have the standard invoice number suffixed by TDS
2558: v_tds_cm_num := for_std_invoice_rec.invoice_num || 'TDS';
2559: END IF;
2560:
2561: --end addition of 05-Feb-2002
2817: SELECT ap_invoices_interface_s.NEXTVAL
2818: INTO v_ap_invoices_interface_no
2819: FROM dual;
2820:
2821: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
2822: v_stage:=9;
2823:
2824: /* Modified by Ramananda for bug# 4407184 ,start */
2825:
2823:
2824: /* Modified by Ramananda for bug# 4407184 ,start */
2825:
2826: lv_rtn_invoice_num := 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
2827: lv_standard_invoice_num := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_invoice_rec.invoice_num||' OR '||TO_CHAR(p_invoice_id); -- NEW.prepay_id replaced with p_invoice_id
2828:
2829:
2830: /* start additions by ssumaith - bug# 4448789 */
2831: jai_cmn_utils_pkg.GET_LE_INFO(
2874: ) VALUES (
2875: v_ap_invoices_interface_no,
2876: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2877: lv_rtn_invoice_num, --'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2878: 'STANDARD',
2879: v_prepay_dist_date, --bug 3112711 kpvs -- TRUNC(SYSDATE), --for_std_invoice_rec.invoice_date,
2880: for_std_invoice_rec.vendor_id,
2881: for_std_invoice_rec.vendor_site_id,
2882: insertion_amount,
2886: -- Bug#3408429, cbabu for Bug#2508086
2887: for_std_invoice_rec.exchange_rate_type,
2888: for_std_invoice_rec.exchange_date,
2889: for_std_invoice_rec.terms_id,
2890: lv_standard_invoice_num , --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_invoice_rec.invoice_num||' OR '||TO_CHAR(p_invoice_id), -- NEW.prepay_id replaced with p_invoice_id
2891: 'INDIA TDS', /* --'TDS', --Ramanand for bug#4388958 */
2892: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
2893: -- lv_rtn_invoice_num , --'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
2894: for_std_invoice_rec.payment_method_lookup_code,
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) ;
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) ;
2919:
2920: INSERT INTO ap_invoice_lines_interface
2921: (
2922: invoice_id,
2940: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
2941: 'ITEM',
2942: insertion_amount,
2943: v_prepay_dist_date, --bug 3112711 kpvs TRUNC( SYSDATE ),
2944: lv_standard_invoice_num, --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ,
2945: --for_dist_insertion_rec.dist_code_combination_id, --Commented by Ajay Sharma on 09-AUG-01
2946: for_dist_insertion_tds_rec.dist_code_combination_id, --Added by Ajay Sharma --on 09-AUG-01
2947: p_created_by,
2948: p_creation_date,
2969: p_invoice_tds_authority_amt => ((-1)*insertion_amount * NVL(get_exchange_rate_base_inv_rec.exchange_rate,1)),
2970: p_vendor_id => for_std_invoice_rec.vendor_id,
2971: p_vendor_site_id => for_std_invoice_rec.vendor_site_id,
2972: p_invoice_vendor_num => 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2973: p_invoice_vendor_type => 'STANDARD',
2974: p_invoice_vendor_curr => for_std_invoice_rec.invoice_currency_code,
2975: p_invoice_vendor_amt => insertion_amount,
2976: p_parent_inv_payment_priority => ln_prnt_pay_priority,
2977: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
3259: SELECT ap_invoices_interface_s.NEXTVAL
3260: INTO v_ap_invoices_interface_no
3261: FROM dual;
3262:
3263: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
3264: v_stage:=15;
3265:
3266: /* Modified by Ramananda for bug# 4407184 ,start */
3267:
3265:
3266: /* Modified by Ramananda for bug# 4407184 ,start */
3267:
3268: lv_rtn_invoice_num := 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
3269: lv_standard_return_excess := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_inv_rec_r.invoice_num||' OR '||TO_CHAR(p_invoice_id);/**** NEW.prepay_id replaced with p_invoice_id*******/
3270:
3271: /* start additions by ssumaith - bug# 4448789 */
3272: jai_cmn_utils_pkg.GET_LE_INFO(
3273: P_API_VERSION => NULL ,
3315: ) VALUES (
3316: v_ap_invoices_interface_no,
3317: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
3318: lv_rtn_invoice_num , --'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
3319: 'STANDARD',
3320: v_prepay_dist_date, --bug 3112711 kpvs TRUNC(SYSDATE), --for_std_invoice_rec.invoice_date,
3321: for_std_inv_rec_r.vendor_id,
3322: for_std_inv_rec_r.vendor_site_id,
3323: insertion_amount,
3327: -- cbabu for Bug#2508086 Bug#3408429
3328: for_std_inv_rec_r.exchange_rate_type,
3329: for_std_inv_rec_r.exchange_date,
3330: for_std_inv_rec_r.terms_id,
3331: lv_standard_return_excess, --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_inv_rec_r.invoice_num||' OR '||TO_CHAR(p_invoice_id) ,/**** NEW.prepay_id replaced with p_invoice_id*******/
3332: 'INDIA TDS', /*--'TDS', --Ramanand for bug#4388958*/
3333: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
3334: --lv_rtn_invoice_num, --'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
3335: for_std_inv_rec_r.payment_method_lookup_code,
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) ;
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) ;
3359:
3360: INSERT INTO ap_invoice_lines_interface (
3361: invoice_id,
3362: invoice_line_id,
3377: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
3378: 'ITEM',
3379: insertion_amount,
3380: v_prepay_dist_date, --bug 3112711 kpvs TRUNC( SYSDATE )
3381: lv_standard_return_excess, --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ,
3382: -- for_dist_inst_rec.dist_code_combination_id, --Commented by Ajay Sharma on 09-AUG-01
3383: for_dist_insertion_tds_rec.dist_code_combination_id, --Added by Ajay Sharma on 09-AUG-01
3384: p_created_by,
3385: p_creation_date,
3407: p_invoice_tds_authority_amt => (-1)*insertion_amount * NVL(get_exchange_rate_base_inv_rec.exchange_rate,1),
3408: p_vendor_id => for_std_inv_rec_r.vendor_id,
3409: p_vendor_site_id => for_std_inv_rec_r.vendor_site_id,
3410: p_invoice_vendor_num => 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
3411: p_invoice_vendor_type => 'STANDARD',
3412: p_invoice_vendor_curr => for_std_inv_rec_r.invoice_currency_code,
3413: p_invoice_vendor_amt => insertion_amount,
3414: p_parent_inv_payment_priority => ln_prnt_pay_priority,
3415: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
3706:
3707: 2. 07/07/2002 Aparajita Das for bug # 2439034
3708: Added the section (elsif) for APPLY and UNAPPLY.
3709:
3710: APPLY caters to the situation where a prepayment is applied to the standard invoice. In this
3711: case the calling program (jai_ap_tds_old_pkg.process_prepayment_apply), that is the concurrent for apply sends the
3712: tds credit note and return invoice for vendor concatenated in the p_invoice_num parameter
3713: separated by a ';'.
3714: