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_PS_CAL_RSR_VAL dependencies on IGS_CA_INST_ALL

Line 439: l_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;

435: --sarakshi 25-Nov-2003 Bug#3191862, Modified the cursors cur_units,cur_teach_to_load also moved the
436: -- updation in a local procedure and calling only once for a unit using local variable.
437: --sarakshi 06-Nov-2003 Enh#3116171, Added billing_credit_points for igs_ps_unit_ver_pkg.update_row
438: -------------------------------------------------------------------
439: l_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
441:
442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;
443:

Line 440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;

436: -- updation in a local procedure and calling only once for a unit using local variable.
437: --sarakshi 06-Nov-2003 Enh#3116171, Added billing_credit_points for igs_ps_unit_ver_pkg.update_row
438: -------------------------------------------------------------------
439: l_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
441:
442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;
443:
444: CURSOR cur_load_to_teach( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,

Line 442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;

438: -------------------------------------------------------------------
439: l_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
441:
442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;
443:
444: CURSOR cur_load_to_teach( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
445: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE
446: ) IS

Line 444: CURSOR cur_load_to_teach( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,

440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
441:
442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;
443:
444: CURSOR cur_load_to_teach( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
445: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE
446: ) IS
447: SELECT teach_cal_type,
448: teach_ci_sequence_number,

Line 445: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE

441:
442: l_recent_teach_start_date IGS_CA_INST_ALL.START_DT%TYPE;
443:
444: CURSOR cur_load_to_teach( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
445: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE
446: ) IS
447: SELECT teach_cal_type,
448: teach_ci_sequence_number,
449: teach_start_dt

Line 456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,

452: load_ci_sequence_number = p_input_load_sequence_number
453: ORDER BY teach_start_dt DESC;
454: cur_load_to_teach_rec cur_load_to_teach%ROWTYPE;
455:
456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

Line 457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS

453: ORDER BY teach_start_dt DESC;
454: cur_load_to_teach_rec cur_load_to_teach%ROWTYPE;
455:
456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
461: WHERE lteach.load_cal_type = p_input_load_cal_type AND

Line 473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS

469: uop.delete_flag='N';
470:
471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,
476: ci.start_dt
477: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci

Line 489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS

485: cur_ps_unit_ofr_opt_enroll_rec cur_ps_unit_ofr_opt_enroll%ROWTYPE;
486:
487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,
492: ci.start_dt
493: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci

Line 504: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,

500: uoov.version_number = p_version_number
501: ORDER BY ci.start_dt DESC;
502: cur_ps_unit_ofr_opt_offer_rec cur_ps_unit_ofr_opt_offer%ROWTYPE;
503:
504: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
505: p_teach_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
506: SELECT load_cal_type,
507: load_ci_sequence_number,
508: load_start_dt

Line 505: p_teach_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS

501: ORDER BY ci.start_dt DESC;
502: cur_ps_unit_ofr_opt_offer_rec cur_ps_unit_ofr_opt_offer%ROWTYPE;
503:
504: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
505: p_teach_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
506: SELECT load_cal_type,
507: load_ci_sequence_number,
508: load_start_dt
509: FROM igs_ca_teach_to_load_v