APPS.IGS_AS_GEN_006 dependencies on IGS_AS_GEN_001

Line 1852: IF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,

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;
1855: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1856: c_suaai_rec.override_due_dt, 2) > 0 THEN

Line 1855: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_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;
1855: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1856: c_suaai_rec.override_due_dt, 2) > 0 THEN
1857: v_two_week_extension_count := v_two_week_extension_count + 1;
1858: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1859: c_suaai_rec.override_due_dt, 3) > 0 THEN

Line 1858: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,

1854: v_one_week_extension_count := v_one_week_extension_count + 1;
1855: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1856: c_suaai_rec.override_due_dt, 2) > 0 THEN
1857: v_two_week_extension_count := v_two_week_extension_count + 1;
1858: ELSIF IGS_AS_GEN_001.assp_clc_week_extnsn(c_uai_rec.uai_week_ending_dt,
1859: c_suaai_rec.override_due_dt, 3) > 0 THEN
1860: v_three_week_plus_extnsn_count := v_three_week_plus_extnsn_count + 1;
1861: END IF;
1862: -- Insert into SI_AS_ASSR1020 table for the actual week ending date