APPS.IGS_AS_GEN_004 dependencies on IGS_AS_SUA_AI_GROUP

Line 1507: igs_as_sua_ai_group sag

1503: suaai.*,
1504: sag.unit_ass_item_group_id,
1505: sag.us_ass_item_group_id
1506: FROM igs_as_su_atmpt_itm suaai,
1507: igs_as_sua_ai_group sag
1508: WHERE suaai.person_id = p_person_id
1509: AND suaai.course_cd = p_course_cd
1510: AND suaai.uoo_id = cp_uoo_id
1511: AND suaai.ass_id = cp_ass_id

Line 1746: FROM igs_as_sua_ai_group suaaig

1742: us_ass_item_group_id,
1743: unit_ass_item_group_id,
1744: group_name,
1745: rowid
1746: FROM igs_as_sua_ai_group suaaig
1747: WHERE suaaig.unit_ass_item_group_id = cp_group_id
1748: AND suaaig.person_id = cp_person_id
1749: AND suaaig.course_cd = cp_course_cd
1750: AND suaaig.uoo_id = cp_uoo_id

Line 1767: FROM igs_as_sua_ai_group suaaig

1763: us_ass_item_group_id,
1764: unit_ass_item_group_id,
1765: group_name,
1766: rowid
1767: FROM igs_as_sua_ai_group suaaig
1768: WHERE suaaig.us_ass_item_group_id = cp_group_id
1769: AND suaaig.person_id = cp_person_id
1770: AND suaaig.course_cd = cp_course_cd
1771: AND suaaig.uoo_id = cp_uoo_id

Line 1892: UPDATE igs_as_sua_ai_group suaaig

1888: AND suaai.uoo_id = p_uoo_id
1889: AND suaai.unit_ass_item_id IS NOT NULL
1890: AND suaai.logical_delete_dt IS NULL;
1891: --
1892: UPDATE igs_as_sua_ai_group suaaig
1893: SET suaaig.logical_delete_date = SYSDATE,
1894: suaaig.last_update_date = SYSDATE,
1895: suaaig.last_updated_by = fnd_global.user_id,
1896: suaaig.last_update_login = fnd_global.login_id

Line 1917: igs_as_sua_ai_group_pkg.insert_row (

1913: OPEN cur_usec_aig (p_group_id);
1914: FETCH cur_usec_aig INTO rec_usec_aig;
1915: CLOSE cur_usec_aig;
1916: l_rowid8 := NULL;
1917: igs_as_sua_ai_group_pkg.insert_row (
1918: x_rowid => l_rowid8,
1919: x_sua_ass_item_group_id => l_return_pk_id,
1920: x_person_id => p_person_id,
1921: x_course_cd => p_course_cd,

Line 1942: igs_as_sua_ai_group_pkg.update_row (

1938: --
1939: OPEN cur_usec_aig (p_group_id);
1940: FETCH cur_usec_aig INTO rec_usec_aig;
1941: CLOSE cur_usec_aig;
1942: igs_as_sua_ai_group_pkg.update_row (
1943: x_rowid => rec_suaig.rowid,
1944: x_sua_ass_item_group_id => rec_suaig.sua_ass_item_group_id,
1945: x_person_id => p_person_id,
1946: x_course_cd => p_course_cd,

Line 1977: igs_as_sua_ai_group_pkg.insert_row (

1973: OPEN cur_unit_aig (p_group_id);
1974: FETCH cur_unit_aig INTO rec_unit_aig;
1975: CLOSE cur_unit_aig;
1976: l_rowid8 := NULL;
1977: igs_as_sua_ai_group_pkg.insert_row (
1978: x_rowid => l_rowid8,
1979: x_sua_ass_item_group_id => l_return_pk_id,
1980: x_person_id => p_person_id,
1981: x_course_cd => p_course_cd,

Line 2003: igs_as_sua_ai_group_pkg.update_row (

1999: CLOSE cur_unit_aig;
2000: --
2001: -- Update the SUAI Group definition from latest UAIG definition
2002: --
2003: igs_as_sua_ai_group_pkg.update_row (
2004: x_rowid => rec_suaig.rowid,
2005: x_sua_ass_item_group_id => rec_suaig.sua_ass_item_group_id,
2006: x_person_id => p_person_id,
2007: x_course_cd => p_course_cd,