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.IGS_FI_PRC_SP_FEES dependencies on IGS_PE_STD_TODO

Line 999: l_n_person_id igs_pe_std_todo.person_id%TYPE;

995: -------------------------------------------------------------------
996: TYPE person_grp_ref_cur_type IS REF CURSOR;
997: c_ref_person_grp person_grp_ref_cur_type;
998:
999: l_n_person_id igs_pe_std_todo.person_id%TYPE;
1000: l_dynamic_sql VARCHAR2(32767);
1001: l_v_status VARCHAR2(1);
1002: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
1003: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1195: p_uooid igs_pe_std_todo_ref.uoo_id%TYPE,

1191: END assess_fees;
1192:
1193: PROCEDURE log_error_message(p_v_person_number hz_parties.party_number%TYPE,
1194: p_v_fee_period VARCHAR2,
1195: p_uooid igs_pe_std_todo_ref.uoo_id%TYPE,
1196: p_v_message_name VARCHAR2 ) IS
1197: ------------------------------------------------------------------
1198: --Created by :Umesh Udayaprakash, Oracle India (in)
1199: --Date created: 21-OCT-2003

Line 1275: CURSOR c_get_todo_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE, cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS

1271: -- Exception raised when a lock could not be obtained in the Temp table.
1272: e_lock_exception EXCEPTION;
1273: PRAGMA EXCEPTION_INIT(e_lock_exception, -54);
1274:
1275: CURSOR c_get_todo_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE, cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1276: SELECT igs_pe_std_todo.rowid , igs_pe_std_todo.*
1277: FROM igs_pe_std_todo
1278: WHERE (person_id = cp_n_person_id OR cp_n_person_id IS NULL)
1279: AND s_student_todo_type = cp_v_todo_type

Line 1276: SELECT igs_pe_std_todo.rowid , igs_pe_std_todo.*

1272: e_lock_exception EXCEPTION;
1273: PRAGMA EXCEPTION_INIT(e_lock_exception, -54);
1274:
1275: CURSOR c_get_todo_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE, cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1276: SELECT igs_pe_std_todo.rowid , igs_pe_std_todo.*
1277: FROM igs_pe_std_todo
1278: WHERE (person_id = cp_n_person_id OR cp_n_person_id IS NULL)
1279: AND s_student_todo_type = cp_v_todo_type
1280: AND logical_delete_dt is NULL;

Line 1277: FROM igs_pe_std_todo

1273: PRAGMA EXCEPTION_INIT(e_lock_exception, -54);
1274:
1275: CURSOR c_get_todo_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE, cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1276: SELECT igs_pe_std_todo.rowid , igs_pe_std_todo.*
1277: FROM igs_pe_std_todo
1278: WHERE (person_id = cp_n_person_id OR cp_n_person_id IS NULL)
1279: AND s_student_todo_type = cp_v_todo_type
1280: AND logical_delete_dt is NULL;
1281:

Line 1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,

1279: AND s_student_todo_type = cp_v_todo_type
1280: AND logical_delete_dt is NULL;
1281:
1282:
1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS

Line 1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,

1280: AND logical_delete_dt is NULL;
1281:
1282:
1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS
1288: SELECT tref.rowid , tref.*

Line 1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,

1281:
1282:
1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS
1288: SELECT tref.rowid , tref.*
1289: FROM igs_pe_std_todo_ref tref

Line 1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,

1282:
1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS
1288: SELECT tref.rowid , tref.*
1289: FROM igs_pe_std_todo_ref tref
1290: WHERE tref.person_id = cp_n_person_id

Line 1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS

1283: CURSOR c_get_todo_ref_recs(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1284: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS
1288: SELECT tref.rowid , tref.*
1289: FROM igs_pe_std_todo_ref tref
1290: WHERE tref.person_id = cp_n_person_id
1291: AND tref.sequence_number = cp_n_sequence_number

Line 1289: FROM igs_pe_std_todo_ref tref

1285: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
1286: cp_v_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE,
1287: cp_n_ld_seq_number igs_pe_std_todo_ref.ci_sequence_number%TYPE) IS
1288: SELECT tref.rowid , tref.*
1289: FROM igs_pe_std_todo_ref tref
1290: WHERE tref.person_id = cp_n_person_id
1291: AND tref.sequence_number = cp_n_sequence_number
1292: AND tref.s_student_todo_type = cp_v_todo_type
1293: AND tref.logical_delete_dt IS NULL

Line 1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,

1308: SELECT alternate_code,description
1309: FROM igs_ca_inst
1310: WHERE cal_type = cp_v_cal_type
1311: AND sequence_number = cp_n_sequence_number;
1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1314: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1315: SELECT 'X'
1316: FROM igs_pe_std_todo_ref tref

Line 1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,

1309: FROM igs_ca_inst
1310: WHERE cal_type = cp_v_cal_type
1311: AND sequence_number = cp_n_sequence_number;
1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1314: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1315: SELECT 'X'
1316: FROM igs_pe_std_todo_ref tref
1317: WHERE tref.person_id = cp_n_person_id

Line 1314: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS

1310: WHERE cal_type = cp_v_cal_type
1311: AND sequence_number = cp_n_sequence_number;
1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1314: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1315: SELECT 'X'
1316: FROM igs_pe_std_todo_ref tref
1317: WHERE tref.person_id = cp_n_person_id
1318: AND tref.s_student_todo_type = cp_v_todo_type

Line 1316: FROM igs_pe_std_todo_ref tref

1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
1314: cp_v_todo_type igs_pe_std_todo.s_student_todo_type%TYPE ) IS
1315: SELECT 'X'
1316: FROM igs_pe_std_todo_ref tref
1317: WHERE tref.person_id = cp_n_person_id
1318: AND tref.s_student_todo_type = cp_v_todo_type
1319: AND tref.sequence_number = cp_n_sequence_number
1320: AND logical_delete_dt is NULL;

Line 1469: igs_pe_std_todo_ref_pkg.update_row (x_rowid =>l_c_get_todo_ref_recs.rowid,

1465: x_msg_data => l_v_msg_data);
1466: -- If The Return Status From Assess_fees_pvt Is S Then Processing Is Sucessfull
1467: IF l_v_return_status = 'S' THEN
1468: -- If The Special Fees Co Routine Has Been Processed Sucessfully The Update The Logical Delete Date To Sysdate.
1469: igs_pe_std_todo_ref_pkg.update_row (x_rowid =>l_c_get_todo_ref_recs.rowid,
1470: x_person_id =>l_c_get_todo_ref_recs.person_id,
1471: x_s_student_todo_type =>l_c_get_todo_ref_recs.s_student_todo_type,
1472: x_sequence_number =>l_c_get_todo_ref_recs.sequence_number,
1473: x_reference_number =>l_c_get_todo_ref_recs.reference_number,

Line 1506: -- Assess_fee_pvt Procedure Then Update The Igs_pe_std_todo Table Logical_delete Date With The System Date.

1502: END IF; --end if of l_b_rel_exists
1503: END IF;
1504: END LOOP; -- End Loop Of Cursor c_get_todo_ref_recs
1505: -- This Flag Will Be True If All The Records Identified By The Cursor Are Processed Sucessfully By The
1506: -- Assess_fee_pvt Procedure Then Update The Igs_pe_std_todo Table Logical_delete Date With The System Date.
1507: OPEN c_check_child_exists(cp_n_person_id =>l_c_get_todo_recs.person_id,
1508: cp_n_sequence_number =>l_c_get_todo_recs.sequence_number,
1509: cp_v_todo_type =>'SPECIAL_FEE' );
1510: FETCH c_check_child_exists INTO l_check_child_exists;

Line 1512: igs_pe_std_todo_pkg.update_row(x_rowid =>l_c_get_todo_recs.rowid,

1508: cp_n_sequence_number =>l_c_get_todo_recs.sequence_number,
1509: cp_v_todo_type =>'SPECIAL_FEE' );
1510: FETCH c_check_child_exists INTO l_check_child_exists;
1511: IF c_check_child_exists%NOTFOUND THEN
1512: igs_pe_std_todo_pkg.update_row(x_rowid =>l_c_get_todo_recs.rowid,
1513: x_person_id =>l_c_get_todo_recs.person_id,
1514: x_s_student_todo_type =>l_c_get_todo_recs.s_student_todo_type,
1515: x_sequence_number =>l_c_get_todo_recs.sequence_number,
1516: x_todo_dt =>l_c_get_todo_recs.todo_dt ,