DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_API dependencies on FND_GLOBAL

Line 79: last_updated_by = fnd_global.user_id,

75: --added by schowdhu to fix 7205132
76:
77: update per_pay_proposals
78: set last_change_date = l_last_change_date,
79: last_updated_by = fnd_global.user_id,
80: last_update_login = fnd_global.login_id
81: where rowid=l_row_id;
82:
83: -- commented out by schowdhu to fix 7205132

Line 80: last_update_login = fnd_global.login_id

76:
77: update per_pay_proposals
78: set last_change_date = l_last_change_date,
79: last_updated_by = fnd_global.user_id,
80: last_update_login = fnd_global.login_id
81: where rowid=l_row_id;
82:
83: -- commented out by schowdhu to fix 7205132
84: /*

Line 146: last_updated_by = fnd_global.user_id,

142: update per_pay_proposals
143: set date_to = p_date_to,
144: -- added by vkodedal fix for 6831216
145: last_update_date = sysdate,
146: last_updated_by = fnd_global.user_id,
147: last_update_login = fnd_global.login_id
148: -- end of fix
149: where assignment_id = p_assignment_id
150: and pay_proposal_id = l_pay_proposal_id;

Line 147: last_update_login = fnd_global.login_id

143: set date_to = p_date_to,
144: -- added by vkodedal fix for 6831216
145: last_update_date = sysdate,
146: last_updated_by = fnd_global.user_id,
147: last_update_login = fnd_global.login_id
148: -- end of fix
149: where assignment_id = p_assignment_id
150: and pay_proposal_id = l_pay_proposal_id;
151: hr_utility.set_location('Updated successfuly:',85);

Line 216: last_updated_by = fnd_global.user_id,

212: update per_pay_proposals
213: set date_to = p_date_to,
214: -- added by vkodedal fix for 6831216
215: last_update_date = sysdate,
216: last_updated_by = fnd_global.user_id,
217: last_update_login = fnd_global.login_id
218: -- end of fix
219: where assignment_id = p_assignment_id
220: and pay_proposal_id = l_pay_proposal_id;

Line 217: last_update_login = fnd_global.login_id

213: set date_to = p_date_to,
214: -- added by vkodedal fix for 6831216
215: last_update_date = sysdate,
216: last_updated_by = fnd_global.user_id,
217: last_update_login = fnd_global.login_id
218: -- end of fix
219: where assignment_id = p_assignment_id
220: and pay_proposal_id = l_pay_proposal_id;
221: hr_utility.set_location('Updated successfuly:',85);

Line 304: last_updated_by = fnd_global.user_id,

300: update per_pay_proposals
301: set date_to = p_date_to,
302: -- added by vkodedal fix for 6831216
303: last_update_date = sysdate,
304: last_updated_by = fnd_global.user_id,
305: last_update_login = fnd_global.login_id
306: -- end of fix
307: where assignment_id = p_assignment_id
308: and pay_proposal_id = l_pay_proposal_id;

Line 305: last_update_login = fnd_global.login_id

301: set date_to = p_date_to,
302: -- added by vkodedal fix for 6831216
303: last_update_date = sysdate,
304: last_updated_by = fnd_global.user_id,
305: last_update_login = fnd_global.login_id
306: -- end of fix
307: where assignment_id = p_assignment_id
308: and pay_proposal_id = l_pay_proposal_id;
309: hr_utility.set_location('Updated successfuly:',85);

Line 394: last_updated_by = fnd_global.user_id,

390: update per_pay_proposals
391: set date_to = l_date_to,
392: -- added by vkodedal fix for 6831216
393: last_update_date = sysdate,
394: last_updated_by = fnd_global.user_id,
395: last_update_login = fnd_global.login_id
396: -- end of fix
397: where assignment_id = l_assignment_id
398: and (l_deleted_proposal_date -1) between change_date and date_to

Line 395: last_update_login = fnd_global.login_id

391: set date_to = l_date_to,
392: -- added by vkodedal fix for 6831216
393: last_update_date = sysdate,
394: last_updated_by = fnd_global.user_id,
395: last_update_login = fnd_global.login_id
396: -- end of fix
397: where assignment_id = l_assignment_id
398: and (l_deleted_proposal_date -1) between change_date and date_to
399: and approved = 'N';

Line 407: last_updated_by = fnd_global.user_id,

403:
404: update per_pay_proposals
405: set date_to = l_date_to,
406: last_update_date = sysdate,
407: last_updated_by = fnd_global.user_id,
408: last_update_login = fnd_global.login_id
409: where assignment_id = l_assignment_id
410: and approved = 'Y'
411: and change_date = ( select max(change_date)

Line 408: last_update_login = fnd_global.login_id

404: update per_pay_proposals
405: set date_to = l_date_to,
406: last_update_date = sysdate,
407: last_updated_by = fnd_global.user_id,
408: last_update_login = fnd_global.login_id
409: where assignment_id = l_assignment_id
410: and approved = 'Y'
411: and change_date = ( select max(change_date)
412: from per_pay_proposals