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_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_RES_DTLS_INT

Line 751: -- before populating IGS_PE_RES_DTLS_INT

747:
748: IF chk_src_cat(l_src_type_id,'PERSON_RESIDENCY_DETAILS') THEN
749:
750: -- anwest UCFD040 Bug# 4015492 New logic to retrieve Load Calender
751: -- before populating IGS_PE_RES_DTLS_INT
752:
753: l_term_cal_type := NULL;
754: l_term_sequence_number := NULL;
755:

Line 2049: Purpose : Populate the Residency Details Interface Table, IGS_PE_RES_DTLS_INT

2045: p_app_valid_status IN OUT NOCOPY BOOLEAN) AS
2046: /******************************************************************
2047: Created By : AYEDUBAT
2048: Date Created By : 16-JUN-2003
2049: Purpose : Populate the Residency Details Interface Table, IGS_PE_RES_DTLS_INT
2050: and set the parameter,p_app_valid_status to FALSE
2051: if any validation is failed or an exception is raised.
2052: Known limitations,enhancements,remarks:
2053:

Line 2056: dsridhar 25-SEP-2003 Bug No. 2980137. While inserting into IGS_PE_RES_DTLS_INT,

2052: Known limitations,enhancements,remarks:
2053:
2054: CHANGE HISTORY:
2055: WHO WHEN WHAT
2056: dsridhar 25-SEP-2003 Bug No. 2980137. While inserting into IGS_PE_RES_DTLS_INT,
2057: the EVALUATOR field is populated with PERSON_NUMBER instead
2058: of DECISION_MAKE_ID. Added a cursor to get the PERSON_NUMBER
2059: from DECISION_MAKE_ID. Added a new variable p_retcode to this
2060: procedure to return the error code in case of an error.

Line 2117: -- Populate the residency details import interface table,IGS_PE_RES_DTLS_INT

2113: OPEN cur_person_number;
2114: FETCH cur_person_number INTO l_person_number;
2115: CLOSE cur_person_number;
2116:
2117: -- Populate the residency details import interface table,IGS_PE_RES_DTLS_INT
2118: INSERT INTO IGS_PE_RES_DTLS_INT (
2119: INTERFACE_RES_ID,
2120: INTERFACE_ID,
2121: RESIDENCY_STATUS_CD,

Line 2118: INSERT INTO IGS_PE_RES_DTLS_INT (

2114: FETCH cur_person_number INTO l_person_number;
2115: CLOSE cur_person_number;
2116:
2117: -- Populate the residency details import interface table,IGS_PE_RES_DTLS_INT
2118: INSERT INTO IGS_PE_RES_DTLS_INT (
2119: INTERFACE_RES_ID,
2120: INTERFACE_ID,
2121: RESIDENCY_STATUS_CD,
2122: RESIDENCY_CLASS_CD,

Line 2134: igs_pe_res_dtls_int_s.NEXTVAL

2130: LAST_UPDATE_LOGIN,
2131: CAL_TYPE, -- anwest UCFD040 Bug# 4015492 Added new parameter
2132: SEQUENCE_NUMBER) -- anwest UCFD040 Bug# 4015492 Added new parameter
2133: VALUES (
2134: igs_pe_res_dtls_int_s.NEXTVAL
2135: ,p_interface_id
2136: ,l_residency_status_cd
2137: ,fnd_profile.value('IGS_FI_RES_CLASS_ID')
2138: ,TRUNC(SYSDATE)