eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on FND_GLOBAL

Line 6402: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6398: l_src_fin_version_id NUMBER(15);
6399: l_versioning_enabled VARCHAR2(1);
6400: dest_latest_eff_pub_flag VARCHAR2(1);
6401: dest_current_flag VARCHAR2(1);
6402: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6403: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6404: BEGIN
6405:
6406: x_msg_count := 0;

Line 6403: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6399: l_versioning_enabled VARCHAR2(1);
6400: dest_latest_eff_pub_flag VARCHAR2(1);
6401: dest_current_flag VARCHAR2(1);
6402: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6403: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6404: BEGIN
6405:
6406: x_msg_count := 0;
6407: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6902: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6898: l_debug_level4 CONSTANT NUMBER := 4;
6899: l_debug_level5 CONSTANT NUMBER := 5;
6900:
6901: l_src_fin_version_id NUMBER(15);
6902: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6903: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6904: l_delta NUMBER;
6905: l_src_sch_st_date DATE;
6906:

Line 6903: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6899: l_debug_level5 CONSTANT NUMBER := 5;
6900:
6901: l_src_fin_version_id NUMBER(15);
6902: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6903: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6904: l_delta NUMBER;
6905: l_src_sch_st_date DATE;
6906:
6907: BEGIN

Line 7765: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7761:
7762: l_suffix VARCHAR2(250);
7763: l_append VARCHAR2(10) := ': ';
7764: l_name VARCHAR2(250);
7765: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7766: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7767: l_dest_wp_structure_id NUMBER;
7768: l_src_wp_structure_id NUMBER;
7769: l_dest_fn_structure_id NUMBER;

Line 7766: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7762: l_suffix VARCHAR2(250);
7763: l_append VARCHAR2(10) := ': ';
7764: l_name VARCHAR2(250);
7765: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7766: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7767: l_dest_wp_structure_id NUMBER;
7768: l_src_wp_structure_id NUMBER;
7769: l_dest_fn_structure_id NUMBER;
7770: l_src_fn_structure_id NUMBER;

Line 8419: OPEN cur_get_person_id(FND_GLOBAL.USER_ID);

8415: FETCH cur_get_dest_structure_id INTO l_dest_fn_structure_id, l_src_fn_structure_id;
8416: CLOSE cur_get_dest_structure_id;
8417:
8418: --Get the publish person id
8419: OPEN cur_get_person_id(FND_GLOBAL.USER_ID);
8420: FETCH cur_get_person_id INTO l_publish_person_id;
8421: IF cur_get_person_id%NOTFOUND THEN
8422: l_publish_person_id := NULL;
8423: END IF;

Line 8693: pa_debug.write(G_PKG_NAME, 'fnd_global.employee_id='||fnd_global.employee_id, l_debug_level3);

8689: IF l_debug_mode = 'Y' THEN
8690: pa_debug.write(G_PKG_NAME, 'l_wp_approval_reqd_flag='||l_wp_approval_reqd_flag, l_debug_level3);
8691: pa_debug.write(G_PKG_NAME, 'l_wp_auto_publish_flag='||l_wp_auto_publish_flag, l_debug_level3);
8692: pa_debug.write(G_PKG_NAME, 'l_wp_approver_source_id='||l_wp_approver_source_id, l_debug_level3);
8693: pa_debug.write(G_PKG_NAME, 'fnd_global.employee_id='||fnd_global.employee_id, l_debug_level3);
8694: END IF;
8695:
8696: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8697: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN

Line 8697: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN

8693: pa_debug.write(G_PKG_NAME, 'fnd_global.employee_id='||fnd_global.employee_id, l_debug_level3);
8694: END IF;
8695:
8696: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8697: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN
8698: -- 3916763 : Use fnd_global.employee_id instead of fnd_global.party_id
8699: l_submit_wf_required := 'Y';
8700: l_dest_status_code := 'STRUCTURE_WORKING';
8701: l_dest_latest_eff_pub_flag := 'N';

Line 8698: -- 3916763 : Use fnd_global.employee_id instead of fnd_global.party_id

8694: END IF;
8695:
8696: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8697: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN
8698: -- 3916763 : Use fnd_global.employee_id instead of fnd_global.party_id
8699: l_submit_wf_required := 'Y';
8700: l_dest_status_code := 'STRUCTURE_WORKING';
8701: l_dest_latest_eff_pub_flag := 'N';
8702: IF l_current_working_selected = nvl(l_puc_version_id,-88) OR 'Y' = l_shared OR 'Y' = p_dest_template_flag THEN

Line 10118: FND_GLOBAL.USER_ID,

10114: null, null, null, null,
10115: 'PA_TASKS',
10116: rec_copied_tasks.dest_ppe_id,
10117: null, null, null, null,
10118: FND_GLOBAL.USER_ID,
10119: FND_GLOBAL.LOGIN_ID,
10120: 275, null, null
10121: );
10122: END LOOP;

Line 10119: FND_GLOBAL.LOGIN_ID,

10115: 'PA_TASKS',
10116: rec_copied_tasks.dest_ppe_id,
10117: null, null, null, null,
10118: FND_GLOBAL.USER_ID,
10119: FND_GLOBAL.LOGIN_ID,
10120: 275, null, null
10121: );
10122: END LOOP;
10123: END IF;

Line 10134: FND_GLOBAL.USER_ID,

10130: null, null, null, null,
10131: 'PA_TASKS',
10132: rec_copied_tasks.dest_ppe_id,
10133: null, null, null, null,
10134: FND_GLOBAL.USER_ID,
10135: FND_GLOBAL.LOGIN_ID,
10136: 275, null, null
10137: );
10138: END LOOP;

Line 10135: FND_GLOBAL.LOGIN_ID,

10131: 'PA_TASKS',
10132: rec_copied_tasks.dest_ppe_id,
10133: null, null, null, null,
10134: FND_GLOBAL.USER_ID,
10135: FND_GLOBAL.LOGIN_ID,
10136: 275, null, null
10137: );
10138: END LOOP;
10139: END IF;

Line 10150: FND_GLOBAL.USER_ID,

10146: null, null, null, null,
10147: 'PA_TASKS',
10148: rec_copied_tasks.dest_ppe_id,
10149: null, null, null, null,
10150: FND_GLOBAL.USER_ID,
10151: FND_GLOBAL.LOGIN_ID,
10152: 275, null, null
10153: );
10154: END LOOP;

Line 10151: FND_GLOBAL.LOGIN_ID,

10147: 'PA_TASKS',
10148: rec_copied_tasks.dest_ppe_id,
10149: null, null, null, null,
10150: FND_GLOBAL.USER_ID,
10151: FND_GLOBAL.LOGIN_ID,
10152: 275, null, null
10153: );
10154: END LOOP;
10155: END IF;

Line 10377: Pa_Debug.WRITE(G_PKG_NAME, 'fnd_global.resp_id='||fnd_global.resp_id, l_debug_level3);

10373: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_required='||l_submit_wf_required, l_debug_level3);
10374: Pa_Debug.WRITE(G_PKG_NAME, 'p_dest_project_id='||p_dest_project_id, l_debug_level3);
10375: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_str_id='||l_submit_wf_str_id, l_debug_level3);
10376: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_str_version_id='||l_submit_wf_str_version_id, l_debug_level3);
10377: Pa_Debug.WRITE(G_PKG_NAME, 'fnd_global.resp_id='||fnd_global.resp_id, l_debug_level3);
10378: END IF;
10379:
10380: IF l_submit_wf_required = 'Y' AND l_submit_wf_str_version_id IS NOT NULL THEN
10381: IF l_debug_mode = 'Y' THEN

Line 10391: ,p_responsibility_id => fnd_global.resp_id

10387: p_calling_module => p_calling_module
10388: ,p_project_id => p_dest_project_id
10389: ,p_structure_id => l_submit_wf_str_id
10390: ,p_structure_version_id => l_submit_wf_str_version_id
10391: ,p_responsibility_id => fnd_global.resp_id
10392: ,x_return_status => x_return_status
10393: ,x_msg_count => x_msg_count
10394: ,x_msg_data => x_msg_data
10395: );

Line 10609: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10605:
10606: /* Code Addition ends for bug 3737444 */
10607:
10608: l_wp_attr_rec get_wp_attr%ROWTYPE;
10609: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10610: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10611:
10612: CURSOR l_get_structure_attr_csr
10613: IS

Line 10610: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10606: /* Code Addition ends for bug 3737444 */
10607:
10608: l_wp_attr_rec get_wp_attr%ROWTYPE;
10609: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10610: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10611:
10612: CURSOR l_get_structure_attr_csr
10613: IS
10614: /* SELECT *

Line 10858: open get_person_id(FND_GLOBAL.USER_ID);

10854: -- Bug 3717026 End
10855: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_src_project_id );
10856:
10857: --bug 2838547
10858: open get_person_id(FND_GLOBAL.USER_ID);
10859: fetch get_person_id into l_publish_person_id;
10860: IF get_person_id%NOTFOUND then
10861: l_publish_person_id := NULL;
10862: END IF;

Line 11268: FND_GLOBAL.USER_ID,

11264: null, null, null, null,
11265: 'PA_TASKS',
11266: c_atch.new_task_id,
11267: null, null, null, null,
11268: FND_GLOBAL.USER_ID,
11269: FND_GLOBAL.LOGIN_ID,
11270: 275, null, null);
11271:
11272: END LOOP ;

Line 11269: FND_GLOBAL.LOGIN_ID,

11265: 'PA_TASKS',
11266: c_atch.new_task_id,
11267: null, null, null, null,
11268: FND_GLOBAL.USER_ID,
11269: FND_GLOBAL.LOGIN_ID,
11270: 275, null, null);
11271:
11272: END LOOP ;
11273: CLOSE c_attach_tasks;

Line 13990: p_responsibility_id => FND_GLOBAL.Resp_id,

13986:
13987: --IUP:getting the security function allowed into local variables.
13988: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
13989: (p_api_version_number => 1.0,
13990: p_responsibility_id => FND_GLOBAL.Resp_id,
13991: p_function_name => 'PA_PM_ADD_TASK',
13992: p_msg_count => x_msg_count,
13993: p_msg_data => x_msg_data,
13994: p_return_status => x_return_status,

Line 14007: p_responsibility_id => FND_GLOBAL.Resp_id,

14003: END IF;
14004:
14005: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
14006: (p_api_version_number => 1.0,
14007: p_responsibility_id => FND_GLOBAL.Resp_id,
14008: p_function_name => 'PA_PM_UPDATE_TASK',
14009: p_msg_count => x_msg_count,
14010: p_msg_data => x_msg_data,
14011: p_return_status => x_return_status,

Line 18150: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

18146:
18147: savepoint process_wbs_updates_conc;
18148:
18149: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
18150: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
18151: retcode := '0';
18152: errbuf := NULL;
18153:
18154: IF l_debug_mode = 'Y' THEN

Line 18546: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;

18542: --bug 4472071
18543:
18544:
18545: l_project_id NUMBER := p_project_id;
18546: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;
18547: l_resp_appl_id NUMBER := FND_GLOBAL.resp_appl_id; -- 5233777
18548: l_financial_type VARCHAR2(1);
18549: l_workplan_type VARCHAR2(1);
18550: l_scheduled_start_date DATE;

Line 18547: l_resp_appl_id NUMBER := FND_GLOBAL.resp_appl_id; -- 5233777

18543:
18544:
18545: l_project_id NUMBER := p_project_id;
18546: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;
18547: l_resp_appl_id NUMBER := FND_GLOBAL.resp_appl_id; -- 5233777
18548: l_financial_type VARCHAR2(1);
18549: l_workplan_type VARCHAR2(1);
18550: l_scheduled_start_date DATE;
18551: l_scheduled_finish_date DATE;

Line 18564: l_user_id NUMBER := FND_GLOBAL.USER_ID;-- rtarway, 4030358, changed from login id to user_id

18560: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
18561: l_i_msg_count NUMBER := 0;
18562: l_i_msg_data PA_VC_1000_2000:= PA_VC_1000_2000(1);
18563: l_i_return_status VARCHAR2(1);
18564: l_user_id NUMBER := FND_GLOBAL.USER_ID;-- rtarway, 4030358, changed from login id to user_id
18565: --end bug 4019845
18566: l_out_online_flag VARCHAR2(1);
18567:
18568: l_plan_version_id NUMBER; --bug 4587145

Line 18809: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

18805: END IF;
18806: */
18807:
18808: -- Get the request id. If the request id returned is -1 then set it to null.
18809: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
18810: IF l_request_id = -1 THEN
18811: l_request_id := NULL;
18812: END IF;
18813:

Line 21320: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID

21316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
21317: ,p_validation_level IN VARCHAR2 := 100
21318: ,p_debug_mode IN VARCHAR2 := 'N'
21319: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21320: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
21321: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21322: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21323: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
21324: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR