DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PVT dependencies on FND_GLOBAL

Line 412: p_user_id => FND_GLOBAL.USER_ID

408: -- it creates relationship from structure_to_deliverable
409:
410: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW
411: (
412: p_user_id => FND_GLOBAL.USER_ID
413: ,p_object_type_from => 'PA_STRUCTURES'
414: ,p_object_id_from1 => p_parent_struct_ver_id
415: ,p_object_id_from2 => p_parent_structure_id
416: ,p_object_id_from3 => NULL

Line 457: p_user_id => FND_GLOBAL.USER_ID

453: -- it creates relationship from task_to_deliverable
454: /*
455: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW
456: (
457: p_user_id => FND_GLOBAL.USER_ID
458: ,p_object_type_from => 'PA_TASKS'
459: ,p_object_id_from1 => p_task_version_id
460: ,p_object_id_from2 => p_task_id
461: ,p_object_id_from3 => NULL

Line 2590: ,fnd_global.user_id

2586: ,decode(p_task_or_dlv,'PA_TASKS',p_task_or_dlv_ver_id,p_version_id_tbl(i))
2587: ,'PA_DELIVERABLES'
2588: ,decode(p_task_or_dlv,'PA_TASKS',p_version_id_tbl(i),p_task_or_dlv_ver_id)
2589: ,'A'
2590: ,fnd_global.user_id
2591: ,SYSDATE
2592: ,fnd_global.user_id
2593: ,SYSDATE
2594: ,decode(p_task_or_dlv,'PA_TASKS',p_task_or_dlv_elt_id,p_element_id_tbl(i))

Line 2592: ,fnd_global.user_id

2588: ,decode(p_task_or_dlv,'PA_TASKS',p_version_id_tbl(i),p_task_or_dlv_ver_id)
2589: ,'A'
2590: ,fnd_global.user_id
2591: ,SYSDATE
2592: ,fnd_global.user_id
2593: ,SYSDATE
2594: ,decode(p_task_or_dlv,'PA_TASKS',p_task_or_dlv_elt_id,p_element_id_tbl(i))
2595: ,decode(p_task_or_dlv,'PA_TASKS',p_element_id_tbl(i),p_task_or_dlv_elt_id)
2596: ,'TASK_TO_DELIVERABLE'

Line 2598: ,fnd_global.login_id

2594: ,decode(p_task_or_dlv,'PA_TASKS',p_task_or_dlv_elt_id,p_element_id_tbl(i))
2595: ,decode(p_task_or_dlv,'PA_TASKS',p_element_id_tbl(i),p_task_or_dlv_elt_id)
2596: ,'TASK_TO_DELIVERABLE'
2597: ,1
2598: ,fnd_global.login_id
2599: ) ;
2600:
2601:
2602: IF p_debug_mode = 'Y' THEN

Line 2848: ,fnd_global.user_id

2844: ,p_task_version_id
2845: ,'PA_DELIVERABLES'
2846: ,p_dlv_version_id
2847: ,'A'
2848: ,fnd_global.user_id
2849: ,SYSDATE
2850: ,fnd_global.user_id
2851: ,SYSDATE
2852: ,p_task_element_id

Line 2850: ,fnd_global.user_id

2846: ,p_dlv_version_id
2847: ,'A'
2848: ,fnd_global.user_id
2849: ,SYSDATE
2850: ,fnd_global.user_id
2851: ,SYSDATE
2852: ,p_task_element_id
2853: ,p_dlv_element_id
2854: ,decode(p_calling_context,'PA_TASKS','TASK_TO_DELIVERABLE','ASSIGNMENT_TO_DELIVERABLE')

Line 2856: ,fnd_global.login_id

2852: ,p_task_element_id
2853: ,p_dlv_element_id
2854: ,decode(p_calling_context,'PA_TASKS','TASK_TO_DELIVERABLE','ASSIGNMENT_TO_DELIVERABLE')
2855: ,1
2856: ,fnd_global.login_id
2857: ) ;
2858: END IF;
2859:
2860: IF p_debug_mode = 'Y' THEN

Line 3976: ,fnd_global.user_id

3972: ,ppe.element_number
3973: ,l_name
3974: ,ppe.status_code
3975: ,sysdate
3976: ,fnd_global.user_id
3977: ,sysdate
3978: ,fnd_global.user_id
3979: ,ppe.description
3980: ,ppe.pm_source_reference

Line 3978: ,fnd_global.user_id

3974: ,ppe.status_code
3975: ,sysdate
3976: ,fnd_global.user_id
3977: ,sysdate
3978: ,fnd_global.user_id
3979: ,ppe.description
3980: ,ppe.pm_source_reference
3981: ,ppe.pm_source_code
3982: ,ppe.manager_person_id

Line 3985: ,fnd_global.login_id

3981: ,ppe.pm_source_code
3982: ,ppe.manager_person_id
3983: ,ppe.carrying_out_organization_id
3984: ,1
3985: ,fnd_global.login_id
3986: ,l_parent_structure_id
3987: ,p_target_project_id
3988: ,'PA_PROJECTS'
3989: FROM pa_proj_elements ppe,

Line 4019: ,fnd_global.user_id

4015: ,'PA_STRUCTURES'
4016: ,p_target_project_id
4017: ,l_parent_structure_version_id
4018: ,SYSDATE
4019: ,fnd_global.user_id
4020: ,SYSDATE
4021: ,fnd_global.user_id
4022: ,1
4023: ,fnd_global.login_id

Line 4021: ,fnd_global.user_id

4017: ,l_parent_structure_version_id
4018: ,SYSDATE
4019: ,fnd_global.user_id
4020: ,SYSDATE
4021: ,fnd_global.user_id
4022: ,1
4023: ,fnd_global.login_id
4024: ,p_target_project_id,
4025: 'PA_PROJECTS'

Line 4023: ,fnd_global.login_id

4019: ,fnd_global.user_id
4020: ,SYSDATE
4021: ,fnd_global.user_id
4022: ,1
4023: ,fnd_global.login_id
4024: ,p_target_project_id,
4025: 'PA_PROJECTS'
4026: ) ;
4027:

Line 4044: ,fnd_global.user_id

4040: (pa_proj_structure_types_s.nextval
4041: ,l_parent_structure_id
4042: ,8
4043: ,SYSDATE
4044: ,fnd_global.user_id
4045: ,SYSDATE
4046: ,fnd_global.user_id
4047: ,fnd_global.login_id
4048: ,1

Line 4046: ,fnd_global.user_id

4042: ,8
4043: ,SYSDATE
4044: ,fnd_global.user_id
4045: ,SYSDATE
4046: ,fnd_global.user_id
4047: ,fnd_global.login_id
4048: ,1
4049: ) ;
4050:

Line 4047: ,fnd_global.login_id

4043: ,SYSDATE
4044: ,fnd_global.user_id
4045: ,SYSDATE
4046: ,fnd_global.user_id
4047: ,fnd_global.login_id
4048: ,1
4049: ) ;
4050:
4051: INSERT INTO PA_PROJ_ELEM_VER_STRUCTURE

Line 4081: ,fnd_global.user_id

4077: ,ver.current_flag
4078: ,ver.original_flag
4079: ,ver.latest_eff_published_flag
4080: ,sysdate
4081: ,fnd_global.user_id
4082: ,sysdate
4083: ,fnd_global.user_id
4084: ,1
4085: ,ppe.pm_source_code

Line 4083: ,fnd_global.user_id

4079: ,ver.latest_eff_published_flag
4080: ,sysdate
4081: ,fnd_global.user_id
4082: ,sysdate
4083: ,fnd_global.user_id
4084: ,1
4085: ,ppe.pm_source_code
4086: ,ppe.pm_source_reference
4087: ,p_target_project_id

Line 4304: ,fnd_global.user_id

4300: ,l_element_number_tbl(i)
4301: ,l_name_tbl(i)
4302: ,l_status_code_tbl(i) -- Bug#3515852 'DLVR_NOT_STARTED'
4303: ,sysdate
4304: ,fnd_global.user_id
4305: ,sysdate
4306: ,fnd_global.user_id
4307: ,l_description_tbl(i)
4308: ,l_pm_source_reference_tbl(i)

Line 4306: ,fnd_global.user_id

4302: ,l_status_code_tbl(i) -- Bug#3515852 'DLVR_NOT_STARTED'
4303: ,sysdate
4304: ,fnd_global.user_id
4305: ,sysdate
4306: ,fnd_global.user_id
4307: ,l_description_tbl(i)
4308: ,l_pm_source_reference_tbl(i)
4309: ,l_pm_source_code_tbl(i)
4310: ,l_manager_person_id_tbl(i)

Line 4313: ,fnd_global.login_id

4309: ,l_pm_source_code_tbl(i)
4310: ,l_manager_person_id_tbl(i)
4311: ,l_carrying_out_org_id_tbl(i)
4312: ,1
4313: ,fnd_global.login_id
4314: ,l_attribute_category_tbl(i)
4315: ,l_attribute1_tbl(i)
4316: ,l_attribute2_tbl(i)
4317: ,l_attribute3_tbl(i)

Line 4368: ,fnd_global.user_id

4364: ,'PA_DELIVERABLES'
4365: ,p_target_project_id
4366: ,l_parent_structure_version_id
4367: ,SYSDATE
4368: ,fnd_global.user_id
4369: ,SYSDATE
4370: ,fnd_global.user_id
4371: ,1
4372: ,fnd_global.login_id

Line 4370: ,fnd_global.user_id

4366: ,l_parent_structure_version_id
4367: ,SYSDATE
4368: ,fnd_global.user_id
4369: ,SYSDATE
4370: ,fnd_global.user_id
4371: ,1
4372: ,fnd_global.login_id
4373: ,p_target_project_id
4374: ,'PA_PROJECTS'

Line 4372: ,fnd_global.login_id

4368: ,fnd_global.user_id
4369: ,SYSDATE
4370: ,fnd_global.user_id
4371: ,1
4372: ,fnd_global.login_id
4373: ,p_target_project_id
4374: ,'PA_PROJECTS'
4375: )
4376: RETURNING element_version_id

Line 4410: ,fnd_global.user_id

4406: ,l_target_element_ver_id_tbl(i)
4407: ,p_target_project_id
4408: ,l_proj_element_id_tbl(i)
4409: ,SYSDATE
4410: ,fnd_global.user_id
4411: ,SYSDATE
4412: ,fnd_global.user_id
4413: ,fnd_global.login_id
4414: ,decode(p_calling_context,'COPY_PROJECT', -- 3493612

Line 4412: ,fnd_global.user_id

4408: ,l_proj_element_id_tbl(i)
4409: ,SYSDATE
4410: ,fnd_global.user_id
4411: ,SYSDATE
4412: ,fnd_global.user_id
4413: ,fnd_global.login_id
4414: ,decode(p_calling_context,'COPY_PROJECT', -- 3493612
4415: PA_DELIVERABLE_UTILS.GET_ADJUSTED_DATES
4416: (p_target_project_id

Line 4413: ,fnd_global.login_id

4409: ,SYSDATE
4410: ,fnd_global.user_id
4411: ,SYSDATE
4412: ,fnd_global.user_id
4413: ,fnd_global.login_id
4414: ,decode(p_calling_context,'COPY_PROJECT', -- 3493612
4415: PA_DELIVERABLE_UTILS.GET_ADJUSTED_DATES
4416: (p_target_project_id
4417: ,l_due_date_tbl(i)

Line 4459: ,fnd_global.user_id

4455: ,l_parent_structure_version_id
4456: ,'PA_DELIVERABLES'
4457: ,l_target_element_ver_id_tbl(i)
4458: ,'S'
4459: ,fnd_global.user_id
4460: ,SYSDATE
4461: ,fnd_global.user_id
4462: ,SYSDATE
4463: ,l_parent_structure_id

Line 4461: ,fnd_global.user_id

4457: ,l_target_element_ver_id_tbl(i)
4458: ,'S'
4459: ,fnd_global.user_id
4460: ,SYSDATE
4461: ,fnd_global.user_id
4462: ,SYSDATE
4463: ,l_parent_structure_id
4464: ,l_proj_element_id_tbl(i)
4465: ,'STRUCTURE_TO_DELIVERABLE'

Line 4467: ,fnd_global.login_id

4463: ,l_parent_structure_id
4464: ,l_proj_element_id_tbl(i)
4465: ,'STRUCTURE_TO_DELIVERABLE'
4466: ,1
4467: ,fnd_global.login_id
4468: ) ;
4469:
4470:
4471: IF nvl(l_proj_element_id_tbl.LAST,0)>0 THEN

Line 4497: ,fnd_global.user_id

4493: ,null
4494: ,'PA_DELIVERABLES'
4495: ,dlv2.element_version_id
4496: ,'A'
4497: ,fnd_global.user_id
4498: ,SYSDATE
4499: ,fnd_global.user_id
4500: ,SYSDATE
4501: ,tsk1.proj_element_id

Line 4499: ,fnd_global.user_id

4495: ,dlv2.element_version_id
4496: ,'A'
4497: ,fnd_global.user_id
4498: ,SYSDATE
4499: ,fnd_global.user_id
4500: ,SYSDATE
4501: ,tsk1.proj_element_id
4502: ,dlv1.proj_element_id
4503: ,'TASK_TO_DELIVERABLE'

Line 4505: ,fnd_global.login_id

4501: ,tsk1.proj_element_id
4502: ,dlv1.proj_element_id
4503: ,'TASK_TO_DELIVERABLE'
4504: ,1
4505: ,fnd_global.login_id
4506: FROM pa_proj_elements tsk1
4507: ,pa_proj_elements dlv1
4508: ,pa_proj_element_versions dlv2
4509: ,pa_object_relationships obj

Line 4552: ,fnd_global.user_id

4548: ,obj.object_id_from1
4549: ,'PA_DELIVERABLES'
4550: ,l_target_element_ver_id_tbl(i)
4551: ,'A'
4552: ,fnd_global.user_id
4553: ,SYSDATE
4554: ,fnd_global.user_id
4555: ,SYSDATE
4556: ,obj.object_id_from2

Line 4554: ,fnd_global.user_id

4550: ,l_target_element_ver_id_tbl(i)
4551: ,'A'
4552: ,fnd_global.user_id
4553: ,SYSDATE
4554: ,fnd_global.user_id
4555: ,SYSDATE
4556: ,obj.object_id_from2
4557: ,l_proj_element_id_tbl(i)
4558: ,'TASK_TO_DELIVERABLE'

Line 4560: ,fnd_global.login_id

4556: ,obj.object_id_from2
4557: ,l_proj_element_id_tbl(i)
4558: ,'TASK_TO_DELIVERABLE'
4559: ,1
4560: ,fnd_global.login_id
4561: FROM pa_object_relationships obj
4562: WHERE obj.object_id_to2 = p_dlv_element_id_tbl(i)
4563: AND obj.object_type_to = 'PA_DELIVERABLES'
4564: AND obj.object_type_from = 'PA_TASKS'

Line 4578: ,X_created_by => fnd_global.user_id

4574: X_from_entity_name => 'PA_DLVR_DOC_ATTACH'
4575: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4576: ,X_to_entity_name => 'PA_DLVR_DOC_ATTACH'
4577: ,X_to_pk1_value => l_target_element_ver_id_tbl(i)
4578: ,X_created_by => fnd_global.user_id
4579: ,X_last_update_login => fnd_global.login_id
4580: );
4581:
4582: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS

Line 4579: ,X_last_update_login => fnd_global.login_id

4575: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4576: ,X_to_entity_name => 'PA_DLVR_DOC_ATTACH'
4577: ,X_to_pk1_value => l_target_element_ver_id_tbl(i)
4578: ,X_created_by => fnd_global.user_id
4579: ,X_last_update_login => fnd_global.login_id
4580: );
4581:
4582: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS
4583: (

Line 4588: ,X_created_by => fnd_global.user_id

4584: X_from_entity_name => 'PA_DVLR_ATTACH'
4585: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4586: ,X_to_entity_name => 'PA_DVLR_ATTACH'
4587: ,X_to_pk1_value => l_target_element_ver_id_tbl(i)
4588: ,X_created_by => fnd_global.user_id
4589: ,X_last_update_login => fnd_global.login_id
4590: );
4591:
4592: END IF ;

Line 4589: ,X_last_update_login => fnd_global.login_id

4585: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4586: ,X_to_entity_name => 'PA_DVLR_ATTACH'
4587: ,X_to_pk1_value => l_target_element_ver_id_tbl(i)
4588: ,X_created_by => fnd_global.user_id
4589: ,X_last_update_login => fnd_global.login_id
4590: );
4591:
4592: END IF ;
4593: