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.IGF_AP_LG_COA_IMP dependencies on IGF_AW_LI_COA_INTS

Line 15: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,

11:
12: g_log_tab LogTab;
13:
14:
15: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
16: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
17: p_delete_flag IN VARCHAR2 ) IS
18: /*
19: || Created By : masehgal

Line 29: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS

25: || (reverse chronological order - newest change first)
26: */
27:
28: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
29: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
30: SELECT batch_desc, batch_type
31: FROM igf_ap_li_bat_ints
32: WHERE batch_num = cp_batch_num ;
33:

Line 134: CURSOR c_get_person_rec_type ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,

130: || Who When What
131: || (reverse chronological order - newest change first)
132: */
133:
134: CURSOR c_get_person_rec_type ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
135: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE,
136: cp_person_number igf_aw_li_coa_ints.person_number%TYPE) IS
137: SELECT DISTINCT(NVL(import_record_type,'*')) types
138: FROM igf_aw_li_coa_ints

Line 135: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE,

131: || (reverse chronological order - newest change first)
132: */
133:
134: CURSOR c_get_person_rec_type ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
135: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE,
136: cp_person_number igf_aw_li_coa_ints.person_number%TYPE) IS
137: SELECT DISTINCT(NVL(import_record_type,'*')) types
138: FROM igf_aw_li_coa_ints
139: WHERE ci_alternate_code = cp_alternate_code

Line 136: cp_person_number igf_aw_li_coa_ints.person_number%TYPE) IS

132: */
133:
134: CURSOR c_get_person_rec_type ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
135: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE,
136: cp_person_number igf_aw_li_coa_ints.person_number%TYPE) IS
137: SELECT DISTINCT(NVL(import_record_type,'*')) types
138: FROM igf_aw_li_coa_ints
139: WHERE ci_alternate_code = cp_alternate_code
140: AND batch_num = cp_batch_num

Line 138: FROM igf_aw_li_coa_ints

134: CURSOR c_get_person_rec_type ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
135: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE,
136: cp_person_number igf_aw_li_coa_ints.person_number%TYPE) IS
137: SELECT DISTINCT(NVL(import_record_type,'*')) types
138: FROM igf_aw_li_coa_ints
139: WHERE ci_alternate_code = cp_alternate_code
140: AND batch_num = cp_batch_num
141: AND person_number = cp_person_number
142: AND import_status_type IN ('R','U') ;

Line 207: cp_item_code igf_aw_li_coa_ints.item_code%TYPE) IS

203: l_person_terms NUMBER;
204:
205: -- Count all terms for a person for a COA Item
206: CURSOR person_coa_terms ( cp_base_id igf_aw_coa_itm_terms.base_id%TYPE ,
207: cp_item_code igf_aw_li_coa_ints.item_code%TYPE) IS
208: SELECT COUNT(DISTINCT(ld_sequence_number)) coa_terms
209: FROM igf_aw_coa_itm_terms
210: WHERE base_id = cp_base_id
211: AND item_code = cp_item_code ;

Line 446: l_last_person_number igf_aw_li_coa_ints.person_number%TYPE ;

442: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
443: l_rec_processed NUMBER;
444: l_rec_imported NUMBER;
445: l_rec_error NUMBER;
446: l_last_person_number igf_aw_li_coa_ints.person_number%TYPE ;
447: l_item_setup_found BOOLEAN ;
448: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
449: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
450: l_dup_item_found BOOLEAN;

Line 483: CURSOR c_get_persons ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,

479: WHERE map.ci_cal_type = g_ci_cal_type
480: AND map.ci_sequence_number = g_ci_sequence_number ;
481:
482: -- cursor to get persons for import
483: CURSOR c_get_persons ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
484: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
485: SELECT batch_num,
486: coaint_id,
487: ci_alternate_code,

Line 484: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS

480: AND map.ci_sequence_number = g_ci_sequence_number ;
481:
482: -- cursor to get persons for import
483: CURSOR c_get_persons ( cp_alternate_code igf_aw_li_coa_ints.ci_alternate_code%TYPE,
484: cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
485: SELECT batch_num,
486: coaint_id,
487: ci_alternate_code,
488: person_number,

Line 497: FROM igf_aw_li_coa_ints

493: ld_alternate_code,
494: term_amt,
495: import_status_type,
496: import_record_type
497: FROM igf_aw_li_coa_ints
498: WHERE ci_alternate_code = cp_alternate_code
499: AND batch_num = cp_batch_num
500: AND import_status_type IN ('R','U')
501: ORDER BY person_number , item_code, ld_alternate_code;

Line 514: CURSOR c_chk_coa (p_item_code igf_aw_li_coa_ints.item_code%TYPE) IS

510: WHERE cal_type = cp_ci_cal_type
511: AND sequence_number = cp_ci_sequence_number ;
512:
513: -- check COA Setup done
514: CURSOR c_chk_coa (p_item_code igf_aw_li_coa_ints.item_code%TYPE) IS
515: SELECT 1
516: FROM igf_aw_item
517: WHERE item_code = NVL(p_item_code, item_code)
518: AND rownum = 1;

Line 661: UPDATE igf_aw_li_coa_ints

657:
658: ROLLBACK TO coa_person_recs ;
659:
660: -- mark all person records as "E"
661: UPDATE igf_aw_li_coa_ints
662: SET import_status_type = 'E'
663: WHERE batch_num = p_batch_num
664: AND person_number = l_last_person_number ;
665:

Line 690: UPDATE igf_aw_li_coa_ints

686: -- Now rollback ....
687: ROLLBACK TO coa_person_recs ;
688:
689: -- mark all person records as "E"
690: UPDATE igf_aw_li_coa_ints
691: SET import_status_type = 'E'
692: WHERE batch_num = p_batch_num
693: AND person_number = l_last_person_number ;
694: l_rec_imported := l_rec_imported - l_per_item_count;

Line 775: UPDATE igf_aw_li_coa_ints

771:
772: -- person skip flag set....
773: -- if flag set then the person related records aer to be marked as error records and skipped
774: -- update all person records to error status
775: UPDATE igf_aw_li_coa_ints
776: SET import_status_type = 'E'
777: WHERE batch_num = p_batch_num
778: AND person_number = person_rec.person_number ;
779:

Line 928: UPDATE igf_aw_li_coa_ints

924: -- all record validations done ...
925: -- now check for skip record flag
926: IF g_skip_record THEN
927:
928: UPDATE igf_aw_li_coa_ints
929: SET import_status_type = 'E'
930: WHERE coaint_id = person_rec.coaint_id ;
931: -- COMMIT ;
932: ELSE

Line 1049: DELETE FROM igf_aw_li_coa_ints

1045: END IF;
1046:
1047: -- now update the record status
1048: IF p_delete_flag = 'Y' THEN
1049: DELETE FROM igf_aw_li_coa_ints
1050: WHERE coaint_id = person_rec.coaint_id ;
1051:
1052: -- COMMIT ;
1053: ELSE

Line 1055: UPDATE igf_aw_li_coa_ints

1051:
1052: -- COMMIT ;
1053: ELSE
1054:
1055: UPDATE igf_aw_li_coa_ints
1056: SET import_status_type = 'I'
1057: WHERE coaint_id = person_rec.coaint_id ;
1058: l_counter_flag := TRUE;
1059:

Line 1094: UPDATE igf_aw_li_coa_ints

1090:
1091: ROLLBACK TO coa_person_recs ;
1092:
1093: -- mark all person records as "E"
1094: UPDATE igf_aw_li_coa_ints
1095: SET import_status_type = 'E'
1096: WHERE batch_num = p_batch_num
1097: AND person_number = l_last_person_number ;
1098:

Line 1125: UPDATE igf_aw_li_coa_ints

1121: -- Now rollback ....
1122: ROLLBACK TO coa_person_recs ;
1123:
1124: -- mark all person records as "E"
1125: UPDATE igf_aw_li_coa_ints
1126: SET import_status_type = 'E'
1127: WHERE batch_num = p_batch_num
1128: AND person_number = l_last_person_number ;
1129: -- AND item_code = person_rec.item_code;