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_AU_GEN_001 dependencies on IGS_PS_OWN_HIST

Line 465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,

461: END;
462: END audp_get_cfosh_col;
463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )

Line 466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,

462: END audp_get_cfosh_col;
463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS

Line 467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,

463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:

Line 468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,

464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:
472: BEGIN -- audp_get_coh_col

Line 469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )

465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:
472: BEGIN -- audp_get_coh_col
473: -- get the oldest column value (after a given date) for the percentage

Line 477: v_column_value IGS_PS_OWN_HIST.percentage%TYPE := NULL;

473: -- get the oldest column value (after a given date) for the percentage
474: -- column for a given course_cd, version_number, org_unit_cd and
475: -- ou_start_dt
476: DECLARE
477: v_column_value IGS_PS_OWN_HIST.percentage%TYPE := NULL;
478: CURSOR c_coh IS
479: SELECT coh.percentage
480: FROM IGS_PS_OWN_HIST coh
481: WHERE coh.course_cd = p_course_cd AND

Line 480: FROM IGS_PS_OWN_HIST coh

476: DECLARE
477: v_column_value IGS_PS_OWN_HIST.percentage%TYPE := NULL;
478: CURSOR c_coh IS
479: SELECT coh.percentage
480: FROM IGS_PS_OWN_HIST coh
481: WHERE coh.course_cd = p_course_cd AND
482: coh.version_number = p_version_number AND
483: coh.org_unit_cd = p_org_unit_cd AND
484: coh.ou_start_dt = p_ou_start_dt AND