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_AD_IMP_ADM_DES dependencies on IGS_AD_ADMDE_INT

Line 34: p_status IN igs_ad_admde_int.status%TYPE,

30: *=======================================================================*/
31:
32:
33: PROCEDURE update_int_table (
34: p_status IN igs_ad_admde_int.status%TYPE,
35: p_error_msg IN fnd_new_messages.message_text%TYPE, -- Replaced error_code with error_msg Bug 3297241
36: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
37: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE
38: )

Line 36: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,

32:
33: PROCEDURE update_int_table (
34: p_status IN igs_ad_admde_int.status%TYPE,
35: p_error_msg IN fnd_new_messages.message_text%TYPE, -- Replaced error_code with error_msg Bug 3297241
36: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
37: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE
38: )
39: IS
40: ------------------------------------------------------------------

Line 37: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE

33: PROCEDURE update_int_table (
34: p_status IN igs_ad_admde_int.status%TYPE,
35: p_error_msg IN fnd_new_messages.message_text%TYPE, -- Replaced error_code with error_msg Bug 3297241
36: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
37: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE
38: )
39: IS
40: ------------------------------------------------------------------
41: --Created by : rrengara, Oracle India (in)

Line 53: UPDATE igs_ad_admde_int

49: --Change History:
50: --Who When What
51: -------------------------------------------------------------------
52: BEGIN
53: UPDATE igs_ad_admde_int
54: SET status = p_status,
55: error_text = p_error_msg
56: WHERE interface_mkdes_id = p_interface_mkdes_id;
57: END update_int_table;

Line 60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,

56: WHERE interface_mkdes_id = p_interface_mkdes_id;
57: END update_int_table;
58:
59: PROCEDURE validate_set_decision_details (
60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,

57: END update_int_table;
58:
59: PROCEDURE validate_set_decision_details (
60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,

Line 78: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL

74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL
79: )
80: IS
81: ------------------------------------------------------------------
82: --Created by : rrengara, Oracle India (in)

Line 113: FROM igs_ad_admde_int

109: CURSOR appl_des_fields_cur
110: IS
111: SELECT person_id, decision_make_id, decision_date, decision_reason_id,
112: pending_reason_id, offer_dt, offer_response_dt, admission_appl_number
113: FROM igs_ad_admde_int
114: WHERE interface_mkdes_id = p_interface_mkdes_id;
115:
116: l_c_def_fields_rec def_fields_cur%ROWTYPE;
117: l_c_appl_des_fields_rec appl_des_fields_cur%ROWTYPE;

Line 263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,

259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
267: p_return_status OUT NOCOPY VARCHAR2,

Line 264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,

260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
267: p_return_status OUT NOCOPY VARCHAR2,
268: p_ucas_transaction IN VARCHAR2,

Line 265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,

261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
267: p_return_status OUT NOCOPY VARCHAR2,
268: p_ucas_transaction IN VARCHAR2,
269: p_reconsideration IN VARCHAR2,

Line 270: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE

266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
267: p_return_status OUT NOCOPY VARCHAR2,
268: p_ucas_transaction IN VARCHAR2,
269: p_reconsideration IN VARCHAR2,
270: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE
271: )
272: IS
273: ------------------------------------------------------------------
274: -- Created by : rrengara, Oracle India (in)

Line 498: UPDATE igs_ad_admde_int_all

494: update_int_table ('3', l_msg_data, p_interface_mkdes_id, p_adm_outcome_status);
495: p_error_message := l_sqlerrm;
496: p_return_status := 'FALSE';
497: ELSE
498: UPDATE igs_ad_admde_int_all
499: SET status = '1'
500: WHERE interface_mkdes_id = p_interface_mkdes_id;
501: p_return_status := 'TRUE';
502: END IF;

Line 508: UPDATE igs_ad_admde_int SET status = '3', error_text = l_sqlerrm WHERE interface_mkdes_id = p_interface_mkdes_id;

504:
505: EXCEPTION WHEN OTHERS THEN
506: l_sqlerrm := SQLERRM;
507:
508: UPDATE igs_ad_admde_int SET status = '3', error_text = l_sqlerrm WHERE interface_mkdes_id = p_interface_mkdes_id;
509: p_error_message := l_sqlerrm;
510: p_return_status := 'FALSE';
511: RETURN;
512:

Line 546: FROM igs_ad_admde_int_all mdi, igs_ad_batc_def_det_all abdd

542: abdd.S_ADMISSION_PROCESS_TYPE IS NOT NULL) ) ;
543:
544: CURSOR c_admde_int IS
545: SELECT mdi.*
546: FROM igs_ad_admde_int_all mdi, igs_ad_batc_def_det_all abdd
547: WHERE mdi.batch_id = p_batch_id
548: AND mdi.batch_id = abdd.batch_id
549: AND EXISTS ( SELECT 1
550: FROM igs_ad_ps_appl_inst aplinst, igs_ad_appl appl

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

592: l_gather_return BOOLEAN;
593: BEGIN
594: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
595: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_BATC_DEF_DET', cascade => TRUE);
596: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_ADMDE_INT', cascade => TRUE);
597: EXCEPTION
598: WHEN OTHERS THEN
599: NULL;
600: END;

Line 672: DELETE FROM igs_ad_admde_int_all

668: IF l_msg_token_rec_prc_cnt > 0 THEN
669: p_message_name := 'IGS_AD_PROCESS_N_RECORDS';
670: p_msg_token_rec_prc_cnt := l_msg_token_rec_prc_cnt;
671:
672: DELETE FROM igs_ad_admde_int_all
673: WHERE batch_id = p_batch_id
674: AND status = '1';
675: COMMIT;
676:

Line 693: FROM igs_ad_admde_int_all

689: l_processed_records NUMBER := 0;
690:
691: CURSOR c_admde_int IS
692: SELECT *
693: FROM igs_ad_admde_int_all
694: WHERE batch_id = p_batch_id
695: AND status = '2';
696:
697: BEGIN

Line 703: DELETE FROM igs_ad_admde_int_all

699: LOOP
700: l_msg_token_rec_prc_cnt := l_msg_token_rec_prc_cnt + 1;
701: l_processed_records := l_processed_records + 1;
702:
703: DELETE FROM igs_ad_admde_int_all
704: WHERE interface_mkdes_id = c_admde_int_rec.interface_mkdes_id;
705:
706: IF l_processed_records = 100 THEN
707: COMMIT;