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_EN_INS_CA_TRNSFR dependencies on IGS_RE_THS_PNL_MR_HS

Line 704: cp_the_sequence_number IGS_RE_THS_PNL_MR_HS.the_sequence_number%TYPE,

700: tpm.ca_sequence_number = p_transfer_ca_sequence_number AND
701: tpm.the_sequence_number = cp_tex_the_sequence_number AND
702: tpm.creation_dt = cp_tex_creation_dt;
703: CURSOR c_tpmh (
704: cp_the_sequence_number IGS_RE_THS_PNL_MR_HS.the_sequence_number%TYPE,
705: cp_tpm_creation_dt IGS_RE_THS_PNL_MR_HS.creation_dt%TYPE,
706: cp_tpm_person_id IGS_RE_THS_PNL_MR_HS.person_id%TYPE) IS
707: SELECT tpmh.hist_start_dt,
708: tpmh.hist_end_dt,

Line 705: cp_tpm_creation_dt IGS_RE_THS_PNL_MR_HS.creation_dt%TYPE,

701: tpm.the_sequence_number = cp_tex_the_sequence_number AND
702: tpm.creation_dt = cp_tex_creation_dt;
703: CURSOR c_tpmh (
704: cp_the_sequence_number IGS_RE_THS_PNL_MR_HS.the_sequence_number%TYPE,
705: cp_tpm_creation_dt IGS_RE_THS_PNL_MR_HS.creation_dt%TYPE,
706: cp_tpm_person_id IGS_RE_THS_PNL_MR_HS.person_id%TYPE) IS
707: SELECT tpmh.hist_start_dt,
708: tpmh.hist_end_dt,
709: tpmh.thesis_result_cd

Line 706: cp_tpm_person_id IGS_RE_THS_PNL_MR_HS.person_id%TYPE) IS

702: tpm.creation_dt = cp_tex_creation_dt;
703: CURSOR c_tpmh (
704: cp_the_sequence_number IGS_RE_THS_PNL_MR_HS.the_sequence_number%TYPE,
705: cp_tpm_creation_dt IGS_RE_THS_PNL_MR_HS.creation_dt%TYPE,
706: cp_tpm_person_id IGS_RE_THS_PNL_MR_HS.person_id%TYPE) IS
707: SELECT tpmh.hist_start_dt,
708: tpmh.hist_end_dt,
709: tpmh.thesis_result_cd
710: FROM IGS_RE_THS_PNL_MR_HS tpmh

Line 710: FROM IGS_RE_THS_PNL_MR_HS tpmh

706: cp_tpm_person_id IGS_RE_THS_PNL_MR_HS.person_id%TYPE) IS
707: SELECT tpmh.hist_start_dt,
708: tpmh.hist_end_dt,
709: tpmh.thesis_result_cd
710: FROM IGS_RE_THS_PNL_MR_HS tpmh
711: WHERE tpmh.ca_person_id = p_person_id AND
712: tpmh.ca_sequence_number = p_transfer_ca_sequence_number AND
713: tpmh.the_sequence_number = cp_the_sequence_number AND
714: tpmh.creation_dt = cp_tpm_creation_dt AND

Line 881: IGS_RE_THS_PNL_MR_HS_PKG.INSERT_ROW (

877: l_rowid VARCHAR2(25);
878: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
879: BEGIN
880:
881: IGS_RE_THS_PNL_MR_HS_PKG.INSERT_ROW (
882: x_rowid => l_rowid,
883: X_org_id => l_org_id,
884: x_ca_person_id=> p_person_id,
885: x_ca_sequence_number => p_ca_sequence_number,