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

4351: ,p_project_id -- PROJECT_ID
4352: ,l_ins_proj_element_id_tbl(i) -- TASK_ID
4353: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID
4354: ,sysdate -- LAST_UPDATE_DATE
4355: ,fnd_global.user_id -- LAST_UPDATED_BY
4356: ,sysdate -- CREATION_DATE
4357: ,fnd_global.user_id -- CREATED_BY
4358: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4359: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE

Line 4357: ,fnd_global.user_id -- CREATED_BY

4353: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID
4354: ,sysdate -- LAST_UPDATE_DATE
4355: ,fnd_global.user_id -- LAST_UPDATED_BY
4356: ,sysdate -- CREATION_DATE
4357: ,fnd_global.user_id -- CREATED_BY
4358: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4359: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4360: ,NULL -- TRACK_AS_LABOR_FLAG
4361: ,NULL -- STANDARD_BILL_RATE

Line 4358: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

4354: ,sysdate -- LAST_UPDATE_DATE
4355: ,fnd_global.user_id -- LAST_UPDATED_BY
4356: ,sysdate -- CREATION_DATE
4357: ,fnd_global.user_id -- CREATED_BY
4358: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4359: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4360: ,NULL -- TRACK_AS_LABOR_FLAG
4361: ,NULL -- STANDARD_BILL_RATE
4362: ,NULL -- AVERAGE_BILL_RATE

Line 4647: ,fnd_global.user_id -- LAST_UPDATED_BY

4643: ,decode(p_one_to_one_mapping_flag,'Y',l_proj_elem_rlm_tbl(j)
4644: ,l_proj_element_id_tbl(i)) -- TASK_ID
4645: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4646: ,sysdate -- LAST_UPDATE_DATE
4647: ,fnd_global.user_id -- LAST_UPDATED_BY
4648: ,sysdate -- CREATION_DATE
4649: ,fnd_global.user_id -- CREATED_BY
4650: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4651: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE

Line 4649: ,fnd_global.user_id -- CREATED_BY

4645: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
4646: ,sysdate -- LAST_UPDATE_DATE
4647: ,fnd_global.user_id -- LAST_UPDATED_BY
4648: ,sysdate -- CREATION_DATE
4649: ,fnd_global.user_id -- CREATED_BY
4650: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4651: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4652: ,NULL -- TRACK_AS_LABOR_FLAG
4653: ,NULL -- STANDARD_BILL_RATE

Line 4650: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

4646: ,sysdate -- LAST_UPDATE_DATE
4647: ,fnd_global.user_id -- LAST_UPDATED_BY
4648: ,sysdate -- CREATION_DATE
4649: ,fnd_global.user_id -- CREATED_BY
4650: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4651: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4652: ,NULL -- TRACK_AS_LABOR_FLAG
4653: ,NULL -- STANDARD_BILL_RATE
4654: ,NULL -- AVERAGE_BILL_RATE

Line 5190: ,fnd_global.user_id -- LAST_UPDATED_BY

5186: ,decode(p_one_to_one_mapping_flag,'Y',l_bf_proj_elem_tbl(j)
5187: ,l_proj_element_id_tbl(i)) -- TASK_ID
5188: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
5189: ,sysdate -- LAST_UPDATE_DATE
5190: ,fnd_global.user_id -- LAST_UPDATED_BY
5191: ,sysdate -- CREATION_DATE
5192: ,fnd_global.user_id -- CREATED_BY
5193: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5194: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE

Line 5192: ,fnd_global.user_id -- CREATED_BY

5188: ,l_eligible_rlm_ids_tbl(j) -- RESOURCE_LIST_MEMBER_ID
5189: ,sysdate -- LAST_UPDATE_DATE
5190: ,fnd_global.user_id -- LAST_UPDATED_BY
5191: ,sysdate -- CREATION_DATE
5192: ,fnd_global.user_id -- CREATED_BY
5193: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5194: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
5195: ,NULL -- TRACK_AS_LABOR_FLAG
5196: ,NULL -- STANDARD_BILL_RATE

Line 5193: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

5189: ,sysdate -- LAST_UPDATE_DATE
5190: ,fnd_global.user_id -- LAST_UPDATED_BY
5191: ,sysdate -- CREATION_DATE
5192: ,fnd_global.user_id -- CREATED_BY
5193: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5194: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
5195: ,NULL -- TRACK_AS_LABOR_FLAG
5196: ,NULL -- STANDARD_BILL_RATE
5197: ,NULL -- AVERAGE_BILL_RATE

Line 7573: ,last_updated_by = FND_GLOBAL.user_id

7569:
7570: UPDATE PA_RESOURCE_ASSIGNMENTS
7571: 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))
7572: ,last_update_date = sysdate
7573: ,last_updated_by = FND_GLOBAL.user_id
7574: ,last_update_login = FND_GLOBAL.login_id
7575: ,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))
7576: ,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))
7577: ,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 7574: ,last_update_login = FND_GLOBAL.login_id

7570: UPDATE PA_RESOURCE_ASSIGNMENTS
7571: 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))
7572: ,last_update_date = sysdate
7573: ,last_updated_by = FND_GLOBAL.user_id
7574: ,last_update_login = FND_GLOBAL.login_id
7575: ,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))
7576: ,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))
7577: ,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))
7578: ,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 9088: fnd_global.user_id,

9084: 'N',
9085: Decode(l_txn_curr_code_tbl(j),l_pc,'Y','N'),
9086: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
9087: sysdate,
9088: fnd_global.user_id,
9089: fnd_global.login_id,
9090: fnd_global.user_id,
9091: sysdate);
9092:

Line 9089: fnd_global.login_id,

9085: Decode(l_txn_curr_code_tbl(j),l_pc,'Y','N'),
9086: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
9087: sysdate,
9088: fnd_global.user_id,
9089: fnd_global.login_id,
9090: fnd_global.user_id,
9091: sysdate);
9092:
9093: END IF; -- End of if p_src_project_id<>p_target_project_id

Line 9090: fnd_global.user_id,

9086: Decode(l_txn_curr_code_tbl(j),l_pfc,'Y','N'),
9087: sysdate,
9088: fnd_global.user_id,
9089: fnd_global.login_id,
9090: fnd_global.user_id,
9091: sysdate);
9092:
9093: END IF; -- End of if p_src_project_id<>p_target_project_id
9094: --Code changes for bug#4200168 ends here.

Line 12940: ,last_updated_by = FND_GLOBAL.user_id

12936: UPDATE pa_proj_fp_options
12937: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id
12938: ,record_version_number = record_version_number + 1
12939: ,last_update_date = SYSDATE
12940: ,last_updated_by = FND_GLOBAL.user_id
12941: ,last_update_login = FND_GLOBAL.login_id
12942: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12943:
12944: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last

Line 12941: ,last_update_login = FND_GLOBAL.login_id

12937: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id
12938: ,record_version_number = record_version_number + 1
12939: ,last_update_date = SYSDATE
12940: ,last_updated_by = FND_GLOBAL.user_id
12941: ,last_update_login = FND_GLOBAL.login_id
12942: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12943:
12944: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last
12945: UPDATE pa_budget_versions

Line 12949: ,last_updated_by = FND_GLOBAL.user_id

12945: UPDATE pa_budget_versions
12946: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12947: ,record_version_number = record_version_number + 1
12948: ,last_update_date = SYSDATE
12949: ,last_updated_by = FND_GLOBAL.user_id
12950: ,last_update_login = FND_GLOBAL.login_id
12951: where budget_version_id = l_pub_budget_version_id_tbl(i);
12952:
12953: END IF;

Line 12950: ,last_update_login = FND_GLOBAL.login_id

12946: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12947: ,record_version_number = record_version_number + 1
12948: ,last_update_date = SYSDATE
12949: ,last_updated_by = FND_GLOBAL.user_id
12950: ,last_update_login = FND_GLOBAL.login_id
12951: where budget_version_id = l_pub_budget_version_id_tbl(i);
12952:
12953: END IF;
12954: END IF;

Line 12988: ,last_updated_by = FND_GLOBAL.user_id

12984: ,cost_res_class_rate_sch_id = parent_plan_type_rec.cost_res_class_rate_sch_id
12985: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
12986: ,record_version_number = record_version_number + 1
12987: ,last_update_date = SYSDATE
12988: ,last_updated_by = FND_GLOBAL.user_id
12989: ,last_update_login = FND_GLOBAL.login_id
12990: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12991:
12992: -- Update budget_versions data for all the working versions in bulk

Line 12989: ,last_update_login = FND_GLOBAL.login_id

12985: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
12986: ,record_version_number = record_version_number + 1
12987: ,last_update_date = SYSDATE
12988: ,last_updated_by = FND_GLOBAL.user_id
12989: ,last_update_login = FND_GLOBAL.login_id
12990: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
12991:
12992: -- Update budget_versions data for all the working versions in bulk
12993:

Line 13010: ,last_updated_by = FND_GLOBAL.user_id

13006: ,labor_quantity = 0
13007: ,equipment_quantity = 0
13008: ***/
13009: ,last_update_date = SYSDATE
13010: ,last_updated_by = FND_GLOBAL.user_id
13011: ,last_update_login = FND_GLOBAL.login_id
13012: ,record_version_number = record_version_number + 1
13013: WHERE budget_version_id = l_budget_version_id_tbl(i);
13014:

Line 13011: ,last_update_login = FND_GLOBAL.login_id

13007: ,equipment_quantity = 0
13008: ***/
13009: ,last_update_date = SYSDATE
13010: ,last_updated_by = FND_GLOBAL.user_id
13011: ,last_update_login = FND_GLOBAL.login_id
13012: ,record_version_number = record_version_number + 1
13013: WHERE budget_version_id = l_budget_version_id_tbl(i);
13014:
13015: /* Bug 4200168: FP.M:B12: Pref Changes: Called the following api outside the BV loop

Line 13252: ,last_updated_by = FND_GLOBAL.user_id

13248: UPDATE pa_proj_fp_options
13249: SET rbs_version_id = parent_plan_type_rec.rbs_version_id
13250: ,record_version_number = record_version_number + 1
13251: ,last_update_date = SYSDATE
13252: ,last_updated_by = FND_GLOBAL.user_id
13253: ,last_update_login = FND_GLOBAL.login_id
13254: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
13255:
13256: -- For each of the versions, RBS re-mapping and re-summarization needs to be done

Line 13253: ,last_update_login = FND_GLOBAL.login_id

13249: SET rbs_version_id = parent_plan_type_rec.rbs_version_id
13250: ,record_version_number = record_version_number + 1
13251: ,last_update_date = SYSDATE
13252: ,last_updated_by = FND_GLOBAL.user_id
13253: ,last_update_login = FND_GLOBAL.login_id
13254: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
13255:
13256: -- For each of the versions, RBS re-mapping and re-summarization needs to be done
13257: FOR i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last LOOP

Line 13318: ,last_updated_by = FND_GLOBAL.user_id

13314: SET rbs_element_id = l_rbs_element_id_tbl(j)
13315: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
13316: ,record_version_number = record_version_number + 1
13317: ,last_update_date = SYSDATE
13318: ,last_updated_by = FND_GLOBAL.user_id
13319: ,last_update_login = FND_GLOBAL.login_id
13320: WHERE budget_version_id = l_budget_version_id_tbl(i)
13321: AND resource_assignment_id = l_txn_source_id_tbl(j);
13322: END IF;

Line 13319: ,last_update_login = FND_GLOBAL.login_id

13315: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
13316: ,record_version_number = record_version_number + 1
13317: ,last_update_date = SYSDATE
13318: ,last_updated_by = FND_GLOBAL.user_id
13319: ,last_update_login = FND_GLOBAL.login_id
13320: WHERE budget_version_id = l_budget_version_id_tbl(i)
13321: AND resource_assignment_id = l_txn_source_id_tbl(j);
13322: END IF;
13323: ELSE -- rbs version id is null

Line 13331: ,last_updated_by = FND_GLOBAL.user_id

13327: SET rbs_element_id = null
13328: ,txn_accum_header_id = null
13329: ,record_version_number = record_version_number + 1
13330: ,last_update_date = SYSDATE
13331: ,last_updated_by = FND_GLOBAL.user_id
13332: ,last_update_login = FND_GLOBAL.login_id
13333: WHERE budget_version_id = l_budget_version_id_tbl(i);
13334:
13335: IF l_debug_mode = 'Y' THEN

Line 13332: ,last_update_login = FND_GLOBAL.login_id

13328: ,txn_accum_header_id = null
13329: ,record_version_number = record_version_number + 1
13330: ,last_update_date = SYSDATE
13331: ,last_updated_by = FND_GLOBAL.user_id
13332: ,last_update_login = FND_GLOBAL.login_id
13333: WHERE budget_version_id = l_budget_version_id_tbl(i);
13334:
13335: IF l_debug_mode = 'Y' THEN
13336: pa_debug.g_err_stage:='Done with mapping';

Line 13648: ,last_updated_by = FND_GLOBAL.user_id

13644: update pa_proj_fp_options
13645: set rbs_version_id = l_rbs_version_id
13646: ,record_version_number = record_version_number + 1
13647: ,last_update_date = SYSDATE
13648: ,last_updated_by = FND_GLOBAL.user_id
13649: ,last_update_login = FND_GLOBAL.login_id
13650: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
13651:
13652: -- for each of the versions, RBS re-mapping and re-summarization needs to be done

Line 13649: ,last_update_login = FND_GLOBAL.login_id

13645: set rbs_version_id = l_rbs_version_id
13646: ,record_version_number = record_version_number + 1
13647: ,last_update_date = SYSDATE
13648: ,last_updated_by = FND_GLOBAL.user_id
13649: ,last_update_login = FND_GLOBAL.login_id
13650: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(i);
13651:
13652: -- for each of the versions, RBS re-mapping and re-summarization needs to be done
13653: FOR i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last LOOP

Line 13714: ,last_updated_by = FND_GLOBAL.user_id

13710: SET rbs_element_id = l_rbs_element_id_tbl(j)
13711: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
13712: ,record_version_number = record_version_number + 1
13713: ,last_update_date = SYSDATE
13714: ,last_updated_by = FND_GLOBAL.user_id
13715: ,last_update_login = FND_GLOBAL.login_id
13716: WHERE budget_version_id = l_budget_version_id_tbl(i)
13717: AND resource_assignment_id = l_txn_source_id_tbl(j);
13718: END IF;

Line 13715: ,last_update_login = FND_GLOBAL.login_id

13711: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
13712: ,record_version_number = record_version_number + 1
13713: ,last_update_date = SYSDATE
13714: ,last_updated_by = FND_GLOBAL.user_id
13715: ,last_update_login = FND_GLOBAL.login_id
13716: WHERE budget_version_id = l_budget_version_id_tbl(i)
13717: AND resource_assignment_id = l_txn_source_id_tbl(j);
13718: END IF;
13719: ELSE -- rbs version id is null

Line 13727: ,last_updated_by = FND_GLOBAL.user_id

13723: SET rbs_element_id = null
13724: ,txn_accum_header_id = null
13725: ,record_version_number = record_version_number + 1
13726: ,last_update_date = SYSDATE
13727: ,last_updated_by = FND_GLOBAL.user_id
13728: ,last_update_login = FND_GLOBAL.login_id
13729: WHERE budget_version_id = l_budget_version_id_tbl(i);
13730:
13731: END IF;

Line 13728: ,last_update_login = FND_GLOBAL.login_id

13724: ,txn_accum_header_id = null
13725: ,record_version_number = record_version_number + 1
13726: ,last_update_date = SYSDATE
13727: ,last_updated_by = FND_GLOBAL.user_id
13728: ,last_update_login = FND_GLOBAL.login_id
13729: WHERE budget_version_id = l_budget_version_id_tbl(i);
13730:
13731: END IF;
13732: END LOOP;