APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_AD_TSTRST_UH_INT

Line 36: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTRST_UH_INT', cascade => TRUE);

32:
33: BEGIN
34: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
35:
36: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTRST_UH_INT', cascade => TRUE);
37: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTDTL_UH_INT', cascade => TRUE);
38: EXCEPTION WHEN OTHERS THEN
39: NULL;
40: END;

Line 92: 1. IGS_AD_TSTRST_UH_INT ( Test Results Interface table)

88: p_session_id IN NUMBER
89: ) IS
90: /*
91: This procedure imports the records from the interface tables
92: 1. IGS_AD_TSTRST_UH_INT ( Test Results Interface table)
93: 2. IGS_AD_TSTDTL_UH_INT ( Test Results Details Interface table)
94: into the corresponding OSS tables viz.,
95: 1. IGS_AD_TEST_RESULTS ( Test results system table)
96: 2. IGS_AD_TST_RSLT_DTLS ( Test Results Details system table)

Line 106: igs_ad_tstrst_uh_int

102: CURSOR c_tst_cur IS
103: SELECT
104: *
105: FROM
106: igs_ad_tstrst_uh_int
107: WHERE
108: PERSON_ID = p_person_id AND
109: SESSION_ID = p_session_id AND
110: STATUS = '2';

Line 113: SELECT SUM(B.TEST_SCORE) FROM IGS_AD_TSTRST_UH_INT A,IGS_AD_TSTDTL_UH_INT B

109: SESSION_ID = p_session_id AND
110: STATUS = '2';
111:
112: CURSOR c_test_scores IS
113: SELECT SUM(B.TEST_SCORE) FROM IGS_AD_TSTRST_UH_INT A,IGS_AD_TSTDTL_UH_INT B
114: WHERE A.INTERFACE_TST_ID = B.INTERFACE_TST_ID
115: AND A.PERSON_ID = p_person_id
116: AND A.SESSION_ID = p_session_id
117: AND B.TEST_SEGMENT_ID IN (SELECT TEST_SEGMENT_ID

Line 157: l_error_code IGS_AD_TSTRST_UH_INT.ERROR_CODE%TYPE;

153: admission_test_type = cp_test_type AND
154: active_ind = 'Y' AND
155: test_results_id <> cp_test_results_id;
156:
157: l_error_code IGS_AD_TSTRST_UH_INT.ERROR_CODE%TYPE;
158: l_status IGS_AD_TSTRST_UH_INT.STATUS%TYPE;
159: l_tst_rowid VARCHAR2(25);
160: l_tstdtl_rowid VARCHAR2(25);
161: l_test_results_id NUMBER(15);

Line 158: l_status IGS_AD_TSTRST_UH_INT.STATUS%TYPE;

154: active_ind = 'Y' AND
155: test_results_id <> cp_test_results_id;
156:
157: l_error_code IGS_AD_TSTRST_UH_INT.ERROR_CODE%TYPE;
158: l_status IGS_AD_TSTRST_UH_INT.STATUS%TYPE;
159: l_tst_rowid VARCHAR2(25);
160: l_tstdtl_rowid VARCHAR2(25);
161: l_test_results_id NUMBER(15);
162: l_tst_rslt_dtls_id NUMBER(15);

Line 411: igs_ad_tstrst_uh_int

407: WHERE
408: interface_tst_id = c_tst_rec.interface_tst_id;
409:
410: DELETE FROM
411: igs_ad_tstrst_uh_int
412: WHERE
413: interface_tst_id = c_tst_rec.interface_tst_id;
414: ELSE
415: ROLLBACK TO before_tsttype;

Line 417: igs_ad_tstrst_uh_int

413: interface_tst_id = c_tst_rec.interface_tst_id;
414: ELSE
415: ROLLBACK TO before_tsttype;
416: UPDATE
417: igs_ad_tstrst_uh_int
418: SET
419: status = '3',
420: error_code = l_error_code
421: WHERE