DBA Data[Home] [Help]

APPS.IGS_AS_GEN_004 dependencies on FND_GLOBAL

Line 1880: suaai.last_updated_by = fnd_global.user_id,

1876: --
1877: UPDATE igs_as_su_atmpt_itm suaai
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,

Line 1881: suaai.last_update_login = fnd_global.login_id,

1877: UPDATE igs_as_su_atmpt_itm suaai
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE

Line 1882: suaai.request_id = fnd_global.conc_request_id,

1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id

Line 1883: suaai.program_id = fnd_global.conc_program_id,

1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id
1887: AND suaai.course_cd = p_course_cd

Line 1884: suaai.program_application_id = fnd_global.prog_appl_id,

1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id
1887: AND suaai.course_cd = p_course_cd
1888: AND suaai.uoo_id = p_uoo_id

Line 1895: suaaig.last_updated_by = fnd_global.user_id,

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
1897: WHERE suaaig.person_id = p_person_id
1898: AND suaaig.course_cd = p_course_cd
1899: AND suaaig.uoo_id = p_uoo_id

Line 1896: suaaig.last_update_login = fnd_global.login_id

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
1897: WHERE suaaig.person_id = p_person_id
1898: AND suaaig.course_cd = p_course_cd
1899: AND suaaig.uoo_id = p_uoo_id
1900: AND suaaig.unit_ass_item_group_id IS NOT NULL

Line 2041: suaai.last_updated_by = fnd_global.user_id,

2037: --
2038: UPDATE igs_as_su_atmpt_itm suaai
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,

Line 2042: suaai.last_update_login = fnd_global.login_id,

2038: UPDATE igs_as_su_atmpt_itm suaai
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,

Line 2043: suaai.request_id = fnd_global.conc_request_id,

2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,

Line 2044: suaai.program_id = fnd_global.conc_program_id,

2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2048: suaai.midterm_weight_qty = p_midterm_weight_qty,

Line 2045: suaai.program_application_id = fnd_global.prog_appl_id,

2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2048: suaai.midterm_weight_qty = p_midterm_weight_qty,
2049: suaai.final_mandatory_type_code = p_final_mandatory_type_code,

Line 2120: suaai.last_updated_by = fnd_global.user_id,

2116: -- Item already exists; so apply the changed assessment item definition if any
2117: --
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,

Line 2121: suaai.last_update_login = fnd_global.login_id,

2117: --
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,

Line 2122: suaai.request_id = fnd_global.conc_request_id,

2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,

Line 2123: suaai.program_id = fnd_global.conc_program_id,

2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2127: suaai.midterm_weight_qty = p_midterm_weight_qty,

Line 2124: suaai.program_application_id = fnd_global.prog_appl_id,

2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2127: suaai.midterm_weight_qty = p_midterm_weight_qty,
2128: suaai.final_mandatory_type_code = p_final_mandatory_type_code,