DBA Data[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_GE_GEN_001

Line 1759: IGS_GE_GEN_001.genp_clc_week_end_dt(uai.due_dt) uai_week_ending_dt

1755: CURSOR c_uai(
1756: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
1757: SELECT uai.ass_id,
1758: uai.due_dt,
1759: IGS_GE_GEN_001.genp_clc_week_end_dt(uai.due_dt) uai_week_ending_dt
1760: FROM IGS_PS_UNIT_OFR_OPT uoo,
1761: -- IGS_AS_UNIT_CLASS uc,
1762: IGS_AS_UNITASS_ITEM uai,
1763: IGS_AS_ASSESSMNT_ITM ai,

Line 1850: IGS_GE_GEN_001.genp_clc_week_end_dt(c_suaai_rec.override_due_dt);

1846: -- Determine if any extensions apply and the length of the extension.
1847: -- Increment the appropriate counter.
1848: IF c_suaai_rec.override_due_dt IS NOT NULL THEN
1849: v_override_week_ending_dt :=
1850: IGS_GE_GEN_001.genp_clc_week_end_dt(c_suaai_rec.override_due_dt);
1851: IF (c_suaai_rec.override_due_dt > c_uai_rec.uai_week_ending_dt) THEN
1852: IF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1853: c_suaai_rec.override_due_dt, 1) > 0 THEN
1854: v_one_week_extension_count := v_one_week_extension_count + 1;

Line 1891: := IGS_GE_GEN_001.genp_clc_week_end_dt(c_suaai_rec.completion_dt);

1887: END IF;
1888: -- Determine if the item has been received from the student.
1889: IF c_suaai_rec.completion_dt IS NOT NULL THEN
1890: v_completion_week_ending_dt
1891: := IGS_GE_GEN_001.genp_clc_week_end_dt(c_suaai_rec.completion_dt);
1892: -- If the date received is the same week due then increment the counter.
1893: IF c_uai_rec.uai_week_ending_dt = v_completion_week_ending_dt THEN
1894: v_received_count := v_received_count + 1;
1895: ELSE