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_PROFILE_MATCHING_PKG dependencies on IGF_AP_CSS_PROFILE

Line 239: -- cursor to update the active_profile of igf_ap_css_profile to 'N'

235: || Change History :
236: || Who When What
237: || (reverse chronological order - newest change first)
238: */
239: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
240: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
241: SELECT ROWID row_id, css.*
242: FROM igf_ap_css_profile_all css
243: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;

Line 242: FROM igf_ap_css_profile_all css

238: */
239: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
240: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
241: SELECT ROWID row_id, css.*
242: FROM igf_ap_css_profile_all css
243: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
244: BEGIN
245: -- Cursor for updating the active_profile of all the old profile records of the student to 'n'
246: FOR css_profile_data IN cur_css_profile(cp_base_id) LOOP

Line 247: igf_ap_css_profile_pkg.update_row (

243: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
244: BEGIN
245: -- Cursor for updating the active_profile of all the old profile records of the student to 'n'
246: FOR css_profile_data IN cur_css_profile(cp_base_id) LOOP
247: igf_ap_css_profile_pkg.update_row (
248: X_Mode => 'R',
249: x_rowid => css_profile_data.row_id,
250: x_cssp_id => css_profile_data.cssp_id,
251: x_base_id => css_profile_data.base_id,

Line 1120: pn_cssp_id igf_ap_css_profile.cssp_id%TYPE

1116: END create_fa_base_record;
1117:
1118:
1119: PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1120: pn_cssp_id igf_ap_css_profile.cssp_id%TYPE
1121: ) IS
1122:
1123: /*
1124: || Created By : Meghana

Line 1956: pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,

1952: END process_todo_items;
1953:
1954:
1955: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1956: pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,
1957: pn_base_id igf_ap_css_profile.base_id%TYPE,
1958: pn_system_record_type igf_ap_css_profile.system_record_type%TYPE
1959: ) IS
1960: /*

Line 1957: pn_base_id igf_ap_css_profile.base_id%TYPE,

1953:
1954:
1955: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1956: pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,
1957: pn_base_id igf_ap_css_profile.base_id%TYPE,
1958: pn_system_record_type igf_ap_css_profile.system_record_type%TYPE
1959: ) IS
1960: /*
1961: || Created By : Meghana

Line 1958: pn_system_record_type igf_ap_css_profile.system_record_type%TYPE

1954:
1955: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1956: pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,
1957: pn_base_id igf_ap_css_profile.base_id%TYPE,
1958: pn_system_record_type igf_ap_css_profile.system_record_type%TYPE
1959: ) IS
1960: /*
1961: || Created By : Meghana
1962: || Created On : 11-JUN-2001

Line 1980: -- Insert Record in IGF_AP_CSS_PROFILE table

1976: ln_cssp_id NUMBER ;
1977: BEGIN
1978:
1979:
1980: -- Insert Record in IGF_AP_CSS_PROFILE table
1981: FOR cur_css_interface_rec IN cur_css_interface ( pn_css_id)
1982: LOOP
1983:
1984: igf_ap_css_profile_pkg.insert_row(

Line 1984: igf_ap_css_profile_pkg.insert_row(

1980: -- Insert Record in IGF_AP_CSS_PROFILE table
1981: FOR cur_css_interface_rec IN cur_css_interface ( pn_css_id)
1982: LOOP
1983:
1984: igf_ap_css_profile_pkg.insert_row(
1985: x_mode => 'R',
1986: x_rowid => lv_rowid,
1987: x_cssp_id => pn_cssp_id,
1988: x_base_id => pn_base_id,

Line 3580: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;

3576: */
3577: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3578: lv_person_id igf_ap_person_v.person_id%TYPE ;
3579: lv_base_id igf_ap_fa_base_rec.base_id%TYPE ;
3580: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3581: lv_mesg_data VARCHAR2(2000);
3582:
3583:
3584: -- Cursor to update the record_status of igf_ap_person_match to unmatched

Line 3625: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'

3621: create_fa_base_record(pn_css_id => g_cur_data.css_id,
3622: pn_person_id => lv_person_id ,
3623: pn_base_id => lv_base_id
3624: );
3625: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'
3626: g_active_profile := 'Y';
3627: process_todo_items(lv_base_id);
3628: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,
3629: pn_cssp_id => lv_cssp_id ,

Line 3813: css_profile_data igf_ap_css_profile%ROWTYPE ;

3809: || (reverse chronological order - newest change first)
3810: */
3811:
3812: person_data igf_ap_person_match%ROWTYPE;
3813: css_profile_data igf_ap_css_profile%ROWTYPE ;
3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;
3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;

Line 3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;

3810: */
3811:
3812: person_data igf_ap_person_match%ROWTYPE;
3813: css_profile_data igf_ap_css_profile%ROWTYPE ;
3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;
3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3818: fa_base_found BOOLEAN ;

Line 3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;

3812: person_data igf_ap_person_match%ROWTYPE;
3813: css_profile_data igf_ap_css_profile%ROWTYPE ;
3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;
3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3818: fa_base_found BOOLEAN ;
3819:
3820: -- Cursor to update the record_status of igf_ap_person_match to matched

Line 3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;

3813: css_profile_data igf_ap_css_profile%ROWTYPE ;
3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;
3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3818: fa_base_found BOOLEAN ;
3819:
3820: -- Cursor to update the record_status of igf_ap_person_match to matched
3821: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

Line 3832: -- cursor to update the active_profile of igf_ap_css_profile to 'N'

3828: SELECT *
3829: FROM igf_ap_fa_base_rec
3830: WHERE base_id = x_base_id ;
3831:
3832: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
3833: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3834: SELECT *
3835: FROM igf_ap_css_profile
3836: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;

Line 3835: FROM igf_ap_css_profile

3831:
3832: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
3833: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3834: SELECT *
3835: FROM igf_ap_css_profile
3836: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
3837:
3838:
3839: BEGIN

Line 3856: -- To insert the record into igf_ap_css_profile

3852: END IF;
3853: -- Cursor for updating the active_profile of all the old profile records of the student to 'N'
3854: make_profile_inactive(lv_base_id);
3855: g_active_profile := 'Y';
3856: -- To insert the record into igf_ap_css_profile
3857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_profile_matched' );
3859: END IF;
3860:

Line 4264: css_profile_data igf_ap_css_profile%ROWTYPE ;

4260: || Who When What
4261: || (reverse chronological order - newest change first)
4262: */
4263:
4264: css_profile_data igf_ap_css_profile%ROWTYPE ;
4265: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4267: fa_base_found BOOLEAN ;
4268:

Line 4265: css_profile_data1 igf_ap_css_profile%ROWTYPE ;

4261: || (reverse chronological order - newest change first)
4262: */
4263:
4264: css_profile_data igf_ap_css_profile%ROWTYPE ;
4265: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4267: fa_base_found BOOLEAN ;
4268:
4269: -- Cursor to update the record_status of igf_ap_person_match to matched

Line 4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;

4262: */
4263:
4264: css_profile_data igf_ap_css_profile%ROWTYPE ;
4265: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4267: fa_base_found BOOLEAN ;
4268:
4269: -- Cursor to update the record_status of igf_ap_person_match to matched
4270: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

Line 4276: -- cursor to update the active_profile of igf_ap_css_profile to 'N'

4272: FROM igf_ap_person_match apm
4273: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
4274:
4275:
4276: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
4277: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
4278: SELECT *
4279: FROM igf_ap_css_profile
4280: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;

Line 4279: FROM igf_ap_css_profile

4275:
4276: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
4277: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
4278: SELECT *
4279: FROM igf_ap_css_profile
4280: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
4281:
4282: --cursor to get the person_id from base_id
4283: CURSOR cur_get_person_id(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)

Line 4302: -- To insert the record into igf_ap_css_profile

4298: g_duplicate_rec := g_duplicate_rec + 1;
4299: ELSIF g_rec_type = 'O' THEN
4300:
4301: g_active_profile :='N';
4302: -- To insert the record into igf_ap_css_profile
4303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_profile_matched');
4305: END IF;
4306:

Line 4327: -- To insert the record into igf_ap_css_profile

4323: ELSIF g_rec_type = 'N' THEN
4324: --
4325: make_profile_inactive(g_base_id);
4326: g_active_profile := 'Y';
4327: -- To insert the record into igf_ap_css_profile
4328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4329: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_profile_matched');
4330: END IF;
4331:

Line 4431: FROM igf_ap_css_profile

4427: l_valid_found VARCHAR2(1);
4428:
4429: CURSOR cur_css_id_number(cp_acad_year VARCHAR2, cp_css_id_number VARCHAR2) IS
4430: SELECT max(STU_RECORD_TYPE) max_stu_record_type, base_id
4431: FROM igf_ap_css_profile
4432: WHERE TO_NUMBER(academic_year) = cp_acad_year
4433: AND css_id_number = cp_css_id_number
4434: AND STU_RECORD_TYPE <> 'M'
4435: GROUP BY base_id;

Line 4442: FROM igf_ap_css_profile

4438:
4439: -- Cursor to check duplicate
4440: CURSOR cur_check_duplicate(cp_acad_year VARCHAR2, cp_css_id_number VARCHAR2,cp_stu_rec_type VARCHAR2) IS
4441: SELECT 1
4442: FROM igf_ap_css_profile
4443: WHERE TO_NUMBER(academic_year) = cp_acad_year
4444: AND css_id_number = cp_css_id_number
4445: AND STU_RECORD_TYPE = cp_stu_rec_type;
4446: l_duplicate NUMBER;

Line 4917: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;

4913:
4914: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
4915: lv_person_id igf_ap_person_v.person_id%TYPE ;
4916: lv_base_id igf_ap_fa_base_rec.base_id%TYPE ;
4917: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4918: lv_mesg_data VARCHAR2(2000);
4919:
4920: BEGIN
4921:

Line 4967: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'

4963: );
4964: END IF;
4965:
4966:
4967: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'
4968: make_profile_inactive(lv_base_id);
4969: g_active_profile:= 'Y';
4970: process_todo_items(lv_base_id);
4971: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,

Line 5020: FROM IGF_AP_CSS_PROFILE prof

5016: cp_stu_record_type igf_ap_css_interface_all.stu_record_type%TYPE,
5017: cp_academic_year igf_ap_css_interface_all.academic_year%TYPE
5018: ) IS
5019: SELECT 1
5020: FROM IGF_AP_CSS_PROFILE prof
5021: WHERE prof.css_id_number = cp_css_id_number
5022: AND prof.stu_record_type = cp_stu_record_type
5023: AND prof.academic_year = cp_academic_year;
5024:

Line 5032: CURSOR cur_profile_records(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS

5028: FROM IGF_AP_CSS_INTERFACE intr
5029: WHERE intr.css_id = cp_css_id;
5030:
5031: -- Cursor to get all old profile records to make active profile to 'N'
5032: CURSOR cur_profile_records(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS
5033: SELECT prof.*
5034: FROM IGF_AP_CSS_PROFILE prof
5035: WHERE prof.css_id_number = cp_css_id_number FOR UPDATE NOWAIT;
5036:

Line 5034: FROM IGF_AP_CSS_PROFILE prof

5030:
5031: -- Cursor to get all old profile records to make active profile to 'N'
5032: CURSOR cur_profile_records(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS
5033: SELECT prof.*
5034: FROM IGF_AP_CSS_PROFILE prof
5035: WHERE prof.css_id_number = cp_css_id_number FOR UPDATE NOWAIT;
5036:
5037: CURSOR cur_get_base_id(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS
5038: SELECT prof.base_id

Line 5037: CURSOR cur_get_base_id(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS

5033: SELECT prof.*
5034: FROM IGF_AP_CSS_PROFILE prof
5035: WHERE prof.css_id_number = cp_css_id_number FOR UPDATE NOWAIT;
5036:
5037: CURSOR cur_get_base_id(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS
5038: SELECT prof.base_id
5039: FROM IGF_AP_CSS_PROFILE prof
5040: WHERE prof.css_id_number = cp_css_id_number;
5041:

Line 5039: FROM IGF_AP_CSS_PROFILE prof

5035: WHERE prof.css_id_number = cp_css_id_number FOR UPDATE NOWAIT;
5036:
5037: CURSOR cur_get_base_id(cp_css_id_number igf_ap_css_profile.css_id_number%TYPE) IS
5038: SELECT prof.base_id
5039: FROM IGF_AP_CSS_PROFILE prof
5040: WHERE prof.css_id_number = cp_css_id_number;
5041:
5042: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
5043: SELECT ibm.ci_cal_type, ibm.ci_sequence_number

Line 5052: l_base_id igf_ap_css_profile_all.base_id%TYPE;

5048:
5049: rec_check_duplicate_profile cur_check_duplicate_profile%ROWTYPE;
5050: rec_profile_records cur_profile_records%ROWTYPE;
5051: rec_get_base_id cur_get_base_id%ROWTYPE;
5052: l_base_id igf_ap_css_profile_all.base_id%TYPE;
5053: lv_rowid NUMBER;
5054: pn_cssp_id NUMBER;
5055:
5056: BEGIN