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_GEN_001 dependencies on IGS_PS_TCH_RESP_OVRD

Line 2302: FROM igs_ps_tch_resp_ovrd

2298:
2299: --22
2300: CURSOR usec_tro (cp_uoo_id NUMBER) IS
2301: SELECT *
2302: FROM igs_ps_tch_resp_ovrd
2303: WHERE uoo_id = cp_uoo_id;
2304:
2305: --23
2306: CURSOR c_usec_spl_fees (cp_uoo_id NUMBER) IS

Line 3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,

3871: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
3872: l_ou_exists VARCHAR2(1);
3873: l_rowid VARCHAR2(25);
3874:
3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,
3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,

Line 3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,

3872: l_ou_exists VARCHAR2(1);
3873: l_rowid VARCHAR2(25);
3874:
3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,
3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,

Line 3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,

3873: l_rowid VARCHAR2(25);
3874:
3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,
3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,

Line 3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,

3874:
3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,
3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS

Line 3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,

3875: CURSOR cur_usec_tro_new (cp_unit_cd igs_ps_tch_resp_ovrd.unit_cd%TYPE,
3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS
3883: SELECT 'X'

Line 3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,

3876: cp_version_number igs_ps_tch_resp_ovrd.version_number%TYPE,
3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS
3883: SELECT 'X'
3884: FROM igs_ps_tch_resp_ovrd

Line 3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,

3877: cp_cal_type igs_ps_tch_resp_ovrd.cal_type%TYPE,
3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS
3883: SELECT 'X'
3884: FROM igs_ps_tch_resp_ovrd
3885: WHERE unit_cd = cp_unit_cd

Line 3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS

3878: cp_ci_sequence_number igs_ps_tch_resp_ovrd.ci_sequence_number%TYPE,
3879: cp_location_cd igs_ps_tch_resp_ovrd.location_cd%TYPE,
3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS
3883: SELECT 'X'
3884: FROM igs_ps_tch_resp_ovrd
3885: WHERE unit_cd = cp_unit_cd
3886: AND version_number = cp_version_number

Line 3884: FROM igs_ps_tch_resp_ovrd

3880: cp_unit_class igs_ps_tch_resp_ovrd.unit_class%TYPE,
3881: cp_org_unit_cd igs_ps_tch_resp_ovrd.org_unit_cd%TYPE,
3882: cp_ou_start_dt igs_ps_tch_resp_ovrd.ou_start_dt%TYPE) IS
3883: SELECT 'X'
3884: FROM igs_ps_tch_resp_ovrd
3885: WHERE unit_cd = cp_unit_cd
3886: AND version_number = cp_version_number
3887: AND cal_type = cp_cal_type
3888: AND ci_sequence_number = cp_ci_sequence_number

Line 3926: igs_ps_tch_resp_ovrd_pkg.insert_row(

3922: FETCH c_ou INTO l_ou_exists;
3923: IF c_ou%FOUND THEN
3924: l_org_id := igs_ge_gen_003.get_org_id;
3925:
3926: igs_ps_tch_resp_ovrd_pkg.insert_row(
3927: x_rowid => l_rowid,
3928: x_unit_cd => gv_new_usec_rec.unit_cd,
3929: x_version_number => gv_new_usec_rec.version_number,
3930: x_cal_type => gv_new_usec_rec.cal_type,