DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_PKG dependencies on FND_GLOBAL

Line 56: nvl(X_CREATED_BY, fnd_global.user_id) ,

52: x_implemented_by ,
53: x_implementation_comment ,
54: x_impacted_task_id,
55: nvl(X_CREATION_DATE, sysdate) ,
56: nvl(X_CREATED_BY, fnd_global.user_id) ,
57: nvl(X_LAST_UPDATE_DATE, sysdate),
58: nvl(X_LAST_UPDATED_BY, fnd_global.user_id),
59: nvl(X_LAST_UPDATE_LOGIN, fnd_global.login_id),
60: 1

Line 58: nvl(X_LAST_UPDATED_BY, fnd_global.user_id),

54: x_impacted_task_id,
55: nvl(X_CREATION_DATE, sysdate) ,
56: nvl(X_CREATED_BY, fnd_global.user_id) ,
57: nvl(X_LAST_UPDATE_DATE, sysdate),
58: nvl(X_LAST_UPDATED_BY, fnd_global.user_id),
59: nvl(X_LAST_UPDATE_LOGIN, fnd_global.login_id),
60: 1
61: );
62:

Line 59: nvl(X_LAST_UPDATE_LOGIN, fnd_global.login_id),

55: nvl(X_CREATION_DATE, sysdate) ,
56: nvl(X_CREATED_BY, fnd_global.user_id) ,
57: nvl(X_LAST_UPDATE_DATE, sysdate),
58: nvl(X_LAST_UPDATED_BY, fnd_global.user_id),
59: nvl(X_LAST_UPDATE_LOGIN, fnd_global.login_id),
60: 1
61: );
62:
63: open c;

Line 146: LAST_UPDATED_BY = fnd_global.user_id,

142: implemented_by = x_implemented_by,
143: implementation_comment = x_implementation_comment,
144: impacted_task_id = x_impacted_task_id,
145: LAST_UPDATE_DATE = sysdate,
146: LAST_UPDATED_BY = fnd_global.user_id,
147: last_update_login = fnd_global.login_id,
148: record_version_number = record_version_number +1
149: WHERE ci_impact_id = x_ci_impact_id
150: AND record_version_number = Nvl(x_record_version_number, record_version_number);

Line 147: last_update_login = fnd_global.login_id,

143: implementation_comment = x_implementation_comment,
144: impacted_task_id = x_impacted_task_id,
145: LAST_UPDATE_DATE = sysdate,
146: LAST_UPDATED_BY = fnd_global.user_id,
147: last_update_login = fnd_global.login_id,
148: record_version_number = record_version_number +1
149: WHERE ci_impact_id = x_ci_impact_id
150: AND record_version_number = Nvl(x_record_version_number, record_version_number);
151: if (sql%notfound) then