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.IGS_FI_LOAD_EXT_CHG dependencies on IGS_FI_EXT_INT

Line 12: IGS_FI_EXT_INT_ALL Table. It is called from the

8: /******************************************************************
9: Created By :Suraj Chakma
10: Date Created By :02-06-2000
11: Purpose :This procedure validates the data entered into
12: IGS_FI_EXT_INT_ALL Table. It is called from the
13: form IGSFI038.fmb - EXTERNAL CHARGES
14: Known limitations,
15: enhancements,
16: remarks :

Line 63: Removed transaction_dt from igs_fi_ext_int_pkg.update_row

59: Also Introduced currency descrption allong with the amount. - Log File looks imporoved - Hard coded english text remived
60: sykrishn 03-JUL-220 Bug 2442163 - Procedure igs_fi_extto_imp modified to insert sysdate to
61: transaction_dt in the table igs_fi_impchgs_lines table
62: Reference to l_cur_fei.transaction_dt is removed as it will never be present.
63: Removed transaction_dt from igs_fi_ext_int_pkg.update_row
64:
65: smadathi 24-Jun-2002 Bug 2404720. Procedure igs_fi_extto_imp modified.
66: jbegum 14-Jun-2002 BUG#2413574 Modified cursor cur_fei in procedure igs_fi_extto_imp.
67: jbegum 12-Jun-2002 Bug#2403209 Removed code that calculated the transaction amount

Line 68: as a product of Charge Rate and Charge Elements columns of IGS_FI_EXT_INT

64:
65: smadathi 24-Jun-2002 Bug 2404720. Procedure igs_fi_extto_imp modified.
66: jbegum 14-Jun-2002 BUG#2413574 Modified cursor cur_fei in procedure igs_fi_extto_imp.
67: jbegum 12-Jun-2002 Bug#2403209 Removed code that calculated the transaction amount
68: as a product of Charge Rate and Charge Elements columns of IGS_FI_EXT_INT
69: table and inserted that value in the transaction amount column of the
70: IGS_FI_IMPCHGS_LINES table.
71: Now the transaction amount column value of IGS_FI_EXT_INT is directly
72: imported into the transaction amount column of the IGS_FI_IMPCHGS_LINES

Line 71: Now the transaction amount column value of IGS_FI_EXT_INT is directly

67: jbegum 12-Jun-2002 Bug#2403209 Removed code that calculated the transaction amount
68: as a product of Charge Rate and Charge Elements columns of IGS_FI_EXT_INT
69: table and inserted that value in the transaction amount column of the
70: IGS_FI_IMPCHGS_LINES table.
71: Now the transaction amount column value of IGS_FI_EXT_INT is directly
72: imported into the transaction amount column of the IGS_FI_IMPCHGS_LINES
73: table.
74: agairola 04-Jun-2002 Bug 2395663 - Modified the TBH call for the IGS_FI_IMPCHGS_LINES_PKG
75: Added one function for validating the DFF

Line 84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,

80: vchappid 12-APR-2001 Modified input parameters as per new Ancillary,External Charges DLD
81:
82: ******************************************************************/
83:
84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,

Line 85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,

81:
82: ******************************************************************/
83:
84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,

Line 86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,

82: ******************************************************************/
83:
84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,

Line 87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,

83:
84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,
91: p_d_gl_date DATE,

Line 88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,

84: FUNCTION igs_fi_ext_val (p_person_id igs_fi_ext_int_all.person_id%TYPE,
85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,
91: p_d_gl_date DATE,
92: p_message_name OUT NOCOPY VARCHAR2)

Line 89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,

85: p_fee_type igs_fi_ext_int_all.fee_type%TYPE,
86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,
91: p_d_gl_date DATE,
92: p_message_name OUT NOCOPY VARCHAR2)
93: RETURN BOOLEAN AS

Line 90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,

86: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
87: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE,
88: p_transaction_dt igs_fi_ext_int_all.effective_dt%TYPE ,
89: p_currency_cd igs_fi_ext_int_all.currency_cd%TYPE,
90: p_effective_dt igs_fi_ext_int_all.effective_dt%TYPE,
91: p_d_gl_date DATE,
92: p_message_name OUT NOCOPY VARCHAR2)
93: RETURN BOOLEAN AS
94: /***

Line 303: p_person_id igs_fi_ext_int_all.person_id%TYPE ,

299:
300: PROCEDURE igs_fi_extto_imp(errbuf OUT NOCOPY VARCHAR2,
301: retcode OUT NOCOPY NUMBER,
302: p_org_id NUMBER,
303: p_person_id igs_fi_ext_int_all.person_id%TYPE ,
304: p_fee_type igs_fi_ext_int_all.fee_type%TYPE ,
305: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
306: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE
307: ) AS

Line 304: p_fee_type igs_fi_ext_int_all.fee_type%TYPE ,

300: PROCEDURE igs_fi_extto_imp(errbuf OUT NOCOPY VARCHAR2,
301: retcode OUT NOCOPY NUMBER,
302: p_org_id NUMBER,
303: p_person_id igs_fi_ext_int_all.person_id%TYPE ,
304: p_fee_type igs_fi_ext_int_all.fee_type%TYPE ,
305: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
306: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE
307: ) AS
308: /******************************************************************

Line 305: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,

301: retcode OUT NOCOPY NUMBER,
302: p_org_id NUMBER,
303: p_person_id igs_fi_ext_int_all.person_id%TYPE ,
304: p_fee_type igs_fi_ext_int_all.fee_type%TYPE ,
305: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
306: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE
307: ) AS
308: /******************************************************************
309: Created By :Suraj Chakma

Line 306: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE

302: p_org_id NUMBER,
303: p_person_id igs_fi_ext_int_all.person_id%TYPE ,
304: p_fee_type igs_fi_ext_int_all.fee_type%TYPE ,
305: p_fee_cal_type igs_fi_ext_int_all.fee_cal_type%TYPE,
306: p_fee_ci_sequence_number igs_fi_ext_int_all.fee_ci_sequence_number%TYPE
307: ) AS
308: /******************************************************************
309: Created By :Suraj Chakma
310: Date Created By :02-06-2000

Line 313: the IGS_FI_EXT_INT_ALL Table to the IGS_FI_IMP_CHGS_ALL

309: Created By :Suraj Chakma
310: Date Created By :02-06-2000
311: Purpose :This process is called by the concurrent manager
312: from concurrent program IGSFIJ21 to load data from
313: the IGS_FI_EXT_INT_ALL Table to the IGS_FI_IMP_CHGS_ALL
314: and IGS_FI_IMPCHGS_LINES Tables
315: Known limitations,
316: enhancements,
317: remarks :

Line 352: igs_fi_impchgs_lines_pkg.insert_row and igs_fi_ext_int_pkg.update_row as these

348: 5. DFF changed to IGS_FI_INVLN_INT_ALL_FLEX from IGS_FI_IMPCHGS_EXT_FLEX
349: 6. Removed cursor cur_imp_chgs and the associated local variables
350: sarakshi 13-sep-2002 Enh#2564643,removed the reference of subaccount id from this procedure
351: vvutukur 29-Jul-2002 Bug#2425767.removed parameters x_chg_rate,x_chg_elements from the calls to
352: igs_fi_impchgs_lines_pkg.insert_row and igs_fi_ext_int_pkg.update_row as these
353: columns are obsoleted.removed transaction_type from call to igs_fi_ext_int_pkg.update_row.
354: SYKRISHN 10_JUL_2002 Bug 2438874 - Procedure igs_fi_extto_imp modified to log Transaction Amount along with
355: the other data elemets already present
356: Also Introduced currency descrption allong with the amount.

Line 353: columns are obsoleted.removed transaction_type from call to igs_fi_ext_int_pkg.update_row.

349: 6. Removed cursor cur_imp_chgs and the associated local variables
350: sarakshi 13-sep-2002 Enh#2564643,removed the reference of subaccount id from this procedure
351: vvutukur 29-Jul-2002 Bug#2425767.removed parameters x_chg_rate,x_chg_elements from the calls to
352: igs_fi_impchgs_lines_pkg.insert_row and igs_fi_ext_int_pkg.update_row as these
353: columns are obsoleted.removed transaction_type from call to igs_fi_ext_int_pkg.update_row.
354: SYKRISHN 10_JUL_2002 Bug 2438874 - Procedure igs_fi_extto_imp modified to log Transaction Amount along with
355: the other data elemets already present
356: Also Introduced currency descrption allong with the amount.
357: sykrishn 03-JUL-220 Bug 2442163 - Procedure igs_fi_extto_imp modified to insert sysdate to

Line 360: Removed transaction_dt from igs_fi_ext_int_pkg.update_row

356: Also Introduced currency descrption allong with the amount.
357: sykrishn 03-JUL-220 Bug 2442163 - Procedure igs_fi_extto_imp modified to insert sysdate to
358: transaction_dt in the table igs_fi_impchgs_lines table
359: Reference to l_cur_fei.transaction_dt is removed as it will never be present.
360: Removed transaction_dt from igs_fi_ext_int_pkg.update_row
361: smadathi 24-Jun-2002 Bug 2404720. The concatenated description comprising of fee desc
362: and transaction date which was initially passed as parameter to charges
363: API was modified to pass only fee type description.
364: jbegum 14-Jun-2002 BUG#2413574 Modified the cursor cur_fei,by removing the and condition

Line 379: l_ext_status igs_fi_ext_int_all.status%TYPE;

375: Schodava 4-12-2000 Removal of parameters Course_cd and Version_number
376: vchappid 12-Apr-2001 Modified Logic as per new Ancillary,External Charges DLD
377: ******************************************************************/
378:
379: l_ext_status igs_fi_ext_int_all.status%TYPE;
380: l_cst_success CONSTANT igs_fi_ext_int_all.status%TYPE := 'SUCCESS';
381: l_cst_error CONSTANT igs_fi_ext_int_all.status%TYPE := 'ERROR';
382: l_cst_todo CONSTANT igs_fi_ext_int_all.status%TYPE := 'TODO';
383: l_b_ext_val_flag BOOLEAN ;

Line 380: l_cst_success CONSTANT igs_fi_ext_int_all.status%TYPE := 'SUCCESS';

376: vchappid 12-Apr-2001 Modified Logic as per new Ancillary,External Charges DLD
377: ******************************************************************/
378:
379: l_ext_status igs_fi_ext_int_all.status%TYPE;
380: l_cst_success CONSTANT igs_fi_ext_int_all.status%TYPE := 'SUCCESS';
381: l_cst_error CONSTANT igs_fi_ext_int_all.status%TYPE := 'ERROR';
382: l_cst_todo CONSTANT igs_fi_ext_int_all.status%TYPE := 'TODO';
383: l_b_ext_val_flag BOOLEAN ;
384:

Line 381: l_cst_error CONSTANT igs_fi_ext_int_all.status%TYPE := 'ERROR';

377: ******************************************************************/
378:
379: l_ext_status igs_fi_ext_int_all.status%TYPE;
380: l_cst_success CONSTANT igs_fi_ext_int_all.status%TYPE := 'SUCCESS';
381: l_cst_error CONSTANT igs_fi_ext_int_all.status%TYPE := 'ERROR';
382: l_cst_todo CONSTANT igs_fi_ext_int_all.status%TYPE := 'TODO';
383: l_b_ext_val_flag BOOLEAN ;
384:
385: -- New variable added by sykrishn to validate DFFs bug 2324088

Line 382: l_cst_todo CONSTANT igs_fi_ext_int_all.status%TYPE := 'TODO';

378:
379: l_ext_status igs_fi_ext_int_all.status%TYPE;
380: l_cst_success CONSTANT igs_fi_ext_int_all.status%TYPE := 'SUCCESS';
381: l_cst_error CONSTANT igs_fi_ext_int_all.status%TYPE := 'ERROR';
382: l_cst_todo CONSTANT igs_fi_ext_int_all.status%TYPE := 'TODO';
383: l_b_ext_val_flag BOOLEAN ;
384:
385: -- New variable added by sykrishn to validate DFFs bug 2324088
386: l_b_dff_validate BOOLEAN ;

Line 388: CURSOR cur_fei (cp_person_id igs_fi_ext_int.person_id%TYPE,

384:
385: -- New variable added by sykrishn to validate DFFs bug 2324088
386: l_b_dff_validate BOOLEAN ;
387: -- Cursor for fetching records of TODO status
388: CURSOR cur_fei (cp_person_id igs_fi_ext_int.person_id%TYPE,
389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,
390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,
391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS
392: SELECT *

Line 389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,

385: -- New variable added by sykrishn to validate DFFs bug 2324088
386: l_b_dff_validate BOOLEAN ;
387: -- Cursor for fetching records of TODO status
388: CURSOR cur_fei (cp_person_id igs_fi_ext_int.person_id%TYPE,
389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,
390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,
391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS
392: SELECT *
393: FROM igs_fi_ext_int

Line 390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,

386: l_b_dff_validate BOOLEAN ;
387: -- Cursor for fetching records of TODO status
388: CURSOR cur_fei (cp_person_id igs_fi_ext_int.person_id%TYPE,
389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,
390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,
391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS
392: SELECT *
393: FROM igs_fi_ext_int
394: WHERE (person_id = cp_person_id OR (cp_person_id IS NULL))

Line 391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS

387: -- Cursor for fetching records of TODO status
388: CURSOR cur_fei (cp_person_id igs_fi_ext_int.person_id%TYPE,
389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,
390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,
391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS
392: SELECT *
393: FROM igs_fi_ext_int
394: WHERE (person_id = cp_person_id OR (cp_person_id IS NULL))
395: AND (fee_type = cp_fee_type OR (cp_fee_type IS NULL))

Line 393: FROM igs_fi_ext_int

389: cp_fee_type igs_fi_ext_int.fee_type%TYPE,
390: cp_fee_cal_type igs_fi_ext_int.fee_cal_type%TYPE,
391: cp_fee_ci_sequence_number igs_fi_ext_int.fee_ci_sequence_number%TYPE) IS
392: SELECT *
393: FROM igs_fi_ext_int
394: WHERE (person_id = cp_person_id OR (cp_person_id IS NULL))
395: AND (fee_type = cp_fee_type OR (cp_fee_type IS NULL))
396: AND fee_cal_type = cp_fee_cal_type
397: AND fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;

408: l_v_msg_data VARCHAR2(2000);
409: l_v_fee_desc VARCHAR2(100);
410: l_cur_fei cur_fei%ROWTYPE; -- Interface Table Row Type Variable
411: l_v_rec_installed VARCHAR2(1); -- To find which type of Accounts receivables are installed at client side
412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;
413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;
414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;
415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;
416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;

Line 413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;

409: l_v_fee_desc VARCHAR2(100);
410: l_cur_fei cur_fei%ROWTYPE; -- Interface Table Row Type Variable
411: l_v_rec_installed VARCHAR2(1); -- To find which type of Accounts receivables are installed at client side
412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;
413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;
414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;
415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;
416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;
417:

Line 414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;

410: l_cur_fei cur_fei%ROWTYPE; -- Interface Table Row Type Variable
411: l_v_rec_installed VARCHAR2(1); -- To find which type of Accounts receivables are installed at client side
412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;
413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;
414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;
415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;
416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;
417:
418: l_error_message fnd_new_messages.message_name%TYPE;

Line 415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;

411: l_v_rec_installed VARCHAR2(1); -- To find which type of Accounts receivables are installed at client side
412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;
413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;
414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;
415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;
416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;
417:
418: l_error_message fnd_new_messages.message_name%TYPE;
419: l_n_err_type NUMBER;

Line 416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;

412: l_override_dr_rec_account_cd igs_fi_ext_int.override_dr_rec_account_cd%TYPE;
413: l_override_cr_rev_account_cd igs_fi_ext_int.override_cr_rev_account_cd%TYPE;
414: l_override_dr_rec_ccid igs_fi_ext_int.override_dr_rec_ccid%TYPE;
415: l_override_cr_rev_ccid igs_fi_ext_int.override_cr_rev_ccid%TYPE;
416: l_transaction_amount igs_fi_ext_int.transaction_amount%TYPE;
417:
418: l_error_message fnd_new_messages.message_name%TYPE;
419: l_n_err_type NUMBER;
420: l_v_err_string igs_fi_invln_int.error_string%TYPE;

Line 799: -- Updating the TODO record status in IGS_FI_EXT_INT_ALL table to SUCCESS once the data is moved.

795: ELSE
796: l_ext_status := l_cst_error;
797: END IF;
798:
799: -- Updating the TODO record status in IGS_FI_EXT_INT_ALL table to SUCCESS once the data is moved.
800: --Modified by sarakshi, bug:2175865, now updating interface table if return status is success earlier code was
801: -- reverse of this
802: -- Added gl_Date in call to update_row
803:

Line 805: igs_fi_ext_int_pkg.update_row ( x_rowid => l_cur_fei.row_id,

801: -- reverse of this
802: -- Added gl_Date in call to update_row
803:
804: BEGIN
805: igs_fi_ext_int_pkg.update_row ( x_rowid => l_cur_fei.row_id,
806: x_external_fee_id => l_cur_fei.external_fee_id,
807: x_person_id => l_cur_fei.person_id,
808: x_status => l_ext_status,
809: x_fee_type => l_cur_fei.fee_type,