DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_OFR_OPT_ALL

Line 6943: p_program_length IN igs_ps_ofr_opt_all.program_length%TYPE,

6939: END get_ucasnum ;
6940:
6941: PROCEDURE get_new_prog_length
6942: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
6943: p_program_length IN igs_ps_ofr_opt_all.program_length%TYPE,
6944: p_program_length_measurement IN igs_ps_ofr_opt_all.program_length_measurement%TYPE,
6945: p_length OUT NOCOPY NUMBER,
6946: p_units OUT NOCOPY NUMBER)
6947: IS

Line 6944: p_program_length_measurement IN igs_ps_ofr_opt_all.program_length_measurement%TYPE,

6940:
6941: PROCEDURE get_new_prog_length
6942: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
6943: p_program_length IN igs_ps_ofr_opt_all.program_length%TYPE,
6944: p_program_length_measurement IN igs_ps_ofr_opt_all.program_length_measurement%TYPE,
6945: p_length OUT NOCOPY NUMBER,
6946: p_units OUT NOCOPY NUMBER)
6947: IS
6948: /***************************************************************

Line 6969: l_program_length_measurement igs_ps_ofr_opt_all.program_length_measurement%TYPE;

6965: l_days NUMBER(12,2);
6966: l_hours NUMBER(12,2);
6967: --Decimal is required to capture the decimal values in case whle conversion
6968: l_program_length NUMBER(12,2);
6969: l_program_length_measurement igs_ps_ofr_opt_all.program_length_measurement%TYPE;
6970: BEGIN
6971:
6972:
6973: -- Check for 'NOT_APPLICABLE'