DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on FND_GLOBAL

Line 10: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

6: G_PROJECT_CODE CONSTANT VARCHAR2(100) :='PROJECT';
7: G_TASK_CODE CONSTANT VARCHAR2(100) :='TASK';
8: G_KEY_MEMBER_CODE CONSTANT VARCHAR2(100) :='KEY_MEMBER';
9: G_CLASS_CAT_CODE CONSTANT VARCHAR2(100) :='CLASS_CATEGORY';
10: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
11: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
12: -- anlee org role changes
13: G_KEY_MEMBER_CODE CONSTANT VARCHAR2(100) :='ORG_ROLE';
14: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/

Line 11: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;

7: G_TASK_CODE CONSTANT VARCHAR2(100) :='TASK';
8: G_KEY_MEMBER_CODE CONSTANT VARCHAR2(100) :='KEY_MEMBER';
9: G_CLASS_CAT_CODE CONSTANT VARCHAR2(100) :='CLASS_CATEGORY';
10: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
11: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
12: -- anlee org role changes
13: G_KEY_MEMBER_CODE CONSTANT VARCHAR2(100) :='ORG_ROLE';
14: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/
15:

Line 373: ,fnd_global.user_id

369: NULL,TRUNC(SYSDATE),
370: p_key_members(i).start_date)
371: ,p_key_members(i).end_date
372: ,sysdate
373: ,fnd_global.user_id
374: ,sysdate
375: ,fnd_global.user_id
376: ,fnd_global.login_id );
377: -- end OLD code before changes for ROLE BASED SECURITY

Line 375: ,fnd_global.user_id

371: ,p_key_members(i).end_date
372: ,sysdate
373: ,fnd_global.user_id
374: ,sysdate
375: ,fnd_global.user_id
376: ,fnd_global.login_id );
377: -- end OLD code before changes for ROLE BASED SECURITY
378: */
379: -- begin NEW code for ROLE BASED SECURITY

Line 376: ,fnd_global.login_id );

372: ,sysdate
373: ,fnd_global.user_id
374: ,sysdate
375: ,fnd_global.user_id
376: ,fnd_global.login_id );
377: -- end OLD code before changes for ROLE BASED SECURITY
378: */
379: -- begin NEW code for ROLE BASED SECURITY
380: /* Select

Line 759: ||'3:'||fnd_global.user_id

755: /* dbms_output.put_line('Trying to insert'); */
756:
757: /* dbms_output.put_line('1:'||p_class_categories(i).class_category
758: ||'2:'||p_class_categories(i).class_code
759: ||'3:'||fnd_global.user_id
760: ||'4:'||sysdate
761: ||'5:'||fnd_global.user_id
762: ||'6:'||fnd_global.login_id
763: ||'7:'||p_project_id

Line 761: ||'5:'||fnd_global.user_id

757: /* dbms_output.put_line('1:'||p_class_categories(i).class_category
758: ||'2:'||p_class_categories(i).class_code
759: ||'3:'||fnd_global.user_id
760: ||'4:'||sysdate
761: ||'5:'||fnd_global.user_id
762: ||'6:'||fnd_global.login_id
763: ||'7:'||p_project_id
764: ||'8:'||sysdate); */
765:

Line 762: ||'6:'||fnd_global.login_id

758: ||'2:'||p_class_categories(i).class_code
759: ||'3:'||fnd_global.user_id
760: ||'4:'||sysdate
761: ||'5:'||fnd_global.user_id
762: ||'6:'||fnd_global.login_id
763: ||'7:'||p_project_id
764: ||'8:'||sysdate); */
765:
766:

Line 882: ,fnd_global.user_id

878: ,l_code_percentage
879: ,p_project_id
880: ,'PA_PROJECTS'
881: ,sysdate
882: ,fnd_global.user_id
883: ,sysdate
884: ,fnd_global.user_id
885: ,fnd_global.login_id
886: ,0 /* Added for bug#2766416 */

Line 884: ,fnd_global.user_id

880: ,'PA_PROJECTS'
881: ,sysdate
882: ,fnd_global.user_id
883: ,sysdate
884: ,fnd_global.user_id
885: ,fnd_global.login_id
886: ,0 /* Added for bug#2766416 */
887: );
888:

Line 885: ,fnd_global.login_id

881: ,sysdate
882: ,fnd_global.user_id
883: ,sysdate
884: ,fnd_global.user_id
885: ,fnd_global.login_id
886: ,0 /* Added for bug#2766416 */
887: );
888:
889: EXCEPTION -- 5348726 : Exception block added for Bug#5294891

Line 2662: ,fnd_global.user_id

2658: ,substrb(rtrim(l_task_in_rec.pa_task_number),1,25) -- bug 6193314 . added substrb
2659: ,substrb(rtrim(l_task_in_rec.task_name),1,20) -- bug 6193314 . added substrb
2660: ,rtrim(l_task_in_rec.long_task_name)
2661: ,sysdate
2662: ,fnd_global.user_id
2663: ,sysdate
2664: ,fnd_global.user_id
2665: ,fnd_global.login_id
2666: ,l_wbs_level --wbs_level will be updated in the 2 round.

Line 2664: ,fnd_global.user_id

2660: ,rtrim(l_task_in_rec.long_task_name)
2661: ,sysdate
2662: ,fnd_global.user_id
2663: ,sysdate
2664: ,fnd_global.user_id
2665: ,fnd_global.login_id
2666: ,l_wbs_level --wbs_level will be updated in the 2 round.
2667: ,l_parent_TOP_TASK_ID -- top task id is updated in this round itself Bug 4378507
2668: --,l_task_id -- Commented for Bug 4378507 top task id will be updated in the 2 round.

Line 2665: ,fnd_global.login_id

2661: ,sysdate
2662: ,fnd_global.user_id
2663: ,sysdate
2664: ,fnd_global.user_id
2665: ,fnd_global.login_id
2666: ,l_wbs_level --wbs_level will be updated in the 2 round.
2667: ,l_parent_TOP_TASK_ID -- top task id is updated in this round itself Bug 4378507
2668: --,l_task_id -- Commented for Bug 4378507 top task id will be updated in the 2 round.
2669: ,null --parent task id, will be updated in the 2 round

Line 5664: l_resp_id := FND_GLOBAL.Resp_id;

5660:
5661: --pm_product_code is mandatory
5662:
5663: l_tasks_restructured_flag := 'N';
5664: l_resp_id := FND_GLOBAL.Resp_id;
5665: l_user_id := FND_GLOBAL.User_id;
5666: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_TASK';
5667: l_module_name := 'PA_PM_UPDATE_TASK';
5668:

Line 5665: l_user_id := FND_GLOBAL.User_id;

5661: --pm_product_code is mandatory
5662:
5663: l_tasks_restructured_flag := 'N';
5664: l_resp_id := FND_GLOBAL.Resp_id;
5665: l_user_id := FND_GLOBAL.User_id;
5666: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_TASK';
5667: l_module_name := 'PA_PM_UPDATE_TASK';
5668:
5669: -- As part of enforcing project security, which would determine

Line 6188: ,X_entered_by_user_id => FND_GLOBAL.USER_ID

6184: ,X_task_manager_person_id => l_task_rec.task_manager_person_id
6185: ,X_Service_type => l_task_rec.service_type_code
6186: ,X_task_start_date => l_task_rec.start_date
6187: ,X_task_end_date => l_task_rec.completion_date
6188: ,X_entered_by_user_id => FND_GLOBAL.USER_ID
6189: ,X_attribute_category => l_task_rec.attribute_category
6190: ,X_attribute1 => l_task_rec.attribute1
6191: ,X_attribute2 => l_task_rec.attribute2
6192: ,X_attribute3 => l_task_rec.attribute3

Line 9698: l_resp_id := FND_GLOBAL.Resp_id;

9694: END IF;
9695: END IF; --bug 2841158
9696:
9697:
9698: l_resp_id := FND_GLOBAL.Resp_id;
9699:
9700: -- Actions performed using the APIs would be subject to
9701: -- function security. If the responsibility does not allow
9702: -- such functions to be executed, the API should not proceed further

Line 10378: l_resp_id := FND_GLOBAL.Resp_id;

10374:
10375: -- Set API return status to success
10376:
10377: p_return_status := FND_API.G_RET_STS_SUCCESS;
10378: l_resp_id := FND_GLOBAL.Resp_id;
10379: l_user_id := FND_GLOBAL.User_id;
10380: --l_module_name := p_pm_product_code||'.'||'PA_PM_DELETE_PROJECT';
10381: l_module_name := 'PA_PM_DELETE_PROJECT';
10382:

Line 10379: l_user_id := FND_GLOBAL.User_id;

10375: -- Set API return status to success
10376:
10377: p_return_status := FND_API.G_RET_STS_SUCCESS;
10378: l_resp_id := FND_GLOBAL.Resp_id;
10379: l_user_id := FND_GLOBAL.User_id;
10380: --l_module_name := p_pm_product_code||'.'||'PA_PM_DELETE_PROJECT';
10381: l_module_name := 'PA_PM_DELETE_PROJECT';
10382:
10383: