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_TI_COMP dependencies on IGS_TR_STEP

Line 5: p_tracking_id igs_tr_step.tracking_id%TYPE,

1: PACKAGE BODY igs_ad_ti_comp AS
2: /* $Header: IGSADA3B.pls 120.4 2006/04/25 04:17:09 rghosh ship $ */
3:
4: FUNCTION upd_trk_step_complete (
5: p_tracking_id igs_tr_step.tracking_id%TYPE,
6: p_tracking_step_id igs_tr_step.tracking_step_id%TYPE,
7: p_s_tracking_step_type igs_tr_step.s_tracking_step_type%TYPE,
8: p_recipient_id igs_tr_step.recipient_id%TYPE) RETURN BOOLEAN
9:

Line 6: p_tracking_step_id igs_tr_step.tracking_step_id%TYPE,

2: /* $Header: IGSADA3B.pls 120.4 2006/04/25 04:17:09 rghosh ship $ */
3:
4: FUNCTION upd_trk_step_complete (
5: p_tracking_id igs_tr_step.tracking_id%TYPE,
6: p_tracking_step_id igs_tr_step.tracking_step_id%TYPE,
7: p_s_tracking_step_type igs_tr_step.s_tracking_step_type%TYPE,
8: p_recipient_id igs_tr_step.recipient_id%TYPE) RETURN BOOLEAN
9:
10: IS

Line 7: p_s_tracking_step_type igs_tr_step.s_tracking_step_type%TYPE,

3:
4: FUNCTION upd_trk_step_complete (
5: p_tracking_id igs_tr_step.tracking_id%TYPE,
6: p_tracking_step_id igs_tr_step.tracking_step_id%TYPE,
7: p_s_tracking_step_type igs_tr_step.s_tracking_step_type%TYPE,
8: p_recipient_id igs_tr_step.recipient_id%TYPE) RETURN BOOLEAN
9:
10: IS
11: l_message_name VARCHAR2(30);

Line 8: p_recipient_id igs_tr_step.recipient_id%TYPE) RETURN BOOLEAN

4: FUNCTION upd_trk_step_complete (
5: p_tracking_id igs_tr_step.tracking_id%TYPE,
6: p_tracking_step_id igs_tr_step.tracking_step_id%TYPE,
7: p_s_tracking_step_type igs_tr_step.s_tracking_step_type%TYPE,
8: p_recipient_id igs_tr_step.recipient_id%TYPE) RETURN BOOLEAN
9:
10: IS
11: l_message_name VARCHAR2(30);
12: BEGIN

Line 47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,

43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,
50: p_recipient_id IN igs_tr_step.recipient_id%TYPE
51: ) RETURN BOOLEAN AS

Line 48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,

44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,
50: p_recipient_id IN igs_tr_step.recipient_id%TYPE
51: ) RETURN BOOLEAN AS
52: /*

Line 49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,

45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,
50: p_recipient_id IN igs_tr_step.recipient_id%TYPE
51: ) RETURN BOOLEAN AS
52: /*
53: || Created By : brajendr

Line 50: p_recipient_id IN igs_tr_step.recipient_id%TYPE

46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,
50: p_recipient_id IN igs_tr_step.recipient_id%TYPE
51: ) RETURN BOOLEAN AS
52: /*
53: || Created By : brajendr
54: || Created On :

Line 85: p_tracking_id IN igs_tr_step.tracking_id%TYPE,

81:
82: -- Get all the Credential details for each application of the Person.
83: CURSOR cur_credentials(
84: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
85: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
86: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
87: ) IS
88: SELECT DISTINCT 1
89: FROM igs_pe_credentials pc,

Line 86: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE

82: -- Get all the Credential details for each application of the Person.
83: CURSOR cur_credentials(
84: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
85: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
86: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
87: ) IS
88: SELECT DISTINCT 1
89: FROM igs_pe_credentials pc,
90: igs_ad_cred_types act,

Line 91: igs_tr_step ts

87: ) IS
88: SELECT DISTINCT 1
89: FROM igs_pe_credentials pc,
90: igs_ad_cred_types act,
91: igs_tr_step ts
92: WHERE pc.person_id = p_person_id
93: AND act.credential_type_id = pc.credential_type_id
94: AND ts.step_catalog_cd = act.step_code
95: AND ts.tracking_id = p_tracking_id

Line 101: p_tracking_id IN igs_tr_step.tracking_id%TYPE,

97:
98: -- Get all the Test details for each application of the Person.
99: CURSOR cur_test(
100: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
101: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
102: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
103: ) IS
104: SELECT DISTINCT 1
105: FROM igs_ad_test_results atr,

Line 102: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE

98: -- Get all the Test details for each application of the Person.
99: CURSOR cur_test(
100: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
101: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
102: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
103: ) IS
104: SELECT DISTINCT 1
105: FROM igs_ad_test_results atr,
106: igs_ad_test_type att,

Line 107: igs_tr_step ts

103: ) IS
104: SELECT DISTINCT 1
105: FROM igs_ad_test_results atr,
106: igs_ad_test_type att,
107: igs_tr_step ts
108: WHERE ts.tracking_id = p_tracking_id
109: AND ts.tracking_step_id = p_tracking_step_id
110: AND att.step_code =ts.step_catalog_cd
111: AND atr.admission_test_type = att.admission_test_type

Line 206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,

202: -- Get the Personal Statements for the person
203: CURSOR cur_pers_statements(
204: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
205: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
208: ) IS
209: SELECT DISTINCT 1
210: FROM igs_ad_appl_perstat aaps,

Line 207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE

203: CURSOR cur_pers_statements(
204: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
205: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
208: ) IS
209: SELECT DISTINCT 1
210: FROM igs_ad_appl_perstat aaps,
211: igs_ad_per_stm_typ apst,

Line 212: igs_tr_step ts

208: ) IS
209: SELECT DISTINCT 1
210: FROM igs_ad_appl_perstat aaps,
211: igs_ad_per_stm_typ apst,
212: igs_tr_step ts
213: WHERE ts.tracking_id = p_tracking_id
214: AND ts.tracking_step_id = p_tracking_step_id
215: AND apst.step_catalog_cd =ts.step_catalog_cd
216: AND aaps.persl_stat_type =apst.persl_stat_type

Line 576: FROM igs_tr_step ts

572: CURSOR cur_tr_stp(
573: p_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE
574: ) IS
575: SELECT tracking_step_id, s_tracking_step_type, recipient_id
576: FROM igs_tr_step ts
577: WHERE ts.tracking_id = p_tracking_id
578: AND ts.step_completion_ind='N'
579: AND ts.by_pass_ind = 'N'
580: AND ts.completion_dt IS NULL