DBA Data[Home] [Help]

APPS.IGS_AS_GEN_007 dependencies on FND_GLOBAL

Line 1575: suaai.last_updated_by = fnd_global.user_id,

1571: --
1572: UPDATE igs_as_su_atmpt_itm suaai
1573: SET suaai.logical_delete_dt = SYSDATE,
1574: suaai.last_update_date = SYSDATE,
1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,
1577: suaai.request_id = fnd_global.conc_request_id,
1578: suaai.program_id = fnd_global.conc_program_id,
1579: suaai.program_application_id = fnd_global.prog_appl_id,

Line 1576: suaai.last_update_login = fnd_global.login_id,

1572: UPDATE igs_as_su_atmpt_itm suaai
1573: SET suaai.logical_delete_dt = SYSDATE,
1574: suaai.last_update_date = SYSDATE,
1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,
1577: suaai.request_id = fnd_global.conc_request_id,
1578: suaai.program_id = fnd_global.conc_program_id,
1579: suaai.program_application_id = fnd_global.prog_appl_id,
1580: suaai.program_update_date = SYSDATE

Line 1577: suaai.request_id = fnd_global.conc_request_id,

1573: SET suaai.logical_delete_dt = SYSDATE,
1574: suaai.last_update_date = SYSDATE,
1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,
1577: suaai.request_id = fnd_global.conc_request_id,
1578: suaai.program_id = fnd_global.conc_program_id,
1579: suaai.program_application_id = fnd_global.prog_appl_id,
1580: suaai.program_update_date = SYSDATE
1581: WHERE suaai.uoo_id = NVL (v_uai_rec.uoo_id, suaai.uoo_id)

Line 1578: suaai.program_id = fnd_global.conc_program_id,

1574: suaai.last_update_date = SYSDATE,
1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,
1577: suaai.request_id = fnd_global.conc_request_id,
1578: suaai.program_id = fnd_global.conc_program_id,
1579: suaai.program_application_id = fnd_global.prog_appl_id,
1580: suaai.program_update_date = SYSDATE
1581: WHERE suaai.uoo_id = NVL (v_uai_rec.uoo_id, suaai.uoo_id)
1582: AND suaai.cal_type = v_uai_rec.cal_type

Line 1579: suaai.program_application_id = fnd_global.prog_appl_id,

1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,
1577: suaai.request_id = fnd_global.conc_request_id,
1578: suaai.program_id = fnd_global.conc_program_id,
1579: suaai.program_application_id = fnd_global.prog_appl_id,
1580: suaai.program_update_date = SYSDATE
1581: WHERE suaai.uoo_id = NVL (v_uai_rec.uoo_id, suaai.uoo_id)
1582: AND suaai.cal_type = v_uai_rec.cal_type
1583: AND suaai.ci_sequence_number = v_uai_rec.ci_sequence_number

Line 1674: last_updated_by = fnd_global.user_id,

1670: IF v_clear_action_dt THEN
1671: UPDATE igs_ps_unitass_item
1672: SET action_dt = NULL,
1673: last_update_date = SYSDATE,
1674: last_updated_by = fnd_global.user_id,
1675: last_update_login = fnd_global.login_id,
1676: request_id = fnd_global.conc_request_id,
1677: program_id = fnd_global.conc_program_id,
1678: program_application_id = fnd_global.prog_appl_id,

Line 1675: last_update_login = fnd_global.login_id,

1671: UPDATE igs_ps_unitass_item
1672: SET action_dt = NULL,
1673: last_update_date = SYSDATE,
1674: last_updated_by = fnd_global.user_id,
1675: last_update_login = fnd_global.login_id,
1676: request_id = fnd_global.conc_request_id,
1677: program_id = fnd_global.conc_program_id,
1678: program_application_id = fnd_global.prog_appl_id,
1679: program_update_date = SYSDATE

Line 1676: request_id = fnd_global.conc_request_id,

1672: SET action_dt = NULL,
1673: last_update_date = SYSDATE,
1674: last_updated_by = fnd_global.user_id,
1675: last_update_login = fnd_global.login_id,
1676: request_id = fnd_global.conc_request_id,
1677: program_id = fnd_global.conc_program_id,
1678: program_application_id = fnd_global.prog_appl_id,
1679: program_update_date = SYSDATE
1680: WHERE rowid = v_uai_rec.row_id;

Line 1677: program_id = fnd_global.conc_program_id,

1673: last_update_date = SYSDATE,
1674: last_updated_by = fnd_global.user_id,
1675: last_update_login = fnd_global.login_id,
1676: request_id = fnd_global.conc_request_id,
1677: program_id = fnd_global.conc_program_id,
1678: program_application_id = fnd_global.prog_appl_id,
1679: program_update_date = SYSDATE
1680: WHERE rowid = v_uai_rec.row_id;
1681: ELSE

Line 1678: program_application_id = fnd_global.prog_appl_id,

1674: last_updated_by = fnd_global.user_id,
1675: last_update_login = fnd_global.login_id,
1676: request_id = fnd_global.conc_request_id,
1677: program_id = fnd_global.conc_program_id,
1678: program_application_id = fnd_global.prog_appl_id,
1679: program_update_date = SYSDATE
1680: WHERE rowid = v_uai_rec.row_id;
1681: ELSE
1682: -- Rollback all processing associated with this item and log

Line 1699: last_updated_by = fnd_global.user_id,

1695: IF v_clear_action_dt THEN
1696: UPDATE igs_as_unitass_item
1697: SET action_dt = NULL,
1698: last_update_date = SYSDATE,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,
1701: request_id = fnd_global.conc_request_id,
1702: program_id = fnd_global.conc_program_id,
1703: program_application_id = fnd_global.prog_appl_id,

Line 1700: last_update_login = fnd_global.login_id,

1696: UPDATE igs_as_unitass_item
1697: SET action_dt = NULL,
1698: last_update_date = SYSDATE,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,
1701: request_id = fnd_global.conc_request_id,
1702: program_id = fnd_global.conc_program_id,
1703: program_application_id = fnd_global.prog_appl_id,
1704: program_update_date = SYSDATE

Line 1701: request_id = fnd_global.conc_request_id,

1697: SET action_dt = NULL,
1698: last_update_date = SYSDATE,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,
1701: request_id = fnd_global.conc_request_id,
1702: program_id = fnd_global.conc_program_id,
1703: program_application_id = fnd_global.prog_appl_id,
1704: program_update_date = SYSDATE
1705: WHERE rowid = v_uai_rec.row_id;

Line 1702: program_id = fnd_global.conc_program_id,

1698: last_update_date = SYSDATE,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,
1701: request_id = fnd_global.conc_request_id,
1702: program_id = fnd_global.conc_program_id,
1703: program_application_id = fnd_global.prog_appl_id,
1704: program_update_date = SYSDATE
1705: WHERE rowid = v_uai_rec.row_id;
1706: ELSE

Line 1703: program_application_id = fnd_global.prog_appl_id,

1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,
1701: request_id = fnd_global.conc_request_id,
1702: program_id = fnd_global.conc_program_id,
1703: program_application_id = fnd_global.prog_appl_id,
1704: program_update_date = SYSDATE
1705: WHERE rowid = v_uai_rec.row_id;
1706: ELSE
1707: -- Rollback all processing associated with this item and log