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_INTERFACE

Line 6: g_cur_data igf_ap_css_interface%ROWTYPE ;

2: /* $Header: IGFAP16B.pls 120.9 2006/06/30 07:55:34 rajagupt ship $ */
3:
4: g_setup_score igf_ap_record_match%ROWTYPE ;
5: -- #2376750 made cur_data global
6: g_cur_data igf_ap_css_interface%ROWTYPE ;
7: INVALID_PROFILE_ERROR EXCEPTION;
8: SKIP_PERSON EXCEPTION;
9: g_total_processed NUMBER(8) ;
10: g_matched_rec NUMBER(8) ;

Line 910: pn_css_id igf_ap_css_interface_all.css_id%TYPE,

906: );
907: END create_ssn;
908:
909: PROCEDURE create_fa_base_record(
910: pn_css_id igf_ap_css_interface_all.css_id%TYPE,
911: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
912: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
913: ) IS
914:

Line 936: FROM igf_ap_css_interface iii, igf_ap_batch_aw_map ibm

932: || (reverse chronological order - newest change first)
933: */
934: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
935: SELECT iii.*, ibm.ci_sequence_number, ibm.ci_cal_type
936: FROM igf_ap_css_interface iii, igf_ap_batch_aw_map ibm
937: WHERE iii.css_id = pn_css_id
938: AND TO_NUMBER(iii.academic_year) = ibm.css_academic_year ;
939:
940:

Line 1119: PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

1115: app_exception.raise_exception;
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: /*

Line 1135: FROM igf_ap_css_interface_all iii

1131: */
1132: -- Get all the FNAR data for the matched PROFILE record.
1133: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
1134: SELECT iii.*
1135: FROM igf_ap_css_interface_all iii
1136: WHERE css_id = pn_css_id;
1137:
1138:
1139: lv_rowid VARCHAR2(30);

Line 1559: pn_css_id igf_ap_css_interface_all.css_id%TYPE,

1555: END create_fnar_data;
1556:
1557:
1558: PROCEDURE create_person_record(
1559: pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1560: pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
1561: pv_mesg_data OUT NOCOPY VARCHAR2,
1562: p_called_from VARCHAR2
1563: )IS

Line 1584: FROM igf_ap_css_interface iii

1580: || (reverse chronological order - newest change first)
1581: */
1582: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
1583: SELECT iii.last_name, iii.middle_initial, iii.social_security_number,iii.first_name,iii.r_s_email_address,date_of_birth
1584: FROM igf_ap_css_interface iii
1585: WHERE iii.css_id = pn_css_id;
1586:
1587: ln_msg_count NUMBER;
1588: lv_msg_data VARCHAR2(2000);

Line 1722: PROCEDURE create_person_addr_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

1718:
1719: END create_person_record;
1720:
1721:
1722: PROCEDURE create_person_addr_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
1723: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1724: ) IS
1725:
1726: /*

Line 1738: FROM igf_ap_css_interface iii

1734: || (reverse chronological order - newest change first)
1735: */
1736: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
1737: SELECT city, state_mailing, address_number_and_street, s_telephone_number, zip_code
1738: FROM igf_ap_css_interface iii
1739: WHERE css_id = pn_css_id;
1740:
1741: lv_row_id VARCHAR2(30);
1742: retcode NUMBER;

Line 1955: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

1951: app_exception.raise_exception;
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

Line 1971: FROM igf_ap_css_interface_all iii

1967: || (reverse chronological order - newest change first)
1968: */
1969: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
1970: SELECT ROWID row_id, iii.*
1971: FROM igf_ap_css_interface_all iii
1972: WHERE iii.css_id = pn_css_id;
1973:
1974: lv_rowid VARCHAR2(30);
1975: ln_org_id NUMBER ;

Line 2384: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);
2381: app_exception.raise_exception;
2382: END is_fa_base_record_present;
2383:
2384: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
2385: pv_record_status igf_ap_css_interface_all.record_status%TYPE,
2386: pv_match_code VARCHAR2
2387: ) IS
2388:

Line 2385: pv_record_status igf_ap_css_interface_all.record_status%TYPE,

2381: app_exception.raise_exception;
2382: END is_fa_base_record_present;
2383:
2384: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
2385: pv_record_status igf_ap_css_interface_all.record_status%TYPE,
2386: pv_match_code VARCHAR2
2387: ) IS
2388:
2389: /*

Line 2400: FROM igf_ap_css_interface_all iii

2396: || (reverse chronological order - newest change first)
2397: */
2398: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
2399: SELECT ROWID, iii.*
2400: FROM igf_ap_css_interface_all iii
2401: WHERE css_id = pn_css_id;
2402:
2403: lv_rowid VARCHAR2(30);
2404: ln_org_id NUMBER ;

Line 2414: igf_ap_css_interface_pkg.update_row (

2410: -- Update record _status
2411: FOR cur_css_interface_rec IN cur_css_interface ( pn_css_id)
2412: LOOP
2413:
2414: igf_ap_css_interface_pkg.update_row (
2415: X_Mode => 'R',
2416: x_rowid => cur_css_interface_rec.ROWID,
2417: x_css_id => cur_css_interface_rec.css_id,
2418: x_record_status => pv_record_status ,

Line 3146: p_batch_year igf_ap_css_interface_all.academic_year%TYPE

3142: END update_css_interface;
3143:
3144: PROCEDURE create_admission_rec(
3145: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
3146: p_batch_year igf_ap_css_interface_all.academic_year%TYPE
3147: ) IS
3148:
3149: /*
3150: || Created By : vivuyyur

Line 3654: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

3650: x_record_status => 'MATCHED' ,
3651: x_mode => 'R'
3652: );
3653: END LOOP ;
3654: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
3655: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3656: pv_record_status => 'MATCHED',
3657: pv_match_code => g_match_code
3658: );

Line 3682: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'

3678: x_record_status => 'UNMATCHED' ,
3679: x_mode => 'R'
3680: );
3681: END LOOP ;
3682: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'
3683: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3684: pv_record_status => 'UNMATCHED',
3685: pv_match_code => g_match_code);
3686: END IF;

Line 3708: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'

3704: x_record_status => 'UNMATCHED' ,
3705: x_mode => 'R'
3706: );
3707: END LOOP ;
3708: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'
3709: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3710: pv_record_status => 'UNMATCHED',
3711: pv_match_code => g_match_code
3712: );

Line 3738: || Purpose : To update the record_status of igf_ap_person_match,igf_ap_css_interface to review

3734: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS
3735: /*
3736: || Created By : vivuyyur
3737: || Created On : 11-JUN-2000
3738: || Purpose : To update the record_status of igf_ap_person_match,igf_ap_css_interface to review
3739: || Known limitations, enhancements or remarks :
3740: || Change History :
3741: || Who When What
3742: || (reverse chronological order - newest change first)

Line 3772: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'REVIEW'

3768: x_mode => 'R'
3769: );
3770: END LOOP ;
3771:
3772: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'REVIEW'
3773: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3774: pv_record_status => 'REVIEW',
3775: pv_match_code => g_match_code
3776: );

Line 3893: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

3889: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: igf_ap_profile_gen_pkg.delete_person_match' );
3890: END IF;
3891: igf_ap_profile_gen_pkg.delete_person_match ( p_css_id => g_cur_data.css_id);
3892:
3893: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_css_interface' );
3896: END IF;
3897: update_css_interface(pn_css_id => g_cur_data.css_id,

Line 4363: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

4359:
4360: g_matched_rec := g_matched_rec + 1 ;
4361: END IF;
4362:
4363: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
4364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','calling method: update_css_interface');
4366: END IF;
4367: update_css_interface(pn_css_id => g_cur_data.css_id,

Line 4415: CURSOR cur_school_cd(cp_school_cd igf_ap_css_interface.college_code%TYPE) IS

4411: || (reverse chronological order - newest change first)
4412: */
4413:
4414:
4415: CURSOR cur_school_cd(cp_school_cd igf_ap_css_interface.college_code%TYPE) IS
4416: SELECT 'Y'
4417: FROM igf_ap_css_interface
4418: WHERE college_code = cp_school_cd
4419: AND rownum =1 ;

Line 4417: FROM igf_ap_css_interface

4413:
4414:
4415: CURSOR cur_school_cd(cp_school_cd igf_ap_css_interface.college_code%TYPE) IS
4416: SELECT 'Y'
4417: FROM igf_ap_css_interface
4418: WHERE college_code = cp_school_cd
4419: AND rownum =1 ;
4420:
4421: CURSOR cur_match_set(cp_match_code igf_ap_record_match_all.match_code%TYPE) IS

Line 4450: FROM igf_ap_css_interface

4446: l_duplicate NUMBER;
4447: -- Get all the newly imported records for doing the matching process.
4448: CURSOR cur_css_interface(cp_acad_year VARCHAR2, cp_schoo_cd VARCHAR2) IS
4449: SELECT *
4450: FROM igf_ap_css_interface
4451: WHERE record_status IN ('NEW','UNMATCHED','REVIEW')
4452: AND TO_NUMBER(academic_year) = cp_acad_year
4453: AND college_code= NVL(cp_schoo_cd, college_code);
4454: -- AND rownum <5 ;

Line 4493: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_CSS_INTERFACE_ALL' , cascade => TRUE);

4489:
4490: BEGIN
4491: igf_aw_gen.set_org_id(p_org_id);
4492:
4493: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_CSS_INTERFACE_ALL' , cascade => TRUE);
4494:
4495: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10))) ;
4496: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11)) ;
4497:

Line 4755: FROM igf_ap_css_interface

4751: IS
4752:
4753: CURSOR cur_css_interface(cp_css_id IN NUMBER) IS
4754: SELECT *
4755: FROM igf_ap_css_interface
4756: WHERE css_id = cp_css_id;
4757:
4758: CURSOR get_apm_id(cp_css_id NUMBER)
4759: IS

Line 4839: FROM igf_ap_css_interface

4835: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
4836:
4837: CURSOR cur_css_interface(cp_css_id IN NUMBER) IS
4838: SELECT *
4839: FROM igf_ap_css_interface
4840: WHERE css_id = cp_css_id;
4841:
4842: CURSOR cur_setup_score(cp_match_code VARCHAR2) IS
4843: SELECT *

Line 4911: FROM igf_ap_css_interface

4907: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
4908:
4909: CURSOR cur_css_interface(cp_css_id IN NUMBER) IS
4910: SELECT *
4911: FROM igf_ap_css_interface
4912: WHERE css_id = cp_css_id;
4913:
4914: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
4915: lv_person_id igf_ap_person_v.person_id%TYPE ;

Line 4981: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

4977: IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data(pn_css_id => g_cur_data.css_id,
4978: pn_cssp_id => lv_cssp_id
4979: ) ;
4980:
4981: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
4982: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
4983: pv_record_status => 'MATCHED',
4984: pv_match_code => g_match_code
4985: );

Line 5015: CURSOR cur_check_duplicate_profile ( cp_css_id_number igf_ap_css_interface_all.css_id%TYPE,

5011: || Who When What
5012: */
5013:
5014: -- cursor to check wether duplicate profile exists or not in the system.
5015: CURSOR cur_check_duplicate_profile ( cp_css_id_number igf_ap_css_interface_all.css_id%TYPE,
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

Line 5016: cp_stu_record_type igf_ap_css_interface_all.stu_record_type%TYPE,

5012: */
5013:
5014: -- cursor to check wether duplicate profile exists or not in the system.
5015: CURSOR cur_check_duplicate_profile ( cp_css_id_number igf_ap_css_interface_all.css_id%TYPE,
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

Line 5017: cp_academic_year igf_ap_css_interface_all.academic_year%TYPE

5013:
5014: -- cursor to check wether duplicate profile exists or not in the system.
5015: CURSOR cur_check_duplicate_profile ( cp_css_id_number igf_ap_css_interface_all.css_id%TYPE,
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

Line 5026: CURSOR cur_interface_record ( cp_css_id igf_ap_css_interface_all.css_id%TYPE) IS

5022: AND prof.stu_record_type = cp_stu_record_type
5023: AND prof.academic_year = cp_academic_year;
5024:
5025: -- cursor to get interface record.
5026: CURSOR cur_interface_record ( cp_css_id igf_ap_css_interface_all.css_id%TYPE) IS
5027: SELECT intr.*
5028: FROM IGF_AP_CSS_INTERFACE intr
5029: WHERE intr.css_id = cp_css_id;
5030:

Line 5028: FROM IGF_AP_CSS_INTERFACE intr

5024:
5025: -- cursor to get interface record.
5026: CURSOR cur_interface_record ( cp_css_id igf_ap_css_interface_all.css_id%TYPE) IS
5027: SELECT intr.*
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