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 2492: ,fnd_global.user_id

2488: ,substrb(rtrim(l_task_in_rec.pa_task_number),1,25) -- bug 6193314 . added substrb
2489: ,substrb(rtrim(l_task_in_rec.task_name),1,20) -- bug 6193314 . added substrb
2490: ,rtrim(l_task_in_rec.long_task_name)
2491: ,sysdate
2492: ,fnd_global.user_id
2493: ,sysdate
2494: ,fnd_global.user_id
2495: ,fnd_global.login_id
2496: ,l_wbs_level --wbs_level will be updated in the 2 round.

Line 2494: ,fnd_global.user_id

2490: ,rtrim(l_task_in_rec.long_task_name)
2491: ,sysdate
2492: ,fnd_global.user_id
2493: ,sysdate
2494: ,fnd_global.user_id
2495: ,fnd_global.login_id
2496: ,l_wbs_level --wbs_level will be updated in the 2 round.
2497: ,l_parent_TOP_TASK_ID -- top task id is updated in this round itself Bug 4378507
2498: --,l_task_id -- Commented for Bug 4378507 top task id will be updated in the 2 round.

Line 2495: ,fnd_global.login_id

2491: ,sysdate
2492: ,fnd_global.user_id
2493: ,sysdate
2494: ,fnd_global.user_id
2495: ,fnd_global.login_id
2496: ,l_wbs_level --wbs_level will be updated in the 2 round.
2497: ,l_parent_TOP_TASK_ID -- top task id is updated in this round itself Bug 4378507
2498: --,l_task_id -- Commented for Bug 4378507 top task id will be updated in the 2 round.
2499: ,null --parent task id, will be updated in the 2 round

Line 5462: l_resp_id := FND_GLOBAL.Resp_id;

5458:
5459: --pm_product_code is mandatory
5460:
5461: l_tasks_restructured_flag := 'N';
5462: l_resp_id := FND_GLOBAL.Resp_id;
5463: l_user_id := FND_GLOBAL.User_id;
5464: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_TASK';
5465: l_module_name := 'PA_PM_UPDATE_TASK';
5466:

Line 5463: l_user_id := FND_GLOBAL.User_id;

5459: --pm_product_code is mandatory
5460:
5461: l_tasks_restructured_flag := 'N';
5462: l_resp_id := FND_GLOBAL.Resp_id;
5463: l_user_id := FND_GLOBAL.User_id;
5464: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_TASK';
5465: l_module_name := 'PA_PM_UPDATE_TASK';
5466:
5467: -- As part of enforcing project security, which would determine

Line 5896: ,X_entered_by_user_id => FND_GLOBAL.USER_ID

5892: ,X_task_manager_person_id => l_task_rec.task_manager_person_id
5893: ,X_Service_type => l_task_rec.service_type_code
5894: ,X_task_start_date => l_task_rec.start_date
5895: ,X_task_end_date => l_task_rec.completion_date
5896: ,X_entered_by_user_id => FND_GLOBAL.USER_ID
5897: ,X_attribute_category => l_task_rec.attribute_category
5898: ,X_attribute1 => l_task_rec.attribute1
5899: ,X_attribute2 => l_task_rec.attribute2
5900: ,X_attribute3 => l_task_rec.attribute3

Line 9358: l_resp_id := FND_GLOBAL.Resp_id;

9354: END IF;
9355: END IF; --bug 2841158
9356:
9357:
9358: l_resp_id := FND_GLOBAL.Resp_id;
9359:
9360: -- Actions performed using the APIs would be subject to
9361: -- function security. If the responsibility does not allow
9362: -- such functions to be executed, the API should not proceed further

Line 10038: l_resp_id := FND_GLOBAL.Resp_id;

10034:
10035: -- Set API return status to success
10036:
10037: p_return_status := FND_API.G_RET_STS_SUCCESS;
10038: l_resp_id := FND_GLOBAL.Resp_id;
10039: l_user_id := FND_GLOBAL.User_id;
10040: --l_module_name := p_pm_product_code||'.'||'PA_PM_DELETE_PROJECT';
10041: l_module_name := 'PA_PM_DELETE_PROJECT';
10042:

Line 10039: l_user_id := FND_GLOBAL.User_id;

10035: -- Set API return status to success
10036:
10037: p_return_status := FND_API.G_RET_STS_SUCCESS;
10038: l_resp_id := FND_GLOBAL.Resp_id;
10039: l_user_id := FND_GLOBAL.User_id;
10040: --l_module_name := p_pm_product_code||'.'||'PA_PM_DELETE_PROJECT';
10041: l_module_name := 'PA_PM_DELETE_PROJECT';
10042:
10043: