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_006 dependencies on IGS_EN_UNIT_SET

Line 195: v_administrative_ind IGS_EN_UNIT_SET.administrative_ind%TYPE;

191: -- This module fetches the value for the administrative_ind for a
192: -- IGS_PS_UNIT set from the unit_set_table.
193: DECLARE
194:
195: v_administrative_ind IGS_EN_UNIT_SET.administrative_ind%TYPE;
196: CURSOR c_us IS
197: SELECT us.administrative_ind
198: FROM IGS_EN_UNIT_SET us
199: WHERE us.unit_set_cd = p_unit_set_cd AND

Line 198: FROM IGS_EN_UNIT_SET us

194:
195: v_administrative_ind IGS_EN_UNIT_SET.administrative_ind%TYPE;
196: CURSOR c_us IS
197: SELECT us.administrative_ind
198: FROM IGS_EN_UNIT_SET us
199: WHERE us.unit_set_cd = p_unit_set_cd AND
200: us.version_number = p_version_number;
201: BEGIN
202: -- 1. Fetch the administrative indicator

Line 238: -- IGS_PS_UNIT set from the IGS_EN_UNIT_SET_STAT table.

234: BEGIN
235:
236: -- crsp_get_us_sys_sts
237: -- This module fetches the value for the system IGS_PS_UNIT set status for a
238: -- IGS_PS_UNIT set from the IGS_EN_UNIT_SET_STAT table.
239: DECLARE
240:
241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;
242: CURSOR c_uss IS

Line 241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;

237: -- This module fetches the value for the system IGS_PS_UNIT set status for a
238: -- IGS_PS_UNIT set from the IGS_EN_UNIT_SET_STAT table.
239: DECLARE
240:
241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;
242: CURSOR c_uss IS
243: SELECT uss.s_unit_set_status
244: FROM IGS_EN_UNIT_SET_STAT uss
245: WHERE uss.unit_set_status = p_unit_set_status;

Line 244: FROM IGS_EN_UNIT_SET_STAT uss

240:
241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;
242: CURSOR c_uss IS
243: SELECT uss.s_unit_set_status
244: FROM IGS_EN_UNIT_SET_STAT uss
245: WHERE uss.unit_set_status = p_unit_set_status;
246: BEGIN
247: -- Get the system IGS_PS_UNIT set status
248: OPEN c_uss;

Line 867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from

863: p_old_update_on IN DATE )
864: AS
865: lv_param_values VARCHAR2(1080);
866: BEGIN -- crsp_ins_us_hist
867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from
868: -- relevant reference data records for historical purposes.
869: DECLARE
870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;

Line 871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;

867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from
868: -- relevant reference data records for historical purposes.
869: DECLARE
870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;
872: v_create_history BOOLEAN := FALSE;
873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;

Line 873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;

869: DECLARE
870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;
872: v_create_history BOOLEAN := FALSE;
873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;
876: CURSOR c_ou IS
877: SELECT ou.party_name description

Line 874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;

870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;
872: v_create_history BOOLEAN := FALSE;
873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;
876: CURSOR c_ou IS
877: SELECT ou.party_name description
878: FROM IGS_OR_INST_ORG_BASE_V ou

Line 875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;

871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;
872: v_create_history BOOLEAN := FALSE;
873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;
876: CURSOR c_ou IS
877: SELECT ou.party_name description
878: FROM IGS_OR_INST_ORG_BASE_V ou
879: WHERE ou.party_number = p_old_responsible_org_unit_cd AND

Line 885: -- If any of the old IGS_EN_UNIT_SET values (p_old_) are different from

881:
882: x_rowid VARCHAR2(25);
883: l_org_id NUMBER(15);
884: BEGIN
885: -- If any of the old IGS_EN_UNIT_SET values (p_old_) are different from
886: -- the associated new IGS_EN_UNIT_SET values (p_new_) (with the
887: -- exception of the LAST_UPDATED_BY and LAST_UPDATE_DATE columns) then create a
888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values
889: -- (p_old_). Only write the changed values to the history

Line 886: -- the associated new IGS_EN_UNIT_SET values (p_new_) (with the

882: x_rowid VARCHAR2(25);
883: l_org_id NUMBER(15);
884: BEGIN
885: -- If any of the old IGS_EN_UNIT_SET values (p_old_) are different from
886: -- the associated new IGS_EN_UNIT_SET values (p_new_) (with the
887: -- exception of the LAST_UPDATED_BY and LAST_UPDATE_DATE columns) then create a
888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values
889: -- (p_old_). Only write the changed values to the history
890: -- record. Do not set the LAST_UPDATED_BY and LAST_UPDATE_DATE columns when creating the

Line 888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values

884: BEGIN
885: -- If any of the old IGS_EN_UNIT_SET values (p_old_) are different from
886: -- the associated new IGS_EN_UNIT_SET values (p_new_) (with the
887: -- exception of the LAST_UPDATED_BY and LAST_UPDATE_DATE columns) then create a
888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values
889: -- (p_old_). Only write the changed values to the history
890: -- record. Do not set the LAST_UPDATED_BY and LAST_UPDATE_DATE columns when creating the
891: -- history record.
892: IF p_new_unit_set_status <> p_old_unit_set_status THEN

Line 990: IGS_EN_UNIT_SET_HIST_PKG.Insert_Row(

986: END IF;
987:
988: l_org_id := igs_ge_gen_003.get_org_id;
989:
990: IGS_EN_UNIT_SET_HIST_PKG.Insert_Row(
991: X_ROWID => x_rowid,
992: X_UNIT_SET_CD => v_ush_rec.unit_set_cd,
993: X_VERSION_NUMBER => v_ush_rec.version_number,
994: X_HIST_START_DT => v_ush_rec.hist_start_dt,