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_AW_ANTICIPATED_DATA dependencies on IGF_AW_ANTICPT_INTS

Line 8: p_interface igf_aw_anticpt_ints%ROWTYPE,

4:
5: PROCEDURE process_anti_data(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
6: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
7: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
8: p_interface igf_aw_anticpt_ints%ROWTYPE,
9: p_delete_flag VARCHAR2)
10: IS
11: ------------------------------------------------------------------
12: --Created by : ridas, Oracle India

Line 427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');

423: END IF;
424:
425: IF p_delete_flag = 'Y' THEN
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');
428: END IF;
429:
430: DELETE FROM igf_aw_anticpt_ints
431: WHERE batch_num = p_interface.batch_num

Line 430: DELETE FROM igf_aw_anticpt_ints

426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');
428: END IF;
429:
430: DELETE FROM igf_aw_anticpt_ints
431: WHERE batch_num = p_interface.batch_num
432: AND ci_alternate_code = p_interface.ci_alternate_code
433: AND ld_alternate_code = p_interface.ld_alternate_code
434: AND person_number = p_interface.person_number;

Line 438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');

434: AND person_number = p_interface.person_number;
435:
436: ELSE
437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
439: END IF;
440:
441: UPDATE igf_aw_anticpt_ints
442: SET IMPORT_STATUS_TYPE = 'I'

Line 441: UPDATE igf_aw_anticpt_ints

437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
439: END IF;
440:
441: UPDATE igf_aw_anticpt_ints
442: SET IMPORT_STATUS_TYPE = 'I'
443: WHERE batch_num = p_interface.batch_num
444: AND ci_alternate_code = p_interface.ci_alternate_code
445: AND ld_alternate_code = p_interface.ld_alternate_code

Line 459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');

455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');
456: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
457:
458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
460: END IF;
461:
462: UPDATE igf_aw_anticpt_ints
463: SET IMPORT_STATUS_TYPE = 'E'

Line 462: UPDATE igf_aw_anticpt_ints

458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
460: END IF;
461:
462: UPDATE igf_aw_anticpt_ints
463: SET IMPORT_STATUS_TYPE = 'E'
464: WHERE batch_num = p_interface.batch_num
465: AND ci_alternate_code = p_interface.ci_alternate_code
466: AND ld_alternate_code = p_interface.ld_alternate_code

Line 508: CURSOR c_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,

504: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
505: -------------------------------------------------------------------
506:
507: --Cursor to retrieve Anticipated Data From Interface Table
508: CURSOR c_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
509: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
510: IS
511: SELECT intf.*
512: FROM igf_aw_anticpt_ints intf

Line 509: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)

505: -------------------------------------------------------------------
506:
507: --Cursor to retrieve Anticipated Data From Interface Table
508: CURSOR c_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
509: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
510: IS
511: SELECT intf.*
512: FROM igf_aw_anticpt_ints intf
513: WHERE intf.batch_num = cp_batch_id

Line 512: FROM igf_aw_anticpt_ints intf

508: CURSOR c_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
509: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
510: IS
511: SELECT intf.*
512: FROM igf_aw_anticpt_ints intf
513: WHERE intf.batch_num = cp_batch_id
514: AND intf.ci_alternate_code = cp_alternate_code
515: AND intf.import_status_type = 'R'
516: AND intf.import_record_type in ('I','U')

Line 521: CURSOR c_chk_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,

517: ORDER BY intf.person_number;
518:
519:
520: --Cursor to check Anticipated Data From Interface Table with status as 'R'
521: CURSOR c_chk_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
522: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
523: IS
524: SELECT 'x' val
525: FROM igf_aw_anticpt_ints intf

Line 522: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)

518:
519:
520: --Cursor to check Anticipated Data From Interface Table with status as 'R'
521: CURSOR c_chk_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
522: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
523: IS
524: SELECT 'x' val
525: FROM igf_aw_anticpt_ints intf
526: WHERE intf.batch_num = cp_batch_id

Line 525: FROM igf_aw_anticpt_ints intf

521: CURSOR c_chk_interface(cp_batch_id igf_aw_anticpt_ints.batch_num%TYPE,
522: cp_alternate_code igf_aw_anticpt_ints.ci_alternate_code%TYPE)
523: IS
524: SELECT 'x' val
525: FROM igf_aw_anticpt_ints intf
526: WHERE intf.batch_num = cp_batch_id
527: AND intf.ci_alternate_code = cp_alternate_code
528: AND intf.import_status_type = 'R'
529: AND intf.import_record_type in ('I','U')

Line 583: lv_person_number igf_aw_anticpt_ints.person_number%TYPE;

579: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
580: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
581: ln_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
582: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
583: lv_person_number igf_aw_anticpt_ints.person_number%TYPE;
584: param_exception EXCEPTION;
585:
586: BEGIN
587: igf_aw_gen.set_org_id(NULL);

Line 711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

707: fnd_message.set_token('FIELD','LD_ALTERNATE_CODE'||': '||l_interface.ld_alternate_code);
708: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
709:
710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
712: END IF;
713:
714: UPDATE igf_aw_anticpt_ints
715: SET IMPORT_STATUS_TYPE = 'E'

Line 714: UPDATE igf_aw_anticpt_ints

710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
712: END IF;
713:
714: UPDATE igf_aw_anticpt_ints
715: SET IMPORT_STATUS_TYPE = 'E'
716: WHERE batch_num = l_interface.batch_num
717: AND ci_alternate_code = l_interface.ci_alternate_code
718: AND ld_alternate_code = l_interface.ld_alternate_code

Line 744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

740: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
741: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
742:
743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
745: END IF;
746:
747: UPDATE igf_aw_anticpt_ints
748: SET IMPORT_STATUS_TYPE = 'E'

Line 747: UPDATE igf_aw_anticpt_ints

743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
745: END IF;
746:
747: UPDATE igf_aw_anticpt_ints
748: SET IMPORT_STATUS_TYPE = 'E'
749: WHERE batch_num = l_interface.batch_num
750: AND ci_alternate_code = l_interface.ci_alternate_code
751: AND ld_alternate_code = l_interface.ld_alternate_code

Line 773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

769: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
770: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
771:
772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
774: END IF;
775:
776: UPDATE igf_aw_anticpt_ints
777: SET IMPORT_STATUS_TYPE = 'E'

Line 776: UPDATE igf_aw_anticpt_ints

772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
774: END IF;
775:
776: UPDATE igf_aw_anticpt_ints
777: SET IMPORT_STATUS_TYPE = 'E'
778: WHERE batch_num = l_interface.batch_num
779: AND ci_alternate_code = l_interface.ci_alternate_code
780: AND ld_alternate_code = l_interface.ld_alternate_code