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

Line 9: PROCEDURE update_to_do_items (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

5: -- Who When What
6: --------------------------------------------------------------------------------
7:
8: -- Procedure to update TO DO Items where p_run_type IN ('S','Y','P')
9: PROCEDURE update_to_do_items (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
10: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
11: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE
12: )
13: IS

Line 25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

21: --------------------------------------------------------------------------------
22:
23: --Cursor to fetch persons from todo ref table
24: CURSOR c_person_ref(
25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE

Line 26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

22:
23: --Cursor to fetch persons from todo ref table
24: CURSOR c_person_ref(
25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
30: ) IS

Line 73: c_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

69: l_person_todo c_person_todo%ROWTYPE;
70:
71: --Cursor to fetch the person who have a "COA Re-computation" as a "Person To Do"
72: CURSOR cur_person_dtls(
73: c_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
74: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
75: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
76: ) IS
77: SELECT distinct todo.person_id,

Line 74: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

70:
71: --Cursor to fetch the person who have a "COA Re-computation" as a "Person To Do"
72: CURSOR cur_person_dtls(
73: c_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
74: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
75: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
76: ) IS
77: SELECT distinct todo.person_id,
78: todo.s_student_todo_type,

Line 75: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

71: --Cursor to fetch the person who have a "COA Re-computation" as a "Person To Do"
72: CURSOR cur_person_dtls(
73: c_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
74: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
75: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
76: ) IS
77: SELECT distinct todo.person_id,
78: todo.s_student_todo_type,
79: todo.sequence_number

Line 97: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

93:
94:
95: --Cursor to fetch person id
96: CURSOR cur_get_person_id(
97: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
98: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
99: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
100: ) IS
101: SELECT person_id

Line 98: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

94:
95: --Cursor to fetch person id
96: CURSOR cur_get_person_id(
97: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
98: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
99: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
100: ) IS
101: SELECT person_id
102: FROM igf_ap_fa_base_rec_all

Line 99: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

95: --Cursor to fetch person id
96: CURSOR cur_get_person_id(
97: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
98: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
99: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
100: ) IS
101: SELECT person_id
102: FROM igf_ap_fa_base_rec_all
103: WHERE base_id = c_base_id

Line 102: FROM igf_ap_fa_base_rec_all

98: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
99: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
100: ) IS
101: SELECT person_id
102: FROM igf_ap_fa_base_rec_all
103: WHERE base_id = c_base_id
104: AND ci_cal_type = c_ci_cal_type
105: AND ci_sequence_number = c_ci_sequence_number;
106:

Line 187: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

183:
184: -- This function check whether the student attributes are matching with the COA Rate Order or not
185: -- If matching it returns the new calculated amount
186: FUNCTION is_attrib_matching(
187: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
188: p_base_details IN igf_aw_coa_gen.base_details,
189: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
190: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
191: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 289: FROM igf_ap_fa_base_rec fabase

285:
286: --Bug #5021084. Passing Group ID if the group type is STATIC.
287: IF lv_group_type = 'STATIC' THEN
288: OPEN c_chk_per_exist FOR 'SELECT 1
289: FROM igf_ap_fa_base_rec fabase
290: WHERE fabase.base_id = :base_id
291: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING p_base_id,l_grp_id.group_id;
292: ELSIF lv_group_type = 'DYNAMIC' THEN
293: OPEN c_chk_per_exist FOR 'SELECT 1

Line 294: FROM igf_ap_fa_base_rec fabase

290: WHERE fabase.base_id = :base_id
291: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING p_base_id,l_grp_id.group_id;
292: ELSIF lv_group_type = 'DYNAMIC' THEN
293: OPEN c_chk_per_exist FOR 'SELECT 1
294: FROM igf_ap_fa_base_rec fabase
295: WHERE fabase.base_id = :base_id
296: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING p_base_id;
297: END IF;
298:

Line 449: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

445:
446:
447: -- This procedure is to evaluate the COA re-computation amount
448: PROCEDURE evaluate(
449: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
450: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
451: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE
452: ) IS
453: --------------------------------------------------------------------------------

Line 463: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE

459: --------------------------------------------------------------------------------
460:
461: --This cursor is to fetch person details
462: CURSOR c_base_rec (
463: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
464: ) IS
465: SELECT NVL(fab.lock_coa_flag,'N') lock_coa_flag
466: FROM igf_ap_fa_base_rec fab
467: WHERE fab.base_id = c_base_id;

Line 466: FROM igf_ap_fa_base_rec fab

462: CURSOR c_base_rec (
463: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
464: ) IS
465: SELECT NVL(fab.lock_coa_flag,'N') lock_coa_flag
466: FROM igf_ap_fa_base_rec fab
467: WHERE fab.base_id = c_base_id;
468:
469: l_base_rec c_base_rec%ROWTYPE;
470:

Line 474: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE

470:
471:
472: --This cursor is to fetch items details for a person
473: CURSOR c_items(
474: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
475: ) IS
476: SELECT items.*
477: FROM igf_aw_coa_items items
478: WHERE items.base_id = c_base_id;

Line 483: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

479:
480:
481: --This cursor is to fetch terms details against an item
482: CURSOR c_terms(
483: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
484: c_item_code igf_aw_item.item_code%TYPE
485: ) IS
486: SELECT terms.rowid row_id,
487: terms.*

Line 495: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

491:
492:
493: --Cursor to fetch the sum amount of all the terms for the Item code
494: CURSOR c_sum_amt(
495: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
496: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
497: ) IS
498: SELECT SUM(NVL(amount,0)) amount
499: FROM igf_aw_coa_itm_terms term

Line 508: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

504:
505:
506: --Cursor to fetch item details for the base id
507: CURSOR c_item(
508: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
509: c_item_code igf_aw_coa_itm_terms.item_code%TYPE
510: ) IS
511: SELECT item.rowid row_id,
512: item.*

Line 716: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

712: retcode OUT NOCOPY NUMBER,
713: p_award_year IN VARCHAR2,
714: p_run_type IN VARCHAR2,
715: p_pid_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
716: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
717: ) IS
718: --------------------------------------------------------------------------------
719: -- this procedure is called from concurrent manager.
720: -- if the parameters passed are not correct then procedure exits

Line 743: person_id igf_ap_fa_base_rec_all.person_id%TYPE,

739: TYPE CpregrpCurTyp IS REF CURSOR ;
740: cur_per_grp CpregrpCurTyp ;
741:
742: TYPE CpergrpTyp IS RECORD(
743: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
744: person_number igs_pe_person_base_v.person_number%TYPE
745: );
746: per_grp_rec CpergrpTyp ;
747:

Line 751: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

747:
748:
749: --Cursor below retrieves all the students belonging to a given AWARD YEAR
750: CURSOR c_per_awd_yr(
751: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
752: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
753: ) IS
754: SELECT fa.base_id
755: FROM igf_ap_fa_base_rec_all fa

Line 752: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

748:
749: --Cursor below retrieves all the students belonging to a given AWARD YEAR
750: CURSOR c_per_awd_yr(
751: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
752: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
753: ) IS
754: SELECT fa.base_id
755: FROM igf_ap_fa_base_rec_all fa
756: WHERE fa.ci_cal_type = c_ci_cal_type

Line 755: FROM igf_ap_fa_base_rec_all fa

751: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
752: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
753: ) IS
754: SELECT fa.base_id
755: FROM igf_ap_fa_base_rec_all fa
756: WHERE fa.ci_cal_type = c_ci_cal_type
757: AND fa.ci_sequence_number = c_ci_sequence_number
758: ORDER BY fa.base_id;
759:

Line 787: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

783:
784:
785: --Cursor to fetch all persons who have a "COA Re-computation" as a "Person To Do"
786: CURSOR cur_person_id(
787: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
788: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
789: ) IS
790: SELECT distinct todo.person_id,
791: todo.s_student_todo_type,

Line 788: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

784:
785: --Cursor to fetch all persons who have a "COA Re-computation" as a "Person To Do"
786: CURSOR cur_person_id(
787: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
788: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
789: ) IS
790: SELECT distinct todo.person_id,
791: todo.s_student_todo_type,
792: todo.sequence_number

Line 807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

803:
804:
805: --Cursor to fetch persons from todo ref table
806: CURSOR c_person_ref(
807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE

Line 808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

804:
805: --Cursor to fetch persons from todo ref table
806: CURSOR c_person_ref(
807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
812: ) IS

Line 855: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

851: l_person_todo c_person_todo%ROWTYPE;
852:
853: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
854: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
855: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
856: lv_err_msg fnd_new_messages.message_name%TYPE;
857: lv_return_flag VARCHAR2(1);
858:
859: