DBA Data[Home] [Help]

APPS.PA_ACTIONS_PVT dependencies on FND_GLOBAL

Line 239: ,fnd_global.user_id

235: ,g_actions
236: ,p_name_tbl(i)
237: ,pa_tasks_s.currval
238: ,SYSDATE
239: ,fnd_global.user_id
240: ,SYSDATE
241: ,fnd_global.user_id
242: ,p_description_tbl(i)
243: ,decode(p_completed_flag_tbl(i),'Y','DLVR_COMPLETED','DLVR_IN_PROGRESS')

Line 241: ,fnd_global.user_id

237: ,pa_tasks_s.currval
238: ,SYSDATE
239: ,fnd_global.user_id
240: ,SYSDATE
241: ,fnd_global.user_id
242: ,p_description_tbl(i)
243: ,decode(p_completed_flag_tbl(i),'Y','DLVR_COMPLETED','DLVR_IN_PROGRESS')
244: ,p_function_code_tbl(i)
245: ,p_pm_source_code

Line 250: ,fnd_global.login_id

246: ,decode(p_calling_module, 'SELF_SERVICE', p_pm_source_reference , l_pm_source_reference_tbl(i)) -- added decode 3435905
247: ,p_manager_person_id_tbl(i)
248: ,p_carrying_out_organization_id
249: ,1
250: ,fnd_global.login_id
251: ,fnd_global.prog_appl_id
252: ,p_attribute_category_tbl(i)
253: ,p_attribute1_tbl(i)
254: ,p_attribute2_tbl(i)

Line 251: ,fnd_global.prog_appl_id

247: ,p_manager_person_id_tbl(i)
248: ,p_carrying_out_organization_id
249: ,1
250: ,fnd_global.login_id
251: ,fnd_global.prog_appl_id
252: ,p_attribute_category_tbl(i)
253: ,p_attribute1_tbl(i)
254: ,p_attribute2_tbl(i)
255: ,p_attribute3_tbl(i)

Line 308: ,fnd_global.user_id

304: ,l_proj_element_id_tbl(i)
305: ,g_actions
306: ,nvl(p_project_id,-99)
307: ,SYSDATE
308: ,fnd_global.user_id
309: ,SYSDATE
310: ,fnd_global.user_id
311: ,1
312: ,fnd_global.login_id

Line 310: ,fnd_global.user_id

306: ,nvl(p_project_id,-99)
307: ,SYSDATE
308: ,fnd_global.user_id
309: ,SYSDATE
310: ,fnd_global.user_id
311: ,1
312: ,fnd_global.login_id
313: ,nvl(p_project_id,-99)
314: ,'PA_PROJECTS'

Line 312: ,fnd_global.login_id

308: ,fnd_global.user_id
309: ,SYSDATE
310: ,fnd_global.user_id
311: ,1
312: ,fnd_global.login_id
313: ,nvl(p_project_id,-99)
314: ,'PA_PROJECTS'
315: )
316: RETURNING element_version_id

Line 350: ,fnd_global.user_id

346: ,l_element_version_id_tbl(i)
347: ,nvl(p_project_id,-99)
348: ,l_proj_element_id_tbl(i)
349: ,SYSDATE
350: ,fnd_global.user_id
351: ,SYSDATE
352: ,fnd_global.user_id
353: ,fnd_global.login_id
354: ,p_due_date_tbl(i)

Line 352: ,fnd_global.user_id

348: ,l_proj_element_id_tbl(i)
349: ,SYSDATE
350: ,fnd_global.user_id
351: ,SYSDATE
352: ,fnd_global.user_id
353: ,fnd_global.login_id
354: ,p_due_date_tbl(i)
355: ,p_completion_date_tbl(i)
356: ,1

Line 353: ,fnd_global.login_id

349: ,SYSDATE
350: ,fnd_global.user_id
351: ,SYSDATE
352: ,fnd_global.user_id
353: ,fnd_global.login_id
354: ,p_due_date_tbl(i)
355: ,p_completion_date_tbl(i)
356: ,1
357: ,nvl(p_project_id,-99)

Line 399: ,fnd_global.user_id

395: ,p_object_version_id
396: ,g_actions
397: ,l_element_version_id_tbl(i)
398: ,'A'
399: ,fnd_global.user_id
400: ,SYSDATE
401: ,fnd_global.user_id
402: ,SYSDATE
403: ,p_object_id

Line 401: ,fnd_global.user_id

397: ,l_element_version_id_tbl(i)
398: ,'A'
399: ,fnd_global.user_id
400: ,SYSDATE
401: ,fnd_global.user_id
402: ,SYSDATE
403: ,p_object_id
404: ,l_proj_element_id_tbl(i)
405: ,l_rel_subtype

Line 407: ,fnd_global.login_id

403: ,p_object_id
404: ,l_proj_element_id_tbl(i)
405: ,l_rel_subtype
406: ,1
407: ,fnd_global.login_id
408: ) ;
409: END IF ;
410:
411: IF p_debug_mode = 'Y' THEN --Added for bug 4945876

Line 584: ,last_updated_by = fnd_global.user_id

580: ,attribute14 = p_attribute14_tbl(i)
581: ,attribute15 = p_attribute15_tbl(i)
582: ,record_version_number = nvl(record_version_number,0) + 1
583: ,last_update_date = SYSDATE
584: ,last_updated_by = fnd_global.user_id
585: ,last_update_login = fnd_global.login_id
586: WHERE proj_element_id = p_proj_element_id_tbl(i) ;
587:
588:

Line 585: ,last_update_login = fnd_global.login_id

581: ,attribute15 = p_attribute15_tbl(i)
582: ,record_version_number = nvl(record_version_number,0) + 1
583: ,last_update_date = SYSDATE
584: ,last_updated_by = fnd_global.user_id
585: ,last_update_login = fnd_global.login_id
586: WHERE proj_element_id = p_proj_element_id_tbl(i) ;
587:
588:
589: -- Update attributes related to proj elem ver schedule table.

Line 601: ,last_updated_by = fnd_global.user_id

597: SET scheduled_finish_date = p_due_date_tbl(i)
598: ,actual_finish_date = p_completion_date_tbl(i)
599: ,record_version_number = nvl(record_version_number,0) + 1
600: ,last_update_date = SYSDATE
601: ,last_updated_by = fnd_global.user_id
602: ,last_update_login = fnd_global.login_id
603: WHERE element_version_id = p_element_version_id_tbl(i) ;
604:
605: -- 3941159 , added code to loop through actions and update event

Line 602: ,last_update_login = fnd_global.login_id

598: ,actual_finish_date = p_completion_date_tbl(i)
599: ,record_version_number = nvl(record_version_number,0) + 1
600: ,last_update_date = SYSDATE
601: ,last_updated_by = fnd_global.user_id
602: ,last_update_login = fnd_global.login_id
603: WHERE element_version_id = p_element_version_id_tbl(i) ;
604:
605: -- 3941159 , added code to loop through actions and update event
606: -- date for billing actions