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_FA_BASE_REC

Line 73: PROCEDURE update_person_info (p_person_id igf_ap_fa_base_rec.person_id%TYPE)

69: END IF;
70: RETURN col_value;
71: END convert_int ;
72:
73: PROCEDURE update_person_info (p_person_id igf_ap_fa_base_rec.person_id%TYPE)
74: IS
75: /*
76: || Created By : upinjark
77: || Created On : 19-Sept-2005

Line 168: PROCEDURE create_email_address (p_person_id igf_ap_fa_base_rec.person_id%TYPE)

164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END update_person_info;
167:
168: PROCEDURE create_email_address (p_person_id igf_ap_fa_base_rec.person_id%TYPE)
169: IS
170: /*
171: || Created By : rasahoo
172: || Created On : 11-Oct-2004

Line 229: PROCEDURE make_profile_inactive( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);
227: END create_email_address;
228:
229: PROCEDURE make_profile_inactive( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
230: /*
231: || Created By : rasahoo
232: || Created On : 24-AUG-2004
233: || Purpose : Makes all profile records inactive

Line 240: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

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 ;
244: BEGIN

Line 911: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

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:
915: /*

Line 912: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

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:
915: /*
916: || Created By : Meghana

Line 927: || TBH call igf_ap_fa_base_rec_pkg

923: || cursor SSN_CUR.
924: || rajagupt 6-Oct-2005 Bug#4068548 - added a new cursor ssn_cur
925: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
926: || added new parameter award_fmly_contribution_type to
927: || TBH call igf_ap_fa_base_rec_pkg
928: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
929: || removed packaging hold
930: || masehgal 25-Sep-2002 FA 104 - To Do Enhancements
931: || Added manual_disb_hold in Fa Base insert

Line 954: lv_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;

950:
951: rec_ssn_cur ssn_cur%ROWTYPE;
952: lv_profile_value VARCHAR2(20);
953: lv_rowid VARCHAR2(30);
954: lv_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
955: ln_ci_sequence_number igf_ap_fa_base_rec.ci_cal_type%TYPE;
956: retcode NUMBER;
957: errbuf VARCHAR2(300);
958:

Line 955: ln_ci_sequence_number igf_ap_fa_base_rec.ci_cal_type%TYPE;

951: rec_ssn_cur ssn_cur%ROWTYPE;
952: lv_profile_value VARCHAR2(20);
953: lv_rowid VARCHAR2(30);
954: lv_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
955: ln_ci_sequence_number igf_ap_fa_base_rec.ci_cal_type%TYPE;
956: retcode NUMBER;
957: errbuf VARCHAR2(300);
958:
959:

Line 979: igf_ap_fa_base_rec_pkg.insert_row(

975: CLOSE ssn_cur;
976: END IF;
977: END IF;
978:
979: igf_ap_fa_base_rec_pkg.insert_row(
980: x_mode => 'R',
981: x_rowid => lv_rowid,
982: x_base_id => pn_base_id,
983: x_ci_cal_type => cur_css_interface_rec.ci_cal_type,

Line 1560: pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,

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
1564:

Line 1723: pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE

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: /*
1727: || Created By : Meghana

Line 2338: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

2334:
2335: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
2336: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
2337: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
2338: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
2339: )RETURN BOOLEAN IS
2340:
2341: /*
2342: || Created By : Meghana

Line 2357: FROM igf_ap_fa_base_rec ifb

2353: pn_cal_type VARCHAR2,
2354: pn_sequence_number NUMBER
2355: ) IS
2356: SELECT ifb.base_id
2357: FROM igf_ap_fa_base_rec ifb
2358: WHERE ifb.person_id = pn_person_id
2359: AND ifb.ci_sequence_number = pn_sequence_number
2360: AND ifb.ci_cal_type = pn_cal_type;
2361:

Line 3145: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

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

Line 3406: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

3402: app_exception.raise_exception;
3403: END update_person_match;
3404:
3405:
3406: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3407:
3408: /*
3409: || Created By : vivuyyur
3410: || Created On : 25-JUN-2001

Line 3417: || TBH call igf_ap_fa_base_rec_pkg

3413: || Change History :
3414: || Who When What
3415: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
3416: || added new parameter award_fmly_contribution_type to
3417: || TBH call igf_ap_fa_base_rec_pkg
3418: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
3419: || removed packaging hold
3420: || masehgal 25-Sep-2002 FA 104 - To Do Enhancements
3421: || Added manual_disb_hold in Fa Base update

Line 3424: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec

3420: || masehgal 25-Sep-2002 FA 104 - To Do Enhancements
3421: || Added manual_disb_hold in Fa Base update
3422: || (reverse chronological order - newest change first)
3423: */
3424: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3425: CURSOR cur_fabase(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3426: SELECT *
3427: FROM igf_ap_fa_base_rec
3428: WHERE base_id = p_base_id FOR UPDATE NOWAIT ;

Line 3425: CURSOR cur_fabase(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

3421: || Added manual_disb_hold in Fa Base update
3422: || (reverse chronological order - newest change first)
3423: */
3424: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3425: CURSOR cur_fabase(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3426: SELECT *
3427: FROM igf_ap_fa_base_rec
3428: WHERE base_id = p_base_id FOR UPDATE NOWAIT ;
3429:

Line 3427: FROM igf_ap_fa_base_rec

3423: */
3424: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3425: CURSOR cur_fabase(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3426: SELECT *
3427: FROM igf_ap_fa_base_rec
3428: WHERE base_id = p_base_id FOR UPDATE NOWAIT ;
3429:
3430: BEGIN
3431:

Line 3436: igf_ap_fa_base_rec_pkg.update_row (

3432:
3433: -- To update the fields profile_status ,profile_status_date ,profile_fc
3434: FOR fabase_data IN cur_fabase(p_base_id)
3435: LOOP
3436: igf_ap_fa_base_rec_pkg.update_row (
3437: X_Mode => 'R',
3438: x_rowid => fabase_data.row_id,
3439: x_base_id => fabase_data.base_id,
3440: x_ci_cal_type => fabase_data.ci_cal_type,

Line 3577: fabase_data igf_ap_fa_base_rec%ROWTYPE ;

3573: || bkkumar 11-Aug-2003 Bug# 3084964 Added the check for the
3574: || HZ_GENERATE_PARTY_NUMBER profile value
3575: || (reverse chronological order - newest change first)
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);

Line 3579: lv_base_id igf_ap_fa_base_rec.base_id%TYPE ;

3575: || (reverse chronological order - newest change first)
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:

Line 3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;

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 ;
3819:

Line 3826: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec

3822: SELECT apm.*
3823: FROM igf_ap_person_match apm
3824: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3825:
3826: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3827: CURSOR cur_fabase(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3828: SELECT *
3829: FROM igf_ap_fa_base_rec
3830: WHERE base_id = x_base_id ;

Line 3827: CURSOR cur_fabase(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

3823: FROM igf_ap_person_match apm
3824: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3825:
3826: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3827: CURSOR cur_fabase(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
3828: SELECT *
3829: FROM igf_ap_fa_base_rec
3830: WHERE base_id = x_base_id ;
3831:

Line 3829: FROM igf_ap_fa_base_rec

3825:
3826: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3827: CURSOR cur_fabase(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
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

Line 3833: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

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 ;
3837:

Line 4277: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

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 ;
4281:

Line 4283: CURSOR cur_get_person_id(cp_base_id igf_ap_fa_base_rec.base_id%TYPE)

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)
4284: IS
4285: SELECT person_id
4286: FROM igf_ap_fa_base_rec_all
4287: WHERE base_id = cp_base_id ;

Line 4286: FROM igf_ap_fa_base_rec_all

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)
4284: IS
4285: SELECT person_id
4286: FROM igf_ap_fa_base_rec_all
4287: WHERE base_id = cp_base_id ;
4288:
4289: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;
4290:

Line 4289: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;

4285: SELECT person_id
4286: FROM igf_ap_fa_base_rec_all
4287: WHERE base_id = cp_base_id ;
4288:
4289: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;
4290:
4291: BEGIN
4292: l_person_id := NULL;
4293: IF g_rec_type = 'D' THEN

Line 4456: CURSOR cur_alt_code ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,

4452: AND TO_NUMBER(academic_year) = cp_acad_year
4453: AND college_code= NVL(cp_schoo_cd, college_code);
4454: -- AND rownum <5 ;
4455:
4456: CURSOR cur_alt_code ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
4457: x_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ) IS
4458: SELECT cal.alternate_code
4459: FROM igs_ca_inst cal
4460: WHERE cal.cal_type = x_ci_cal_type

Line 4457: x_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ) IS

4453: AND college_code= NVL(cp_schoo_cd, college_code);
4454: -- AND rownum <5 ;
4455:
4456: CURSOR cur_alt_code ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
4457: x_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ) IS
4458: SELECT cal.alternate_code
4459: FROM igs_ca_inst cal
4460: WHERE cal.cal_type = x_ci_cal_type
4461: AND cal.sequence_number = x_ci_sequence_number;

Line 4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

4480: WHERE match_code = cp_match_code;
4481:
4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;

Line 4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

4481:
4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;
4489:

Line 4914: fabase_data igf_ap_fa_base_rec%ROWTYPE ;

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 ;
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);

Line 4916: lv_base_id igf_ap_fa_base_rec.base_id%TYPE ;

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 ;
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