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_TODO_GRPS_PRC_PKG dependencies on IGF_AP_FA_BASE_REC

Line 139: igf_ap_fa_base_rec_all fa

135: cp_base_id IN NUMBER
136: ) IS
137: SELECT pe.person_number
138: FROM igs_pe_person_base_v pe,
139: igf_ap_fa_base_rec_all fa
140: WHERE pe.person_id = fa.person_id
141: AND fa.base_id = cp_base_id;
142:
143: -- Get the details of

Line 416: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

412: END log_input_params;
413:
414:
415: PROCEDURE add_to_do(
416: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
417: p_todo_number IN igf_ap_td_item_mst_all.todo_number%TYPE,
418: p_item_cnt IN NUMBER,
419: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
420: p_status IN igf_ap_td_item_inst_all.status%TYPE,

Line 419: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

415: PROCEDURE add_to_do(
416: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
417: p_todo_number IN igf_ap_td_item_mst_all.todo_number%TYPE,
418: p_item_cnt IN NUMBER,
419: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
420: p_status IN igf_ap_td_item_inst_all.status%TYPE,
421: p_upd_mode IN VARCHAR2
422: ) AS
423: /*

Line 447: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

443: WHERE todo_number = cp_todo_number;
444:
445:
446: CURSOR c_chk_career_exists(
447: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
448: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
449: ) IS
450: SELECT 1 value, fab.base_id base_id
451: FROM igf_ap_fa_base_rec fab,

Line 451: FROM igf_ap_fa_base_rec fab,

447: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
448: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
449: ) IS
450: SELECT 1 value, fab.base_id base_id
451: FROM igf_ap_fa_base_rec fab,
452: igf_ap_td_item_inst inst,
453: igf_ap_td_item_mst mst
454: WHERE fab.person_id = cp_person_id
455: AND mst.todo_number = cp_todo_number

Line 462: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

458: AND inst.base_id = fab.base_id;
459:
460: --FA 140 - To Avoid skipping of items if already present. Need to update
461: CURSOR c_to_do_item (
462: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
463: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
464: ) IS
465: SELECT item_inst.ROWID row_id, item_inst.*
466: FROM igf_ap_td_item_inst_all item_inst

Line 470: CURSOR c_check_preflender(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

466: FROM igf_ap_td_item_inst_all item_inst
467: WHERE base_id = cp_base_id
468: AND item_sequence_number = cp_item_sequence_number;
469:
470: CURSOR c_check_preflender(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
471: SELECT 'x'
472: FROM
473: igf_sl_cl_pref_lenders
474: WHERE person_id = cp_person_id AND

Line 486: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

482: l_status igf_ap_td_item_inst_all.status%TYPE := 'REQ';
483:
484: lc_check_preflender c_check_preflender%ROWTYPE;
485: lc_to_do_item c_to_do_item%ROWTYPE;
486: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
487:
488:
489: BEGIN
490:

Line 666: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

662:
663: END add_to_do;
664:
665: FUNCTION assign_todo(
666: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
667: p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
670: p_upd_mode IN VARCHAR2,

Line 737: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

733:
734:
735: -- Check whether the sudent exists in the FA system or not.
736: CURSOR c_fa_base(
737: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
738: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
739: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
740: ) IS
741: SELECT base_id

Line 738: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

734:
735: -- Check whether the sudent exists in the FA system or not.
736: CURSOR c_fa_base(
737: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
738: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
739: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
740: ) IS
741: SELECT base_id
742: FROM igf_ap_fa_base_rec

Line 739: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

735: -- Check whether the sudent exists in the FA system or not.
736: CURSOR c_fa_base(
737: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
738: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
739: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
740: ) IS
741: SELECT base_id
742: FROM igf_ap_fa_base_rec
743: WHERE person_id = cp_person_id

Line 742: FROM igf_ap_fa_base_rec

738: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
739: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
740: ) IS
741: SELECT base_id
742: FROM igf_ap_fa_base_rec
743: WHERE person_id = cp_person_id
744: AND ci_cal_type = cp_ci_cal_type
745: AND ci_sequence_number = cp_ci_sequence_number;
746:

Line 750: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

746:
747:
748: -- Get the person number and person name with the person id.
749: CURSOR c_person_details(
750: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
751: ) IS
752: SELECT pe.person_number, pe.full_name person_name, fa.person_id
753: FROM igf_ap_fa_base_rec fa,
754: igs_pe_person_base_v pe

Line 753: FROM igf_ap_fa_base_rec fa,

749: CURSOR c_person_details(
750: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
751: ) IS
752: SELECT pe.person_number, pe.full_name person_name, fa.person_id
753: FROM igf_ap_fa_base_rec fa,
754: igs_pe_person_base_v pe
755: WHERE fa.base_id = cp_base_id
756: AND fa.person_id = pe.person_id;
757:

Line 766: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

762: WHERE lookup_type='IGF_GE_PARAMETERS'
763: AND lookup_code IN ('PERSON_NUMBER');
764:
765:
766: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
767: lc_person_details_rec c_person_details%ROWTYPE;
768: ln_item_cnt NUMBER(3) := 0;
769: l_person_number igf_lookups_view.meaning%TYPE;
770:

Line 773: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

769: l_person_number igf_lookups_view.meaning%TYPE;
770:
771:
772: PROCEDURE each_student_todo(
773: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
774: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
775: ) AS
776: /*
777: || Created By : brajendr

Line 774: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE

770:
771:
772: PROCEDURE each_student_todo(
773: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
774: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
775: ) AS
776: /*
777: || Created By : brajendr
778: || Created On :

Line 1186: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

1182: || log_input_params and assign_todo signature changed
1183: || (reverse chronological order - newest change first)
1184: */
1185:
1186: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1187: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1188: lb_return_value BOOLEAN := FALSE;
1189: ln_stdnt_count NUMBER := 0;
1190:

Line 1187: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;

1183: || (reverse chronological order - newest change first)
1184: */
1185:
1186: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1187: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1188: lb_return_value BOOLEAN := FALSE;
1189: ln_stdnt_count NUMBER := 0;
1190:
1191: /* Variables for the dynamic person id group */