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_AP_FA_ANT_DATA

Line 26: CURSOR c_org_unit(cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE)

22: -------------------------------------------------------------------
23:
24:
25: --Cursor to fetch organizational unit
26: CURSOR c_org_unit(cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE)
27: IS
28: SELECT 'x'
29: FROM igs_or_inst_org_base_v
30: WHERE party_number = cp_org_unit

Line 38: CURSOR c_prog_type(cp_prog_type igf_ap_fa_ant_data.program_type%TYPE)

34: l_org_unit c_org_unit%ROWTYPE;
35:
36:
37: --Cursor to fetch program type
38: CURSOR c_prog_type(cp_prog_type igf_ap_fa_ant_data.program_type%TYPE)
39: IS
40: SELECT 'x'
41: FROM igs_ps_type_v
42: WHERE course_type = cp_prog_type

Line 49: CURSOR c_prog_loc(cp_prog_loc igf_ap_fa_ant_data.program_location_cd%TYPE)

45: l_prog_type c_prog_type%ROWTYPE;
46:
47:
48: --Cursor to fetch program location
49: CURSOR c_prog_loc(cp_prog_loc igf_ap_fa_ant_data.program_location_cd%TYPE)
50: IS
51: SELECT 'x'
52: FROM igs_ad_location
53: WHERE location_cd = cp_prog_loc

Line 60: CURSOR c_prog_cd(cp_prog_cd igf_ap_fa_ant_data.program_cd%TYPE)

56: l_prog_loc c_prog_loc%ROWTYPE;
57:
58:
59: --Cursor to fetch program code
60: CURSOR c_prog_cd(cp_prog_cd igf_ap_fa_ant_data.program_cd%TYPE)
61: IS
62: SELECT 'x'
63: FROM igs_ps_ver
64: WHERE course_cd = cp_prog_cd

Line 72: CURSOR c_class_stnd(cp_class_stnd igf_ap_fa_ant_data.class_standing%TYPE)

68: l_prog_cd c_prog_cd%ROWTYPE;
69:
70:
71: --Cursor to fetch class standing
72: CURSOR c_class_stnd(cp_class_stnd igf_ap_fa_ant_data.class_standing%TYPE)
73: IS
74: SELECT 'x'
75: FROM igs_pr_class_std_v
76: WHERE class_standing = cp_class_stnd

Line 99: CURSOR c_atten_type(cp_atten_type igf_ap_fa_ant_data.attendance_type%TYPE)

95: l_house_status c_res_status%ROWTYPE;
96:
97:
98: --Cursor to fetch attendance type
99: CURSOR c_atten_type(cp_atten_type igf_ap_fa_ant_data.attendance_type%TYPE)
100: IS
101: SELECT 'x'
102: FROM igs_en_atd_type
103: WHERE attendance_type = cp_atten_type

Line 110: CURSOR c_atten_mode(cp_atten_mode igf_ap_fa_ant_data.attendance_mode%TYPE)

106: l_atten_type c_atten_type%ROWTYPE;
107:
108:
109: --Cursor to fetch attendance mode
110: CURSOR c_atten_mode(cp_atten_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
111: IS
112: SELECT 'x'
113: FROM igs_en_atd_mode
114: WHERE attendance_mode = cp_atten_mode

Line 121: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,

117: l_atten_mode c_atten_mode%ROWTYPE;
118:
119:
120: --Cursor to retrieve Anticipated Data
121: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
122: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
123: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
124: IS
125: SELECT ant.rowid row_id,

Line 122: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,

118:
119:
120: --Cursor to retrieve Anticipated Data
121: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
122: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
123: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
124: IS
125: SELECT ant.rowid row_id,
126: ant.*

Line 123: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)

119:
120: --Cursor to retrieve Anticipated Data
121: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
122: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
123: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
124: IS
125: SELECT ant.rowid row_id,
126: ant.*
127: FROM igf_ap_fa_ant_data ant

Line 127: FROM igf_ap_fa_ant_data ant

123: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
124: IS
125: SELECT ant.rowid row_id,
126: ant.*
127: FROM igf_ap_fa_ant_data ant
128: WHERE base_id = cp_base_id
129: AND ld_cal_type = cp_ld_cal_type
130: AND ld_sequence_number = cp_ld_sequence_number;
131:

Line 367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');

363: FETCH c_ant_data INTO l_ant_data;
364: CLOSE c_ant_data;
365:
366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');
368: END IF;
369:
370:
371: igf_ap_fa_ant_data_pkg.update_row (

Line 371: igf_ap_fa_ant_data_pkg.update_row (

367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');
368: END IF;
369:
370:
371: igf_ap_fa_ant_data_pkg.update_row (
372: x_mode => 'R',
373: x_rowid => l_ant_data.row_id,
374: x_base_id => p_base_id,
375: x_ld_cal_type => l_ant_data.ld_cal_type,

Line 397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');

393: ELSIF p_interface.import_record_type = 'I' THEN
394: lv_rowid := NULL;
395:
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');
398: END IF;
399:
400: igf_ap_fa_ant_data_pkg.insert_row (
401: x_mode => 'R',

Line 400: igf_ap_fa_ant_data_pkg.insert_row (

396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');
398: END IF;
399:
400: igf_ap_fa_ant_data_pkg.insert_row (
401: x_mode => 'R',
402: x_rowid => lv_rowid,
403: x_base_id => p_base_id,
404: x_ld_cal_type => p_ld_cal_type,

Line 536: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,

532: l_chk_interface c_chk_interface%ROWTYPE;
533:
534:
535: --Cursor to retrieve Anticipated Data
536: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
537: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
538: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
539: IS
540: SELECT ant.base_id

Line 537: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,

533:
534:
535: --Cursor to retrieve Anticipated Data
536: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
537: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
538: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
539: IS
540: SELECT ant.base_id
541: FROM igf_ap_fa_ant_data ant

Line 538: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)

534:
535: --Cursor to retrieve Anticipated Data
536: CURSOR c_ant_data (cp_base_id igf_ap_fa_ant_data.base_id%TYPE,
537: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
538: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
539: IS
540: SELECT ant.base_id
541: FROM igf_ap_fa_ant_data ant
542: WHERE base_id = cp_base_id

Line 541: FROM igf_ap_fa_ant_data ant

537: cp_ld_cal_type igf_ap_fa_ant_data.ld_cal_type%TYPE,
538: cp_ld_sequence_number igf_ap_fa_ant_data.ld_sequence_number%TYPE)
539: IS
540: SELECT ant.base_id
541: FROM igf_ap_fa_ant_data ant
542: WHERE base_id = cp_base_id
543: AND ld_cal_type = cp_ld_cal_type
544: AND ld_sequence_number = cp_ld_sequence_number;
545: