eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_OLD_PKG dependencies on JAI_AP_TDS_OLD_PKG

Line 1: PACKAGE BODY jai_ap_tds_old_pkg

1: PACKAGE BODY jai_ap_tds_old_pkg
2: /* $Header: jai_ap_tds_old.plb 120.8 2007/05/10 09:46:39 rallamse ship $ */
3: AS
4:
5: /*------------------------------------------------------------------------------------------

Line 70: lv_procedure_name VARCHAR2(25); -- := 'jai_ap_tds_old_pkg.cancel_invoice'; --Ramananda for File.Sql.35

66: ) IS
67:
68: --cbabu Bug#2448040
69: lv_statement_no VARCHAR2(3); -- := '0'; --Ramananda for File.Sql.35
70: lv_procedure_name VARCHAR2(25); -- := 'jai_ap_tds_old_pkg.cancel_invoice'; --Ramananda for File.Sql.35
71: lv_error_mesg VARCHAR2(255); -- := ''; --Ramananda for File.Sql.35
72:
73: /*CURSOR cancelled_invoices IS
74: SELECT *

Line 256: CHANGE HISTORY for FILENAME: jai_ap_tds_old_pkg.cancel_invoice_p.sql

252: BEGIN
253:
254: /* Cancellation of invoice */
255: /*------------------------------------------------------------------------------------------
256: CHANGE HISTORY for FILENAME: jai_ap_tds_old_pkg.cancel_invoice_p.sql
257: S.No Date Author and Details
258: ------------------------------------------------------------------------------------------
259: 1 03-Dec-2001 Pavan : Code modified to populate the fields goods_received_date,
260: invoice_received_date into interfaces inorder to prevent it from

Line 389: lv_procedure_name := 'jai_ap_tds_old_pkg.cancel_invoice';

385: -- OPEN cancelled_invoices;
386:
387: /* Ramananda for File.Sql.35 */
388: lv_statement_no := '0';
389: lv_procedure_name := 'jai_ap_tds_old_pkg.cancel_invoice';
390: lv_error_mesg := '';
391: v_flag := 'N';
392: v_Approved_Invoice_Flag := 'N'; -- added by Aparajita on 29/07/2002 for bug # 2475416
393:

Line 1205: FILENAME: jai_ap_tds_old_pkg.process_prepayment_unapply.sql

1201:
1202: /* PrePayment to Standard */
1203:
1204: /*---------------------------------------------------------------------------------------------------------------------
1205: FILENAME: jai_ap_tds_old_pkg.process_prepayment_unapply.sql
1206:
1207: CHANGE HISTORY:
1208: Sl. No Date Author and Details
1209: 1. 10/07/2002 Aparajita Das for bug # 2439034. RCS version 615.1

Line 1274: lv_object_name := 'jai_ap_tds_old_pkg.process_prepayment_unapply'; /* Added by Ramananda for bug#4407165 */

1270: ----------------------------------------------------------------------------------------------------*/
1271: BEGIN
1272:
1273: v_Approved_Invoice_Flag := 'N'; -- added by Aparajita for bug # 2441683 on 23/07/2002 --Ramananda for File.Sql.35
1274: lv_object_name := 'jai_ap_tds_old_pkg.process_prepayment_unapply'; /* Added by Ramananda for bug#4407165 */
1275:
1276: OPEN check_prep_amt_app(p_prepay_dist_id,p_invoice_id);
1277: FETCH check_prep_amt_app INTO check_prep_amt_app_rec;
1278: CLOSE check_prep_amt_app;

Line 2299: FILENAME: jai_ap_tds_old_pkg.process_prepayment_apply.sql

2295: BEGIN
2296:
2297: -- DECODE(vendor_rec.exchange_rate_type,'USER',vendor_rec.exchange_rate,NULL),
2298: /*------------------------------------------------------------------------------------------
2299: FILENAME: jai_ap_tds_old_pkg.process_prepayment_apply.sql
2300:
2301: CHANGE HISTORY:
2302: S.No Date Author Details
2303: -------------------------------------------------------------------------------------------------------------

Line 2337: approving the credit memo (jai_ap_tds_old_pkg.approve_invoice),expects the name to start

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
2341: This procedure was giving ORA-08002:sequence

Line 2353: object is jai_ap_tds_old_pkg.process_prepayment_unapply.

2349: procedure was raising a no data found exception. Added Fnd_File.put_line(Fnd_File.LOG,'') statements to generate log for this concurrent.
2350:
2351: 11. 08-july-2002 Aparajita Bug # 2439034.
2352: Changes on the same line as that done for this bug in unapply prepayment, the
2353: object is jai_ap_tds_old_pkg.process_prepayment_unapply.
2354:
2355: Change is to call the procedure for approval with code as 'APPLY' and the
2356: invoice and credit memo numbers concatenated.
2357:

Line 2473: X:=jai_ap_tds_old_pkg.get_invoice_status(

2469: OPEN get_fun_det1(p_invoice_id);
2470: FETCH get_fun_det1 INTO get_fun_det_r1;
2471: CLOSE get_fun_det1;
2472:
2473: X:=jai_ap_tds_old_pkg.get_invoice_status(
2474: p_invoice_id,
2475: get_fun_det_r1.invoice_amount,
2476: get_fun_det_r1.payment_status_flag,
2477: get_fun_det_r1.invoice_type_lookup_code,

Line 3539: lv_app_source := 'jai_ap_tds_old_pkg.process_prepayment_apply'; --rchandan for bug#4428980

3535:
3536: WHEN OTHERS THEN
3537:
3538: error_mesg := SQLERRM;
3539: lv_app_source := 'jai_ap_tds_old_pkg.process_prepayment_apply'; --rchandan for bug#4428980
3540: lv_add_err_msg := 'EXCEPTION captured BY WHEN OTHERS IN the PROCEDURE. stage - ' || TO_CHAR(v_stage); --rchandan for bug#4428980
3541:
3542: INSERT INTO JAI_CMN_ERRORS_T (
3543: APPLICATION_SOURCE,

Line 3698: FILENAME: jai_ap_tds_old_pkg.approve_invoice_p.sql

3694:
3695: BEGIN
3696:
3697: /*------------------------------------------------------------------------------------------
3698: FILENAME: jai_ap_tds_old_pkg.approve_invoice_p.sql
3699: CHANGE HISTORY:
3700: S.No Date Author and Details
3701:
3702: 1 15-Apr-01 Ajay Sharma

Line 3711: case the calling program (jai_ap_tds_old_pkg.process_prepayment_apply), that is the concurrent for apply sends the

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:
3715: UNAPPLY caters to the situation where an applied invoice is unapplied.

Line 3716: In this case the calling program (jai_ap_tds_old_pkg.process_prepayment_unapply, that is the concurrent for

3712: tds credit note and return invoice for vendor concatenated in the p_invoice_num parameter
3713: separated by a ';'.
3714:
3715: UNAPPLY caters to the situation where an applied invoice is unapplied.
3716: In this case the calling program (jai_ap_tds_old_pkg.process_prepayment_unapply, that is the concurrent for
3717: unapply sends the concatenated invoice_numbers in the p_invoice_num parameter.
3718: The invoices numbers to be approved are always two, the tds invoice and the credit memo. These
3719: two invoices are separated by a ';'.
3720:

Line 3735: lv_object_name := 'jai_ap_tds_old_pkg.approve_invoice'; /* Added by Ramananda for bug#4407165 */

3731:
3732:
3733: ----------------------------------------------------------------------------------------------------------------------*/
3734:
3735: lv_object_name := 'jai_ap_tds_old_pkg.approve_invoice'; /* Added by Ramananda for bug#4407165 */
3736:
3737: v_parent_request_id := p_parent_request_id;
3738: OPEN Fetch_Set_Of_Books_Id_Cur(p_invoice_id);
3739: FETCH Fetch_Set_Of_Books_Id_Cur INTO v_set_of_books_id;

Line 4346: END jai_ap_tds_old_pkg;

4342: RETURN(invoice_approval_status);
4343: END get_invoice_status ;
4344:
4345:
4346: END jai_ap_tds_old_pkg;