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_FP_PLANNING_TRANSACTION_PUB dependencies on FND_GLOBAL

Line 3999: ,fnd_global.user_id -- LAST_UPDATED_BY

3995: ,p_project_id -- PROJECT_ID
3996: ,l_ins_proj_element_id_tbl(i) -- TASK_ID
3997: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID
3998: ,sysdate -- LAST_UPDATE_DATE
3999: ,fnd_global.user_id -- LAST_UPDATED_BY
4000: ,sysdate -- CREATION_DATE
4001: ,fnd_global.user_id -- CREATED_BY
4002: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4003: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE

Line 4001: ,fnd_global.user_id -- CREATED_BY

3997: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID
3998: ,sysdate -- LAST_UPDATE_DATE
3999: ,fnd_global.user_id -- LAST_UPDATED_BY
4000: ,sysdate -- CREATION_DATE
4001: ,fnd_global.user_id -- CREATED_BY
4002: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4003: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4004: ,NULL -- TRACK_AS_LABOR_FLAG
4005: ,NULL -- STANDARD_BILL_RATE

Line 4002: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

3998: ,sysdate -- LAST_UPDATE_DATE
3999: ,fnd_global.user_id -- LAST_UPDATED_BY
4000: ,sysdate -- CREATION_DATE
4001: ,fnd_global.user_id -- CREATED_BY
4002: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4003: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4004: ,NULL -- TRACK_AS_LABOR_FLAG
4005: ,NULL -- STANDARD_BILL_RATE
4006: ,NULL -- AVERAGE_BILL_RATE

Line 4251: ,fnd_global.user_id -- LAST_UPDATED_BY

4247: ,decode(p_one_to_one_mapping_flag,'Y',l_proj_elem_rlm_tbl(j)
4248: ,l_proj_element_id_tbl(i)) -- TASK_ID
4249: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4250: ,sysdate -- LAST_UPDATE_DATE
4251: ,fnd_global.user_id -- LAST_UPDATED_BY
4252: ,sysdate -- CREATION_DATE
4253: ,fnd_global.user_id -- CREATED_BY
4254: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4255: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE

Line 4253: ,fnd_global.user_id -- CREATED_BY

4249: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4250: ,sysdate -- LAST_UPDATE_DATE
4251: ,fnd_global.user_id -- LAST_UPDATED_BY
4252: ,sysdate -- CREATION_DATE
4253: ,fnd_global.user_id -- CREATED_BY
4254: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4255: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4256: ,NULL -- TRACK_AS_LABOR_FLAG
4257: ,NULL -- STANDARD_BILL_RATE

Line 4254: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

4250: ,sysdate -- LAST_UPDATE_DATE
4251: ,fnd_global.user_id -- LAST_UPDATED_BY
4252: ,sysdate -- CREATION_DATE
4253: ,fnd_global.user_id -- CREATED_BY
4254: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4255: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4256: ,NULL -- TRACK_AS_LABOR_FLAG
4257: ,NULL -- STANDARD_BILL_RATE
4258: ,NULL -- AVERAGE_BILL_RATE

Line 4602: ,fnd_global.user_id -- LAST_UPDATED_BY

4598: ,decode(p_one_to_one_mapping_flag,'Y',l_bf_proj_elem_tbl(j)
4599: ,l_proj_element_id_tbl(i)) -- TASK_ID
4600: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4601: ,sysdate -- LAST_UPDATE_DATE
4602: ,fnd_global.user_id -- LAST_UPDATED_BY
4603: ,sysdate -- CREATION_DATE
4604: ,fnd_global.user_id -- CREATED_BY
4605: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4606: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE

Line 4604: ,fnd_global.user_id -- CREATED_BY

4600: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4601: ,sysdate -- LAST_UPDATE_DATE
4602: ,fnd_global.user_id -- LAST_UPDATED_BY
4603: ,sysdate -- CREATION_DATE
4604: ,fnd_global.user_id -- CREATED_BY
4605: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4606: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4607: ,NULL -- TRACK_AS_LABOR_FLAG
4608: ,NULL -- STANDARD_BILL_RATE

Line 4605: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

4601: ,sysdate -- LAST_UPDATE_DATE
4602: ,fnd_global.user_id -- LAST_UPDATED_BY
4603: ,sysdate -- CREATION_DATE
4604: ,fnd_global.user_id -- CREATED_BY
4605: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4606: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4607: ,NULL -- TRACK_AS_LABOR_FLAG
4608: ,NULL -- STANDARD_BILL_RATE
4609: ,NULL -- AVERAGE_BILL_RATE

Line 6884: ,last_updated_by = FND_GLOBAL.user_id

6880:
6881: UPDATE PA_RESOURCE_ASSIGNMENTS
6882: SET resource_list_member_id = DECODE (l_resource_list_member_id_tbl(i),l_g_miss_num,null,nvl(l_resource_list_member_id_tbl(i),resource_list_member_id))
6883: ,last_update_date = sysdate
6884: ,last_updated_by = FND_GLOBAL.user_id
6885: ,last_update_login = FND_GLOBAL.login_id
6886: ,unit_of_measure = DECODE (l_unit_of_measure_tbl(i), l_g_miss_char,null,nvl( l_unit_of_measure_tbl(i),unit_of_measure))
6887: ,project_assignment_id = DECODE (l_project_assignment_id_tbl(i), l_g_miss_num,null,nvl(l_project_assignment_id_tbl(i),project_assignment_id))
6888: ,planning_start_date = DECODE (l_planning_start_date_tbl(i), l_g_miss_date,null,nvl(l_planning_start_date_tbl(i),planning_start_date))

Line 6885: ,last_update_login = FND_GLOBAL.login_id

6881: UPDATE PA_RESOURCE_ASSIGNMENTS
6882: SET resource_list_member_id = DECODE (l_resource_list_member_id_tbl(i),l_g_miss_num,null,nvl(l_resource_list_member_id_tbl(i),resource_list_member_id))
6883: ,last_update_date = sysdate
6884: ,last_updated_by = FND_GLOBAL.user_id
6885: ,last_update_login = FND_GLOBAL.login_id
6886: ,unit_of_measure = DECODE (l_unit_of_measure_tbl(i), l_g_miss_char,null,nvl( l_unit_of_measure_tbl(i),unit_of_measure))
6887: ,project_assignment_id = DECODE (l_project_assignment_id_tbl(i), l_g_miss_num,null,nvl(l_project_assignment_id_tbl(i),project_assignment_id))
6888: ,planning_start_date = DECODE (l_planning_start_date_tbl(i), l_g_miss_date,null,nvl(l_planning_start_date_tbl(i),planning_start_date))
6889: ,planning_end_date = DECODE (l_planning_end_date_tbl(i), l_g_miss_date,null,nvl(l_planning_end_date_tbl(i),planning_end_date))

Line 8262: fnd_global.user_id,

8258: 'N',
8259: Decode(l_txn_curr_code_tbl(j),l_pc,'Y','N'),
8260: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
8261: sysdate,
8262: fnd_global.user_id,
8263: fnd_global.login_id,
8264: fnd_global.user_id,
8265: sysdate);
8266:

Line 8263: fnd_global.login_id,

8259: Decode(l_txn_curr_code_tbl(j),l_pc,'Y','N'),
8260: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
8261: sysdate,
8262: fnd_global.user_id,
8263: fnd_global.login_id,
8264: fnd_global.user_id,
8265: sysdate);
8266:
8267: END IF; -- End of if p_src_project_id<>p_target_project_id

Line 8264: fnd_global.user_id,

8260: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
8261: sysdate,
8262: fnd_global.user_id,
8263: fnd_global.login_id,
8264: fnd_global.user_id,
8265: sysdate);
8266:
8267: END IF; -- End of if p_src_project_id<>p_target_project_id
8268: --Code changes for bug#4200168 ends here.

Line 12053: ,last_updated_by = FND_GLOBAL.user_id

12049: UPDATE pa_proj_fp_options
12050: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id
12051: ,record_version_number = record_version_number + 1
12052: ,last_update_date = SYSDATE
12053: ,last_updated_by = FND_GLOBAL.user_id
12054: ,last_update_login = FND_GLOBAL.login_id
12055: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12056:
12057: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last

Line 12054: ,last_update_login = FND_GLOBAL.login_id

12050: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id
12051: ,record_version_number = record_version_number + 1
12052: ,last_update_date = SYSDATE
12053: ,last_updated_by = FND_GLOBAL.user_id
12054: ,last_update_login = FND_GLOBAL.login_id
12055: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12056:
12057: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last
12058: UPDATE pa_budget_versions

Line 12062: ,last_updated_by = FND_GLOBAL.user_id

12058: UPDATE pa_budget_versions
12059: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12060: ,record_version_number = record_version_number + 1
12061: ,last_update_date = SYSDATE
12062: ,last_updated_by = FND_GLOBAL.user_id
12063: ,last_update_login = FND_GLOBAL.login_id
12064: where budget_version_id = l_pub_budget_version_id_tbl(i);
12065:
12066: END IF;

Line 12063: ,last_update_login = FND_GLOBAL.login_id

12059: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12060: ,record_version_number = record_version_number + 1
12061: ,last_update_date = SYSDATE
12062: ,last_updated_by = FND_GLOBAL.user_id
12063: ,last_update_login = FND_GLOBAL.login_id
12064: where budget_version_id = l_pub_budget_version_id_tbl(i);
12065:
12066: END IF;
12067: END IF;

Line 12101: ,last_updated_by = FND_GLOBAL.user_id

12097: ,cost_res_class_rate_sch_id = parent_plan_type_rec.cost_res_class_rate_sch_id
12098: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
12099: ,record_version_number = record_version_number + 1
12100: ,last_update_date = SYSDATE
12101: ,last_updated_by = FND_GLOBAL.user_id
12102: ,last_update_login = FND_GLOBAL.login_id
12103: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12104:
12105: -- Update budget_versions data for all the working versions in bulk

Line 12102: ,last_update_login = FND_GLOBAL.login_id

12098: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
12099: ,record_version_number = record_version_number + 1
12100: ,last_update_date = SYSDATE
12101: ,last_updated_by = FND_GLOBAL.user_id
12102: ,last_update_login = FND_GLOBAL.login_id
12103: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12104:
12105: -- Update budget_versions data for all the working versions in bulk
12106:

Line 12123: ,last_updated_by = FND_GLOBAL.user_id

12119: ,labor_quantity = 0
12120: ,equipment_quantity = 0
12121: ***/
12122: ,last_update_date = SYSDATE
12123: ,last_updated_by = FND_GLOBAL.user_id
12124: ,last_update_login = FND_GLOBAL.login_id
12125: ,record_version_number = record_version_number + 1
12126: WHERE budget_version_id = l_budget_version_id_tbl(i);
12127:

Line 12124: ,last_update_login = FND_GLOBAL.login_id

12120: ,equipment_quantity = 0
12121: ***/
12122: ,last_update_date = SYSDATE
12123: ,last_updated_by = FND_GLOBAL.user_id
12124: ,last_update_login = FND_GLOBAL.login_id
12125: ,record_version_number = record_version_number + 1
12126: WHERE budget_version_id = l_budget_version_id_tbl(i);
12127:
12128: /* Bug 4200168: FP.M:B12: Pref Changes: Called the following api outside the BV loop

Line 12351: ,last_updated_by = FND_GLOBAL.user_id

12347: UPDATE pa_proj_fp_options
12348: SET rbs_version_id = parent_plan_type_rec.rbs_version_id
12349: ,record_version_number = record_version_number + 1
12350: ,last_update_date = SYSDATE
12351: ,last_updated_by = FND_GLOBAL.user_id
12352: ,last_update_login = FND_GLOBAL.login_id
12353: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12354:
12355: -- For each of the versions, RBS re-mapping and re-summarization needs to be done

Line 12352: ,last_update_login = FND_GLOBAL.login_id

12348: SET rbs_version_id = parent_plan_type_rec.rbs_version_id
12349: ,record_version_number = record_version_number + 1
12350: ,last_update_date = SYSDATE
12351: ,last_updated_by = FND_GLOBAL.user_id
12352: ,last_update_login = FND_GLOBAL.login_id
12353: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12354:
12355: -- For each of the versions, RBS re-mapping and re-summarization needs to be done
12356: FOR i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last LOOP

Line 12417: ,last_updated_by = FND_GLOBAL.user_id

12413: SET rbs_element_id = l_rbs_element_id_tbl(j)
12414: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
12415: ,record_version_number = record_version_number + 1
12416: ,last_update_date = SYSDATE
12417: ,last_updated_by = FND_GLOBAL.user_id
12418: ,last_update_login = FND_GLOBAL.login_id
12419: WHERE budget_version_id = l_budget_version_id_tbl(i)
12420: AND resource_assignment_id = l_txn_source_id_tbl(j);
12421: END IF;

Line 12418: ,last_update_login = FND_GLOBAL.login_id

12414: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
12415: ,record_version_number = record_version_number + 1
12416: ,last_update_date = SYSDATE
12417: ,last_updated_by = FND_GLOBAL.user_id
12418: ,last_update_login = FND_GLOBAL.login_id
12419: WHERE budget_version_id = l_budget_version_id_tbl(i)
12420: AND resource_assignment_id = l_txn_source_id_tbl(j);
12421: END IF;
12422: ELSE -- rbs version id is null

Line 12430: ,last_updated_by = FND_GLOBAL.user_id

12426: SET rbs_element_id = null
12427: ,txn_accum_header_id = null
12428: ,record_version_number = record_version_number + 1
12429: ,last_update_date = SYSDATE
12430: ,last_updated_by = FND_GLOBAL.user_id
12431: ,last_update_login = FND_GLOBAL.login_id
12432: WHERE budget_version_id = l_budget_version_id_tbl(i);
12433:
12434: IF l_debug_mode = 'Y' THEN

Line 12431: ,last_update_login = FND_GLOBAL.login_id

12427: ,txn_accum_header_id = null
12428: ,record_version_number = record_version_number + 1
12429: ,last_update_date = SYSDATE
12430: ,last_updated_by = FND_GLOBAL.user_id
12431: ,last_update_login = FND_GLOBAL.login_id
12432: WHERE budget_version_id = l_budget_version_id_tbl(i);
12433:
12434: IF l_debug_mode = 'Y' THEN
12435: pa_debug.g_err_stage:='Done with mapping';

Line 12747: ,last_updated_by = FND_GLOBAL.user_id

12743: update pa_proj_fp_options
12744: set rbs_version_id = l_rbs_version_id
12745: ,record_version_number = record_version_number + 1
12746: ,last_update_date = SYSDATE
12747: ,last_updated_by = FND_GLOBAL.user_id
12748: ,last_update_login = FND_GLOBAL.login_id
12749: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12750:
12751: -- for each of the versions, RBS re-mapping and re-summarization needs to be done

Line 12748: ,last_update_login = FND_GLOBAL.login_id

12744: set rbs_version_id = l_rbs_version_id
12745: ,record_version_number = record_version_number + 1
12746: ,last_update_date = SYSDATE
12747: ,last_updated_by = FND_GLOBAL.user_id
12748: ,last_update_login = FND_GLOBAL.login_id
12749: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12750:
12751: -- for each of the versions, RBS re-mapping and re-summarization needs to be done
12752: FOR i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last LOOP

Line 12813: ,last_updated_by = FND_GLOBAL.user_id

12809: SET rbs_element_id = l_rbs_element_id_tbl(j)
12810: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
12811: ,record_version_number = record_version_number + 1
12812: ,last_update_date = SYSDATE
12813: ,last_updated_by = FND_GLOBAL.user_id
12814: ,last_update_login = FND_GLOBAL.login_id
12815: WHERE budget_version_id = l_budget_version_id_tbl(i)
12816: AND resource_assignment_id = l_txn_source_id_tbl(j);
12817: END IF;

Line 12814: ,last_update_login = FND_GLOBAL.login_id

12810: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
12811: ,record_version_number = record_version_number + 1
12812: ,last_update_date = SYSDATE
12813: ,last_updated_by = FND_GLOBAL.user_id
12814: ,last_update_login = FND_GLOBAL.login_id
12815: WHERE budget_version_id = l_budget_version_id_tbl(i)
12816: AND resource_assignment_id = l_txn_source_id_tbl(j);
12817: END IF;
12818: ELSE -- rbs version id is null

Line 12826: ,last_updated_by = FND_GLOBAL.user_id

12822: SET rbs_element_id = null
12823: ,txn_accum_header_id = null
12824: ,record_version_number = record_version_number + 1
12825: ,last_update_date = SYSDATE
12826: ,last_updated_by = FND_GLOBAL.user_id
12827: ,last_update_login = FND_GLOBAL.login_id
12828: WHERE budget_version_id = l_budget_version_id_tbl(i);
12829:
12830: END IF;

Line 12827: ,last_update_login = FND_GLOBAL.login_id

12823: ,txn_accum_header_id = null
12824: ,record_version_number = record_version_number + 1
12825: ,last_update_date = SYSDATE
12826: ,last_updated_by = FND_GLOBAL.user_id
12827: ,last_update_login = FND_GLOBAL.login_id
12828: WHERE budget_version_id = l_budget_version_id_tbl(i);
12829:
12830: END IF;
12831: END LOOP;