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_ALL

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 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 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 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: