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_WRKFLOW_PKG dependencies on IGS_GE_NUMBER

Line 31: l_acad_cal_seq_num number := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));

27: l_count number := 0;
28:
29: l_adm_cal varchar2(10) := RTRIM(SUBSTR(p_calendar_details, 23, 10));
30: l_acad_cal varchar2(10):= RTRIM(SUBSTR(p_calendar_details,1,10));
31: l_acad_cal_seq_num number := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
32: l_adm_cal_seq_num number :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
33: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
34: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
35: l_appl_type varchar2(30) := RTRIM(SUBSTR(p_appl_type, 1, 30));

Line 32: l_adm_cal_seq_num number :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));

28:
29: l_adm_cal varchar2(10) := RTRIM(SUBSTR(p_calendar_details, 23, 10));
30: l_acad_cal varchar2(10):= RTRIM(SUBSTR(p_calendar_details,1,10));
31: l_acad_cal_seq_num number := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
32: l_adm_cal_seq_num number :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
33: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
34: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
35: l_appl_type varchar2(30) := RTRIM(SUBSTR(p_appl_type, 1, 30));
36:

Line 1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));

1128: l_count number := 0;
1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:

Line 1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));

1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:
1137: l_alt_code_acad igs_ca_inst.alternate_code%TYPE;

Line 1312: lv_person_id := IGS_GE_NUMBER.TO_CANN(l_person_id);

1308:
1309: IF c_per_adm_req%FOUND THEN
1310:
1311: l_count := l_count+1;
1312: lv_person_id := IGS_GE_NUMBER.TO_CANN(l_person_id);
1313:
1314: -- The following code should be uncommented once the TCA HZ.J patch is applied
1315: /* Wf_Directory.GetRoleName('HZ_PARTY', lv_person_id, l_person_name, l_display_name);
1316:

Line 1411: lv_person_id := IGS_GE_NUMBER.TO_CANN(l_person_id);

1407: IF c_per_post_adm_req%FOUND THEN
1408:
1409: l_count := l_count+1;
1410:
1411: lv_person_id := IGS_GE_NUMBER.TO_CANN(l_person_id);
1412:
1413: -- The following code should be uncommented once the TCA HZ.J patch is applied
1414: /* Wf_Directory.GetRoleName('HZ_PARTY', l_person_id, l_person_name, l_display_name);
1415: