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_PR_VAL_SOPC dependencies on IGS_OR_UNIT

Line 199: -- Validate that the IGS_OR_UNIT is active.

195: App_Exception.Raise_Exception;
196: END prgp_val_cause_ind;
197: --
198: --
199: -- Validate that the IGS_OR_UNIT is active.
200: FUNCTION prgp_val_ou_active(
201: p_org_unit_cd IN VARCHAR2 ,
202: p_start_dt IN DATE ,
203: p_message_name OUT NOCOPY VARCHAR2 )

Line 207: -- Validate that the IGS_OR_UNIT is active.

203: p_message_name OUT NOCOPY VARCHAR2 )
204: RETURN BOOLEAN AS
205: gv_other_detail VARCHAR2(255);
206: BEGIN -- prgp_val_ou_active
207: -- Validate that the IGS_OR_UNIT is active.
208: DECLARE
209: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
210: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
211: CURSOR c_os_ou IS

Line 213: FROM IGS_OR_UNIT ou,

209: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
210: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
211: CURSOR c_os_ou IS
212: SELECT os.s_org_status
213: FROM IGS_OR_UNIT ou,
214: IGS_OR_STATUS os
215: WHERE ou.org_unit_cd = p_org_unit_cd AND
216: ou.start_dt = p_start_dt AND
217: os.org_status = ou.org_status;