DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on FND_GLOBAL

Line 479: FND_GLOBAL.user_id,

475: email_content_type
476: ) VALUES (
477: l_deliv_rec.deliverable_id,
478: SYSDATE,
479: FND_GLOBAL.user_id,
480: SYSDATE,
481: FND_GLOBAL.user_id,
482: FND_GLOBAL.conc_login_id,
483: 1, -- object_version_number

Line 481: FND_GLOBAL.user_id,

477: l_deliv_rec.deliverable_id,
478: SYSDATE,
479: FND_GLOBAL.user_id,
480: SYSDATE,
481: FND_GLOBAL.user_id,
482: FND_GLOBAL.conc_login_id,
483: 1, -- object_version_number
484: l_deliv_rec.language_code,
485: l_deliv_rec.version,

Line 482: FND_GLOBAL.conc_login_id,

478: SYSDATE,
479: FND_GLOBAL.user_id,
480: SYSDATE,
481: FND_GLOBAL.user_id,
482: FND_GLOBAL.conc_login_id,
483: 1, -- object_version_number
484: l_deliv_rec.language_code,
485: l_deliv_rec.version,
486: l_deliv_rec.application_id,

Line 571: FND_GLOBAL.user_id,

567: SELECT
568: l_deliv_rec.deliverable_id,
569: l.language_code,
570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.conc_login_id,
575: USERENV('LANG'),

Line 573: FND_GLOBAL.user_id,

569: l.language_code,
570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.conc_login_id,
575: USERENV('LANG'),
576: l_deliv_rec.deliverable_name,
577: l_deliv_rec.description

Line 574: FND_GLOBAL.conc_login_id,

570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.conc_login_id,
575: USERENV('LANG'),
576: l_deliv_rec.deliverable_name,
577: l_deliv_rec.description
578: FROM fnd_languages l

Line 1430: l_user_id := FND_GLOBAL.User_Id;

1426:
1427: ----------------------- validate ----------------------
1428: --01/24/02 added for access check bug #2764852 mukumar start
1429:
1430: l_user_id := FND_GLOBAL.User_Id;
1431:
1432: IF (AMS_DEBUG_HIGH_ON) THEN
1433: AMS_Utility_PVT.debug_message(' CHECK ACCESS l_user_id is ' ||l_user_id );
1434: END IF;

Line 1677: l_jtf_amv_item_rec.owner_id := FND_GLOBAL.user_id;

1673: l_jtf_amv_item_rec.item_name :='DELV-'||substr(l_deliv_rec.deliverable_name,1,235);--l_deliv_rec.deliverable_name;
1674: l_jtf_amv_item_rec.application_id := 520;
1675: l_jtf_amv_item_rec.item_type := 'FILE_ITEM';
1676: l_jtf_amv_item_rec.content_type_id := 10;
1677: l_jtf_amv_item_rec.owner_id := FND_GLOBAL.user_id;
1678:
1679: JTF_AMV_ITEM_PUB.Create_Item
1680: (
1681: p_api_version => 1.0,

Line 1837: last_updated_by = FND_GLOBAL.user_id,

1833: END IF;
1834:
1835: UPDATE ams_deliverables_all_b
1836: SET last_update_date = SYSDATE,
1837: last_updated_by = FND_GLOBAL.user_id,
1838: last_update_login = FND_GLOBAL.conc_login_id,
1839: object_version_number = l_deliv_rec.object_version_number + 1,
1840: language_code = l_deliv_rec.language_code,
1841: version = l_deliv_rec.version,

Line 1838: last_update_login = FND_GLOBAL.conc_login_id,

1834:
1835: UPDATE ams_deliverables_all_b
1836: SET last_update_date = SYSDATE,
1837: last_updated_by = FND_GLOBAL.user_id,
1838: last_update_login = FND_GLOBAL.conc_login_id,
1839: object_version_number = l_deliv_rec.object_version_number + 1,
1840: language_code = l_deliv_rec.language_code,
1841: version = l_deliv_rec.version,
1842: application_id = l_deliv_rec.application_id,

Line 1933: last_updated_by = FND_GLOBAL.user_id,

1929: UPDATE ams_deliverables_all_tl
1930: SET deliverable_name = l_deliv_rec.deliverable_name,
1931: description = l_deliv_rec.description,
1932: last_update_date = SYSDATE,
1933: last_updated_by = FND_GLOBAL.user_id,
1934: last_update_login = FND_GLOBAL.conc_login_id,
1935: source_lang = USERENV('LANG')
1936: WHERE deliverable_id = l_deliv_rec.deliverable_id
1937: AND USERENV('LANG') IN (language, source_lang);

Line 1934: last_update_login = FND_GLOBAL.conc_login_id,

1930: SET deliverable_name = l_deliv_rec.deliverable_name,
1931: description = l_deliv_rec.description,
1932: last_update_date = SYSDATE,
1933: last_updated_by = FND_GLOBAL.user_id,
1934: last_update_login = FND_GLOBAL.conc_login_id,
1935: source_lang = USERENV('LANG')
1936: WHERE deliverable_id = l_deliv_rec.deliverable_id
1937: AND USERENV('LANG') IN (language, source_lang);
1938:

Line 2030: -- p_requester_userid => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),

2026: -- p_object_version_number => l_dummy,
2027: -- p_orig_stat_id => l_orig_stat_rec.user_status_id,
2028: -- p_new_stat_id => l_new_budget_stat_id, --- l_pending_budget_stat_id,
2029: -- p_reject_stat_id => l_reject_status_id,
2030: -- p_requester_userid => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),
2031: -- p_notes_from_requester => l_notes_from_requester,
2032: -- p_workflowprocess => l_workflowprocess,
2033: -- p_item_type => l_item_type
2034: -- );

Line 4212: l_att_rec.owner_user_id := FND_GLOBAL.user_id;

4208: l_att_rec.application_id := 530;
4209: ELSE
4210: l_att_rec.application_id := 520;
4211: END IF;
4212: l_att_rec.owner_user_id := FND_GLOBAL.user_id;
4213: l_att_rec.can_fulfill_electronic_flag := 'Y';
4214:
4215: jtf_amv_attachment_pub.create_act_attachment(
4216: p_api_version => l_api_version,

Line 4310: p_requester_userid => AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID),

4306: p_object_version_number => p_deliverable_rec.object_version_number,
4307: p_usedby_object_id => l_parent_deliv_rec.master_object_id,
4308: p_usedby_object_name => l_object_name,
4309: p_usedby_object_type_name => l_object_type_name,
4310: p_requester_userid => AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID),
4311: p_deliverable_userid => l_user_id,
4312: p_workflowprocess => l_workflowprocess,
4313: p_item_type => l_item_type
4314: );

Line 4339: p_requester_userid => AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID),

4335: p_object_version_number => p_deliverable_rec.object_version_number,
4336: p_usedby_object_id => l_master_object_id,
4337: p_usedby_object_name => l_object_name,
4338: p_usedby_object_type_name => l_object_type_name,
4339: p_requester_userid => AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID),
4340: p_deliverable_userid => l_user_id,
4341: p_workflowprocess => l_workflowprocess,
4342: p_item_type => l_item_type
4343: );

Line 4428: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);

4424: SELECT owner_user_id
4425: FROM ams_deliverables_all_b
4426: WHERE deliverable_id = deliv_id;
4427: l_owner_user_id NUMBER;
4428: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);
4429:
4430: BEGIN
4431:
4432: x_return_status := FND_API.g_ret_sts_success;