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 6651: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6647: l_src_fin_version_id NUMBER(15);
6648: l_versioning_enabled VARCHAR2(1);
6649: dest_latest_eff_pub_flag VARCHAR2(1);
6650: dest_current_flag VARCHAR2(1);
6651: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6652: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6653: BEGIN
6654:
6655: x_msg_count := 0;

Line 6652: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6648: l_versioning_enabled VARCHAR2(1);
6649: dest_latest_eff_pub_flag VARCHAR2(1);
6650: dest_current_flag VARCHAR2(1);
6651: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6652: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6653: BEGIN
6654:
6655: x_msg_count := 0;
6656: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7151: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7147: l_debug_level4 CONSTANT NUMBER := 4;
7148: l_debug_level5 CONSTANT NUMBER := 5;
7149:
7150: l_src_fin_version_id NUMBER(15);
7151: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7153: l_delta NUMBER;
7154: l_src_sch_st_date DATE;
7155:

Line 7152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7148: l_debug_level5 CONSTANT NUMBER := 5;
7149:
7150: l_src_fin_version_id NUMBER(15);
7151: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7153: l_delta NUMBER;
7154: l_src_sch_st_date DATE;
7155:
7156: BEGIN

Line 8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8010:
8011: l_suffix VARCHAR2(250);
8012: l_append VARCHAR2(10) := ': ';
8013: l_name VARCHAR2(250);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_dest_wp_structure_id NUMBER;
8017: l_src_wp_structure_id NUMBER;
8018: l_dest_fn_structure_id NUMBER;

Line 8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8011: l_suffix VARCHAR2(250);
8012: l_append VARCHAR2(10) := ': ';
8013: l_name VARCHAR2(250);
8014: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8015: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8016: l_dest_wp_structure_id NUMBER;
8017: l_src_wp_structure_id NUMBER;
8018: l_dest_fn_structure_id NUMBER;
8019: l_src_fn_structure_id NUMBER;

Line 8686: OPEN cur_get_person_id(FND_GLOBAL.USER_ID);

8682: FETCH cur_get_dest_structure_id INTO l_dest_fn_structure_id, l_src_fn_structure_id;
8683: CLOSE cur_get_dest_structure_id;
8684:
8685: --Get the publish person id
8686: OPEN cur_get_person_id(FND_GLOBAL.USER_ID);
8687: FETCH cur_get_person_id INTO l_publish_person_id;
8688: IF cur_get_person_id%NOTFOUND THEN
8689: l_publish_person_id := NULL;
8690: END IF;

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

8956: IF l_debug_mode = 'Y' THEN
8957: pa_debug.write(G_PKG_NAME, 'l_wp_approval_reqd_flag='||l_wp_approval_reqd_flag, l_debug_level3);
8958: pa_debug.write(G_PKG_NAME, 'l_wp_auto_publish_flag='||l_wp_auto_publish_flag, l_debug_level3);
8959: pa_debug.write(G_PKG_NAME, 'l_wp_approver_source_id='||l_wp_approver_source_id, l_debug_level3);
8960: pa_debug.write(G_PKG_NAME, 'fnd_global.employee_id='||fnd_global.employee_id, l_debug_level3);
8961: END IF;
8962:
8963: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8964: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN

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

8960: pa_debug.write(G_PKG_NAME, 'fnd_global.employee_id='||fnd_global.employee_id, l_debug_level3);
8961: END IF;
8962:
8963: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8964: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN
8965: -- 3916763 : Use fnd_global.employee_id instead of fnd_global.party_id
8966: l_submit_wf_required := 'Y';
8967: l_dest_status_code := 'STRUCTURE_WORKING';
8968: l_dest_latest_eff_pub_flag := 'N';

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

8961: END IF;
8962:
8963: IF NVL(l_wp_approval_reqd_flag,'N') <> 'N' THEN
8964: IF nvl(fnd_global.employee_id,-999) <> NVL(l_wp_approver_source_id,-999) THEN
8965: -- 3916763 : Use fnd_global.employee_id instead of fnd_global.party_id
8966: l_submit_wf_required := 'Y';
8967: l_dest_status_code := 'STRUCTURE_WORKING';
8968: l_dest_latest_eff_pub_flag := 'N';
8969: IF l_current_working_selected = nvl(l_puc_version_id,-88) OR 'Y' = l_shared OR 'Y' = p_dest_template_flag THEN

Line 10412: FND_GLOBAL.USER_ID,

10408: null, null, null, null,
10409: 'PA_TASKS',
10410: rec_copied_tasks.dest_ppe_id,
10411: null, null, null, null,
10412: FND_GLOBAL.USER_ID,
10413: FND_GLOBAL.LOGIN_ID,
10414: 275, null, null
10415: );
10416: END LOOP;

Line 10413: FND_GLOBAL.LOGIN_ID,

10409: 'PA_TASKS',
10410: rec_copied_tasks.dest_ppe_id,
10411: null, null, null, null,
10412: FND_GLOBAL.USER_ID,
10413: FND_GLOBAL.LOGIN_ID,
10414: 275, null, null
10415: );
10416: END LOOP;
10417: END IF;

Line 10428: FND_GLOBAL.USER_ID,

10424: null, null, null, null,
10425: 'PA_TASKS',
10426: rec_copied_tasks.dest_ppe_id,
10427: null, null, null, null,
10428: FND_GLOBAL.USER_ID,
10429: FND_GLOBAL.LOGIN_ID,
10430: 275, null, null
10431: );
10432: END LOOP;

Line 10429: FND_GLOBAL.LOGIN_ID,

10425: 'PA_TASKS',
10426: rec_copied_tasks.dest_ppe_id,
10427: null, null, null, null,
10428: FND_GLOBAL.USER_ID,
10429: FND_GLOBAL.LOGIN_ID,
10430: 275, null, null
10431: );
10432: END LOOP;
10433: END IF;

Line 10444: FND_GLOBAL.USER_ID,

10440: null, null, null, null,
10441: 'PA_TASKS',
10442: rec_copied_tasks.dest_ppe_id,
10443: null, null, null, null,
10444: FND_GLOBAL.USER_ID,
10445: FND_GLOBAL.LOGIN_ID,
10446: 275, null, null
10447: );
10448: END LOOP;

Line 10445: FND_GLOBAL.LOGIN_ID,

10441: 'PA_TASKS',
10442: rec_copied_tasks.dest_ppe_id,
10443: null, null, null, null,
10444: FND_GLOBAL.USER_ID,
10445: FND_GLOBAL.LOGIN_ID,
10446: 275, null, null
10447: );
10448: END LOOP;
10449: END IF;

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

10667: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_required='||l_submit_wf_required, l_debug_level3);
10668: Pa_Debug.WRITE(G_PKG_NAME, 'p_dest_project_id='||p_dest_project_id, l_debug_level3);
10669: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_str_id='||l_submit_wf_str_id, l_debug_level3);
10670: Pa_Debug.WRITE(G_PKG_NAME, 'l_submit_wf_str_version_id='||l_submit_wf_str_version_id, l_debug_level3);
10671: Pa_Debug.WRITE(G_PKG_NAME, 'fnd_global.resp_id='||fnd_global.resp_id, l_debug_level3);
10672: END IF;
10673:
10674: IF l_submit_wf_required = 'Y' AND l_submit_wf_str_version_id IS NOT NULL THEN
10675: IF l_debug_mode = 'Y' THEN

Line 10685: ,p_responsibility_id => fnd_global.resp_id

10681: p_calling_module => p_calling_module
10682: ,p_project_id => p_dest_project_id
10683: ,p_structure_id => l_submit_wf_str_id
10684: ,p_structure_version_id => l_submit_wf_str_version_id
10685: ,p_responsibility_id => fnd_global.resp_id
10686: ,x_return_status => x_return_status
10687: ,x_msg_count => x_msg_count
10688: ,x_msg_data => x_msg_data
10689: );

Line 10924: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10920:
10921: /* Code Addition ends for bug 3737444 */
10922:
10923: l_wp_attr_rec get_wp_attr%ROWTYPE;
10924: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10925: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10926:
10927: CURSOR l_get_structure_attr_csr
10928: IS

Line 10925: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10921: /* Code Addition ends for bug 3737444 */
10922:
10923: l_wp_attr_rec get_wp_attr%ROWTYPE;
10924: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10925: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10926:
10927: CURSOR l_get_structure_attr_csr
10928: IS
10929: /* SELECT *

Line 11173: open get_person_id(FND_GLOBAL.USER_ID);

11169: -- Bug 3717026 End
11170: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_src_project_id );
11171:
11172: --bug 2838547
11173: open get_person_id(FND_GLOBAL.USER_ID);
11174: fetch get_person_id into l_publish_person_id;
11175: IF get_person_id%NOTFOUND then
11176: l_publish_person_id := NULL;
11177: END IF;

Line 11583: FND_GLOBAL.USER_ID,

11579: null, null, null, null,
11580: 'PA_TASKS',
11581: c_atch.new_task_id,
11582: null, null, null, null,
11583: FND_GLOBAL.USER_ID,
11584: FND_GLOBAL.LOGIN_ID,
11585: 275, null, null);
11586:
11587: END LOOP ;

Line 11584: FND_GLOBAL.LOGIN_ID,

11580: 'PA_TASKS',
11581: c_atch.new_task_id,
11582: null, null, null, null,
11583: FND_GLOBAL.USER_ID,
11584: FND_GLOBAL.LOGIN_ID,
11585: 275, null, null);
11586:
11587: END LOOP ;
11588: CLOSE c_attach_tasks;

Line 14495: p_responsibility_id => FND_GLOBAL.Resp_id,

14491:
14492: --IUP:getting the security function allowed into local variables.
14493: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
14494: (p_api_version_number => 1.0,
14495: p_responsibility_id => FND_GLOBAL.Resp_id,
14496: p_function_name => 'PA_PM_ADD_TASK',
14497: p_msg_count => x_msg_count,
14498: p_msg_data => x_msg_data,
14499: p_return_status => x_return_status,

Line 14512: p_responsibility_id => FND_GLOBAL.Resp_id,

14508: END IF;
14509:
14510: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
14511: (p_api_version_number => 1.0,
14512: p_responsibility_id => FND_GLOBAL.Resp_id,
14513: p_function_name => 'PA_PM_UPDATE_TASK',
14514: p_msg_count => x_msg_count,
14515: p_msg_data => x_msg_data,
14516: p_return_status => x_return_status,

Line 18898: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

18894:
18895: savepoint process_wbs_updates_conc;
18896:
18897: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
18898: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
18899: retcode := '0';
18900: errbuf := NULL;
18901:
18902: IF l_debug_mode = 'Y' THEN

Line 19339: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;

19335: --bug 4472071
19336:
19337:
19338: l_project_id NUMBER := p_project_id;
19339: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;
19340: l_resp_appl_id NUMBER := FND_GLOBAL.resp_appl_id; -- 5233777
19341: l_financial_type VARCHAR2(1);
19342: l_workplan_type VARCHAR2(1);
19343: l_scheduled_start_date DATE;

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

19336:
19337:
19338: l_project_id NUMBER := p_project_id;
19339: l_responsibility_id NUMBER := FND_GLOBAL.resp_id;
19340: l_resp_appl_id NUMBER := FND_GLOBAL.resp_appl_id; -- 5233777
19341: l_financial_type VARCHAR2(1);
19342: l_workplan_type VARCHAR2(1);
19343: l_scheduled_start_date DATE;
19344: l_scheduled_finish_date DATE;

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

19353: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
19354: l_i_msg_count NUMBER := 0;
19355: l_i_msg_data PA_VC_1000_2000:= PA_VC_1000_2000(1);
19356: l_i_return_status VARCHAR2(1);
19357: l_user_id NUMBER := FND_GLOBAL.USER_ID;-- rtarway, 4030358, changed from login id to user_id
19358: --end bug 4019845
19359: l_out_online_flag VARCHAR2(1);
19360:
19361: l_plan_version_id NUMBER; --bug 4587145

Line 19602: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

19598: END IF;
19599: */
19600:
19601: -- Get the request id. If the request id returned is -1 then set it to null.
19602: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
19603: IF l_request_id = -1 THEN
19604: l_request_id := NULL;
19605: END IF;
19606:

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

22112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
22113: ,p_validation_level IN VARCHAR2 := 100
22114: ,p_debug_mode IN VARCHAR2 := 'N'
22115: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22116: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
22117: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22118: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22119: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
22120: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR