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_027 dependencies on IGS_AD_INTERFACE

Line 34: PROCEDURE prc_appl_hist ( p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,

30: cst_ec_val_E689 CONSTANT VARCHAR2(4) := 'E689';
31: cst_ec_val_E709 CONSTANT VARCHAR2(4) := 'E709';
32: cst_ec_val_E710 CONSTANT VARCHAR2(4) := 'E710';
33:
34: PROCEDURE prc_appl_hist ( p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,
35: p_enable_log VARCHAR2,
36: p_rule VARCHAR2) AS
37:
38: /*************************************

Line 76: l_person_id igs_ad_interface.person_id%TYPE;

72: appl_dtls_rec c_appl_dtls_cur%ROWTYPE;
73:
74: l_status VARCHAR2(1);
75:
76: l_person_id igs_ad_interface.person_id%TYPE;
77: l_admission_appl_number igs_ad_apphist_int.admission_appl_number%TYPE;
78:
79: l_person_id_errored igs_ad_interface.person_id%TYPE;
80: l_adm_appl_num_errored igs_ad_apphist_int.admission_appl_number%TYPE;

Line 79: l_person_id_errored igs_ad_interface.person_id%TYPE;

75:
76: l_person_id igs_ad_interface.person_id%TYPE;
77: l_admission_appl_number igs_ad_apphist_int.admission_appl_number%TYPE;
78:
79: l_person_id_errored igs_ad_interface.person_id%TYPE;
80: l_adm_appl_num_errored igs_ad_apphist_int.admission_appl_number%TYPE;
81:
82: l_prog_label VARCHAR2(100);
83: l_label VARCHAR2(100);

Line 99: p_status OUT NOCOPY igs_ad_interface.status%TYPE,

95: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
96:
97:
98: PROCEDURE validate_appl_hist(p_appl_hist_rec c_appl_hist_cur%ROWTYPE,
99: p_status OUT NOCOPY igs_ad_interface.status%TYPE,
100: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE) IS
101:
102: BEGIN
103: --Validate HIST_START_DT

Line 100: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE) IS

96:
97:
98: PROCEDURE validate_appl_hist(p_appl_hist_rec c_appl_hist_cur%ROWTYPE,
99: p_status OUT NOCOPY igs_ad_interface.status%TYPE,
100: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE) IS
101:
102: BEGIN
103: --Validate HIST_START_DT
104: IF p_appl_hist_rec.hist_start_dt > sysdate THEN

Line 334: PROCEDURE prc_appl_inst_hist (p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,

330: COMMIT;
331:
332: END prc_appl_hist;
333:
334: PROCEDURE prc_appl_inst_hist (p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,
335: p_enable_log VARCHAR2,
336: p_rule VARCHAR2) AS
337:
338: /*************************************

Line 416: l_person_id igs_ad_interface.person_id%TYPE;

412: l_msg_count NUMBER ;
413: l_msg_data VARCHAR2(2000);
414: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
415:
416: l_person_id igs_ad_interface.person_id%TYPE;
417: l_admission_appl_number igs_ad_insthist_int.admission_appl_number%TYPE;
418: l_nominated_course_cd igs_ad_insthist_int.nominated_course_cd%TYPE;
419: l_sequence_number igs_ad_insthist_int.sequence_number%TYPE;
420:

Line 421: l_person_id_errored igs_ad_interface.person_id%TYPE;

417: l_admission_appl_number igs_ad_insthist_int.admission_appl_number%TYPE;
418: l_nominated_course_cd igs_ad_insthist_int.nominated_course_cd%TYPE;
419: l_sequence_number igs_ad_insthist_int.sequence_number%TYPE;
420:
421: l_person_id_errored igs_ad_interface.person_id%TYPE;
422: l_adm_appl_num_errored igs_ad_insthist_int.admission_appl_number%TYPE;
423: l_nominated_course_cd_errored igs_ad_insthist_int.nominated_course_cd%TYPE;
424: l_sequence_number_errored igs_ad_insthist_int.sequence_number%TYPE;
425: l_exist VARCHAR2(1);

Line 429: p_status OUT NOCOPY igs_ad_interface.status%TYPE,

425: l_exist VARCHAR2(1);
426:
427:
428: PROCEDURE validate_applinst_hist(p_applinst_hist_rec c_applinst_hist_cur%ROWTYPE,
429: p_status OUT NOCOPY igs_ad_interface.status%TYPE,
430: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE)
431: IS
432: l_var VARCHAR2(1);
433:

Line 430: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE)

426:
427:
428: PROCEDURE validate_applinst_hist(p_applinst_hist_rec c_applinst_hist_cur%ROWTYPE,
429: p_status OUT NOCOPY igs_ad_interface.status%TYPE,
430: p_error_code OUT NOCOPY igs_ad_interface.error_code%TYPE)
431: IS
432: l_var VARCHAR2(1);
433:
434: CURSOR c_validate_auth_id IS -- should be here