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_OR_PRC_CWLK dependencies on IGS_OR_ORG_ALT_IDTYP

Line 61: FUNCTION validate_alt_id(p_alternate_id_type IN igs_or_org_alt_idtyp.org_alternate_id_type%TYPE)

57: SELECT *
58: FROM IGS_OR_CWLK_DTL_INT
59: WHERE interface_crosswalk_id = cp_cwlk_int_id;
60:
61: FUNCTION validate_alt_id(p_alternate_id_type IN igs_or_org_alt_idtyp.org_alternate_id_type%TYPE)
62: RETURN BOOLEAN AS
63:
64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,
65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,

Line 64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,

60:
61: FUNCTION validate_alt_id(p_alternate_id_type IN igs_or_org_alt_idtyp.org_alternate_id_type%TYPE)
62: RETURN BOOLEAN AS
63:
64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,
65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,
66: cp_org_alternate_id_type igs_or_org_alt_idtyp.org_alternate_id_type%TYPE) IS
67: SELECT rowid
68: FROM igs_or_org_alt_idtyp

Line 65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,

61: FUNCTION validate_alt_id(p_alternate_id_type IN igs_or_org_alt_idtyp.org_alternate_id_type%TYPE)
62: RETURN BOOLEAN AS
63:
64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,
65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,
66: cp_org_alternate_id_type igs_or_org_alt_idtyp.org_alternate_id_type%TYPE) IS
67: SELECT rowid
68: FROM igs_or_org_alt_idtyp
69: WHERE org_alternate_id_type = cp_org_alternate_id_type AND

Line 66: cp_org_alternate_id_type igs_or_org_alt_idtyp.org_alternate_id_type%TYPE) IS

62: RETURN BOOLEAN AS
63:
64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,
65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,
66: cp_org_alternate_id_type igs_or_org_alt_idtyp.org_alternate_id_type%TYPE) IS
67: SELECT rowid
68: FROM igs_or_org_alt_idtyp
69: WHERE org_alternate_id_type = cp_org_alternate_id_type AND
70: CLOSE_IND = cp_close_ind AND

Line 68: FROM igs_or_org_alt_idtyp

64: CURSOR rowid_cur(cp_close_ind igs_or_org_alt_idtyp.close_ind%TYPE,
65: cp_inst_flag igs_or_org_alt_idtyp.inst_flag%TYPE,
66: cp_org_alternate_id_type igs_or_org_alt_idtyp.org_alternate_id_type%TYPE) IS
67: SELECT rowid
68: FROM igs_or_org_alt_idtyp
69: WHERE org_alternate_id_type = cp_org_alternate_id_type AND
70: CLOSE_IND = cp_close_ind AND
71: inst_flag = cp_inst_flag;
72:

Line 125: -- Check if the Alt_Id_Type exists in the IGS_OR_ORG_ALT_IDTYP table

121: -- Crosswalk Id passed from the Crosswalk Interface table(previous cursor)
122:
123: FOR cwlkdtlrec IN cur_cwlk_dtl_int(cwlkrec.interface_crosswalk_id) LOOP
124:
125: -- Check if the Alt_Id_Type exists in the IGS_OR_ORG_ALT_IDTYP table
126: IF NOT validate_alt_id(cwlkdtlrec.alt_id_type) THEN
127:
128: -- If it does not exist, then log the appropriate message in the Concurrent Manager logfile
129: FND_MESSAGE.Set_Name('IGS',