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_AV_LVL_LGCY_PUB dependencies on IGS_CA_INST

Line 84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,

80: (
81: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,

81: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
89: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,

Line 124: p_cal_type IN igs_ca_inst.cal_type%type,

120: FUNCTION validate_lvl_db_cons
121: (
122: p_person_id IN igs_pe_person.person_id%type,
123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 125: p_seq_number IN igs_ca_inst.sequence_number%type,

121: (
122: p_person_id IN igs_pe_person.person_id%type,
123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

Line 144: p_cal_type IN igs_ca_inst.cal_type%type,

140: FUNCTION validate_level
141: (
142: p_person_id IN igs_pe_person.person_id%type,
143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 145: p_seq_number IN igs_ca_inst.sequence_number%type,

141: (
142: p_person_id IN igs_pe_person.person_id%type,
143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
149: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

Line 249: l_cal_type igs_ca_inst.cal_type%type;

245:
246: -- variables declared to fetch data from derive_level_data
247: l_person_id igs_pe_person.person_id%type;
248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;
253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;

Line 250: l_sequence_number igs_ca_inst.sequence_number%type;

246: -- variables declared to fetch data from derive_level_data
247: l_person_id igs_pe_person.person_id%type;
248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;
253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;
254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;

Line 885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,

881: (
882: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,

882: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
890: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,

Line 931: l_start_dt igs_ca_inst.start_dt%TYPE;

927: /*
928: get cal_type and sequence_number
929: */
930: DECLARE
931: l_start_dt igs_ca_inst.start_dt%TYPE;
932: l_end_dt igs_ca_inst.end_dt%TYPE;
933: l_return_status VARCHAR2(2000);
934: BEGIN
935: IGS_GE_GEN_003.GET_CALENDAR_INSTANCE

Line 932: l_end_dt igs_ca_inst.end_dt%TYPE;

928: get cal_type and sequence_number
929: */
930: DECLARE
931: l_start_dt igs_ca_inst.start_dt%TYPE;
932: l_end_dt igs_ca_inst.end_dt%TYPE;
933: l_return_status VARCHAR2(2000);
934: BEGIN
935: IGS_GE_GEN_003.GET_CALENDAR_INSTANCE
936: (

Line 1328: p_cal_type IN igs_ca_inst.cal_type%type,

1324: FUNCTION validate_lvl_db_cons
1325: (
1326: p_person_id IN igs_pe_person.person_id%type,
1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 1329: p_seq_number IN igs_ca_inst.sequence_number%type,

1325: (
1326: p_person_id IN igs_pe_person.person_id%type,
1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

Line 1531: p_cal_type IN igs_ca_inst.cal_type%type,

1527: FUNCTION validate_level
1528: (
1529: p_person_id IN igs_pe_person.person_id%type,
1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

Line 1532: p_seq_number IN igs_ca_inst.sequence_number%type,

1528: (
1529: p_person_id IN igs_pe_person.person_id%type,
1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1536: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,