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

Line 181: last_updated_by=FND_GLOBAL.user_id,

177: update
178: pa_budget_versions
179: set
180: last_update_date=SYSDATE,
181: last_updated_by=FND_GLOBAL.user_id,
182: last_update_login=FND_GLOBAL.login_id,
183: budget_status_code = 'S',
184: record_version_number=record_version_number+1 /* increment record_version_number */
185: where

Line 182: last_update_login=FND_GLOBAL.login_id,

178: pa_budget_versions
179: set
180: last_update_date=SYSDATE,
181: last_updated_by=FND_GLOBAL.user_id,
182: last_update_login=FND_GLOBAL.login_id,
183: budget_status_code = 'S',
184: record_version_number=record_version_number+1 /* increment record_version_number */
185: where
186: budget_version_id=p_budget_version_id;

Line 550: last_updated_by=FND_GLOBAL.user_id,

546: update
547: pa_budget_versions
548: set
549: last_update_date=SYSDATE,
550: last_updated_by=FND_GLOBAL.user_id,
551: last_update_login=FND_GLOBAL.login_id,
552: current_working_flag='N',
553: record_version_number=record_version_number+1 /* increment record_version_number */
554: where

Line 551: last_update_login=FND_GLOBAL.login_id,

547: pa_budget_versions
548: set
549: last_update_date=SYSDATE,
550: last_updated_by=FND_GLOBAL.user_id,
551: last_update_login=FND_GLOBAL.login_id,
552: current_working_flag='N',
553: record_version_number=record_version_number+1 /* increment record_version_number */
554: where
555: budget_version_id=p_orig_budget_version_id;

Line 562: last_updated_by=FND_GLOBAL.user_id,

558: update
559: pa_budget_versions
560: set
561: last_update_date=SYSDATE,
562: last_updated_by=FND_GLOBAL.user_id,
563: last_update_login=FND_GLOBAL.login_id,
564: current_working_flag='Y',
565: record_version_number=record_version_number+1 /* increment record_version_number */
566: where

Line 563: last_update_login=FND_GLOBAL.login_id,

559: pa_budget_versions
560: set
561: last_update_date=SYSDATE,
562: last_updated_by=FND_GLOBAL.user_id,
563: last_update_login=FND_GLOBAL.login_id,
564: current_working_flag='Y',
565: record_version_number=record_version_number+1 /* increment record_version_number */
566: where
567: budget_version_id=p_budget_version_id;

Line 694: last_updated_by=FND_GLOBAL.user_id,

690: update
691: pa_budget_versions
692: set
693: last_update_date=SYSDATE,
694: last_updated_by=FND_GLOBAL.user_id,
695: last_update_login=FND_GLOBAL.login_id,
696: budget_status_code = 'W',
697: record_version_number=record_version_number+1 /* increment record_version_number */
698: where

Line 695: last_update_login=FND_GLOBAL.login_id,

691: pa_budget_versions
692: set
693: last_update_date=SYSDATE,
694: last_updated_by=FND_GLOBAL.user_id,
695: last_update_login=FND_GLOBAL.login_id,
696: budget_status_code = 'W',
697: record_version_number=record_version_number+1 /* increment record_version_number */
698: where
699: budget_version_id=p_budget_version_id;

Line 822: last_updated_by=FND_GLOBAL.user_id,

818: update pa_budget_versions a
819: set original_flag = 'Y',
820: current_original_flag = 'N',
821: last_update_date = SYSDATE,
822: last_updated_by=FND_GLOBAL.user_id,
823: last_update_login=FND_GLOBAL.login_id,
824: record_version_number = record_version_number + 1
825: where (a.project_id,a.fin_plan_type_id,a.version_type) =
826: (select b.project_id,b.fin_plan_type_id,b.version_type

Line 823: last_update_login=FND_GLOBAL.login_id,

819: set original_flag = 'Y',
820: current_original_flag = 'N',
821: last_update_date = SYSDATE,
822: last_updated_by=FND_GLOBAL.user_id,
823: last_update_login=FND_GLOBAL.login_id,
824: record_version_number = record_version_number + 1
825: where (a.project_id,a.fin_plan_type_id,a.version_type) =
826: (select b.project_id,b.fin_plan_type_id,b.version_type
827: from pa_budget_versions b

Line 836: last_updated_by=FND_GLOBAL.user_id,

832: update
833: pa_budget_versions
834: set
835: last_update_date=SYSDATE,
836: last_updated_by=FND_GLOBAL.user_id,
837: last_update_login=FND_GLOBAL.login_id,
838: original_flag = 'Y',
839: current_original_flag='N',
840: record_version_number = record_version_number + 1 /* increment record_version_number */

Line 837: last_update_login=FND_GLOBAL.login_id,

833: pa_budget_versions
834: set
835: last_update_date=SYSDATE,
836: last_updated_by=FND_GLOBAL.user_id,
837: last_update_login=FND_GLOBAL.login_id,
838: original_flag = 'Y',
839: current_original_flag='N',
840: record_version_number = record_version_number + 1 /* increment record_version_number */
841: where

Line 849: last_updated_by=FND_GLOBAL.user_id,

845: update
846: pa_budget_versions
847: set
848: last_update_date=SYSDATE,
849: last_updated_by=FND_GLOBAL.user_id,
850: last_update_login=FND_GLOBAL.login_id,
851: original_flag = 'Y',
852: current_original_flag='Y',
853: record_version_number = record_version_number + 1 /* increment record_version_number */

Line 850: last_update_login=FND_GLOBAL.login_id,

846: pa_budget_versions
847: set
848: last_update_date=SYSDATE,
849: last_updated_by=FND_GLOBAL.user_id,
850: last_update_login=FND_GLOBAL.login_id,
851: original_flag = 'Y',
852: current_original_flag='Y',
853: record_version_number = record_version_number + 1 /* increment record_version_number */
854: where

Line 1268: last_updated_by = FND_GLOBAL.USER_ID,

1264: else
1265: update PA_BUDGET_VERSIONS
1266: set PURGED_FLAG = 'Y',
1267: last_update_date = sysdate,
1268: last_updated_by = FND_GLOBAL.USER_ID,
1269: request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */
1270: WHERE budget_version_id=p_budget_version_id
1271: returning budget_version_id
1272: bulk collect into l_budget_version_id_tbl;

Line 1269: request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */

1265: update PA_BUDGET_VERSIONS
1266: set PURGED_FLAG = 'Y',
1267: last_update_date = sysdate,
1268: last_updated_by = FND_GLOBAL.USER_ID,
1269: request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */
1270: WHERE budget_version_id=p_budget_version_id
1271: returning budget_version_id
1272: bulk collect into l_budget_version_id_tbl;
1273:

Line 1334: last_updated_by=FND_GLOBAL.user_id,

1330: pa_budget_versions
1331: set
1332: current_working_flag = 'Y',
1333: last_update_date=SYSDATE,
1334: last_updated_by=FND_GLOBAL.user_id,
1335: last_update_login=FND_GLOBAL.login_id,
1336: record_version_number=record_version_number+1
1337: where
1338: project_id = p_project_id and

Line 1335: last_update_login=FND_GLOBAL.login_id,

1331: set
1332: current_working_flag = 'Y',
1333: last_update_date=SYSDATE,
1334: last_updated_by=FND_GLOBAL.user_id,
1335: last_update_login=FND_GLOBAL.login_id,
1336: record_version_number=record_version_number+1
1337: where
1338: project_id = p_project_id and
1339: fin_plan_type_id = l_fin_plan_type_id and

Line 1806: ,last_updated_by = FND_GLOBAL.user_id

1802: ,gen_src_all_wp_version_id = DECODE(gen_src_all_wp_version_id
1803: ,p_budget_version_id,NULL,gen_src_all_wp_version_id)
1804: ,record_version_number = record_version_number + 1
1805: ,last_update_date = SYSDATE
1806: ,last_updated_by = FND_GLOBAL.user_id
1807: ,last_update_login = FND_GLOBAL.login_id
1808: WHERE project_id = l_project_id
1809: AND fin_plan_option_level_code = 'PLAN_VERSION'
1810: AND (gen_src_cost_plan_version_id = p_budget_version_id OR

Line 1807: ,last_update_login = FND_GLOBAL.login_id

1803: ,p_budget_version_id,NULL,gen_src_all_wp_version_id)
1804: ,record_version_number = record_version_number + 1
1805: ,last_update_date = SYSDATE
1806: ,last_updated_by = FND_GLOBAL.user_id
1807: ,last_update_login = FND_GLOBAL.login_id
1808: WHERE project_id = l_project_id
1809: AND fin_plan_option_level_code = 'PLAN_VERSION'
1810: AND (gen_src_cost_plan_version_id = p_budget_version_id OR
1811: gen_src_rev_plan_version_id = p_budget_version_id OR

Line 3263: l_created_by:=FND_GLOBAL.user_id;

3259: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3260: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
3261: end if;
3262: /* check to see if the current user is an EMPLOYEE; ONLY EMPLOYEES CAN BASELINE */
3263: l_created_by:=FND_GLOBAL.user_id;
3264: IF P_PA_DEBUG_MODE = 'Y' THEN
3265: pa_debug.write_file('Baseline: ' || 'created by= ' || l_created_by);
3266: END IF;
3267: l_emp_id := PA_UTILS.GetEmpIdFromUser(l_created_by);

Line 3357: last_updated_by = FND_GLOBAL.user_id,

3353: update
3354: pa_budget_versions
3355: set
3356: last_update_date = SYSDATE,
3357: last_updated_by = FND_GLOBAL.user_id,
3358: last_update_login = FND_GLOBAL.login_id,
3359: budget_status_code = 'W',
3360: record_version_number = record_version_number+1
3361: where

Line 3358: last_update_login = FND_GLOBAL.login_id,

3354: pa_budget_versions
3355: set
3356: last_update_date = SYSDATE,
3357: last_updated_by = FND_GLOBAL.user_id,
3358: last_update_login = FND_GLOBAL.login_id,
3359: budget_status_code = 'W',
3360: record_version_number = record_version_number+1
3361: where
3362: budget_version_id = p_budget_version_id;

Line 3368: last_updated_by = FND_GLOBAL.user_id,

3364: update
3365: pa_budget_versions
3366: set
3367: last_update_date = SYSDATE,
3368: last_updated_by = FND_GLOBAL.user_id,
3369: last_update_login = FND_GLOBAL.login_id,
3370: current_flag = 'N',
3371: record_version_number = record_version_number+1
3372: where

Line 3369: last_update_login = FND_GLOBAL.login_id,

3365: pa_budget_versions
3366: set
3367: last_update_date = SYSDATE,
3368: last_updated_by = FND_GLOBAL.user_id,
3369: last_update_login = FND_GLOBAL.login_id,
3370: current_flag = 'N',
3371: record_version_number = record_version_number+1
3372: where
3373: budget_version_id=p_orig_budget_version_id;

Line 4421: last_updated_by = FND_GLOBAL.user_id,

4417: version_name = p_version_name,
4418: description = p_description,
4419: change_reason_code = p_change_reason_code,
4420: last_update_date = SYSDATE,
4421: last_updated_by = FND_GLOBAL.user_id,
4422: last_update_login = FND_GLOBAL.login_id,
4423: /* Code addition for bug 3088010 starts */
4424: attribute_category = p_attribute_category,
4425: attribute1 = p_attribute1,

Line 4422: last_update_login = FND_GLOBAL.login_id,

4418: description = p_description,
4419: change_reason_code = p_change_reason_code,
4420: last_update_date = SYSDATE,
4421: last_updated_by = FND_GLOBAL.user_id,
4422: last_update_login = FND_GLOBAL.login_id,
4423: /* Code addition for bug 3088010 starts */
4424: attribute_category = p_attribute_category,
4425: attribute1 = p_attribute1,
4426: attribute2 = p_attribute2,

Line 4612: FND_GLOBAL.user_id, /* created_by */

4608: ae.task_id,
4609: ae.adjustment_reason_code,
4610: ae.adjustment_comments,
4611: SYSDATE, /* creation_date */
4612: FND_GLOBAL.user_id, /* created_by */
4613: FND_GLOBAL.login_id, /* last_update_login */
4614: FND_GLOBAL.user_id, /* last_updated_by */
4615: SYSDATE /* last_update_date */
4616: from

Line 4613: FND_GLOBAL.login_id, /* last_update_login */

4609: ae.adjustment_reason_code,
4610: ae.adjustment_comments,
4611: SYSDATE, /* creation_date */
4612: FND_GLOBAL.user_id, /* created_by */
4613: FND_GLOBAL.login_id, /* last_update_login */
4614: FND_GLOBAL.user_id, /* last_updated_by */
4615: SYSDATE /* last_update_date */
4616: from
4617: pa_fp_adj_elements ae

Line 4614: FND_GLOBAL.user_id, /* last_updated_by */

4610: ae.adjustment_comments,
4611: SYSDATE, /* creation_date */
4612: FND_GLOBAL.user_id, /* created_by */
4613: FND_GLOBAL.login_id, /* last_update_login */
4614: FND_GLOBAL.user_id, /* last_updated_by */
4615: SYSDATE /* last_update_date */
4616: from
4617: pa_fp_adj_elements ae
4618: where

Line 4644: FND_GLOBAL.user_id, /* created_by */

4640: head_count_adjustment)
4641: select
4642: l_adj_element_id, /* use newly-created adj_element_id */
4643: SYSDATE, /* creation_date */
4644: FND_GLOBAL.user_id, /* created_by */
4645: FND_GLOBAL.login_id, /* last_update_login */
4646: FND_GLOBAL.user_id, /* last_updated_by */
4647: SYSDATE, /* last_update_date */
4648: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */

Line 4645: FND_GLOBAL.login_id, /* last_update_login */

4641: select
4642: l_adj_element_id, /* use newly-created adj_element_id */
4643: SYSDATE, /* creation_date */
4644: FND_GLOBAL.user_id, /* created_by */
4645: FND_GLOBAL.login_id, /* last_update_login */
4646: FND_GLOBAL.user_id, /* last_updated_by */
4647: SYSDATE, /* last_update_date */
4648: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4649: al.project_id,

Line 4646: FND_GLOBAL.user_id, /* last_updated_by */

4642: l_adj_element_id, /* use newly-created adj_element_id */
4643: SYSDATE, /* creation_date */
4644: FND_GLOBAL.user_id, /* created_by */
4645: FND_GLOBAL.login_id, /* last_update_login */
4646: FND_GLOBAL.user_id, /* last_updated_by */
4647: SYSDATE, /* last_update_date */
4648: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4649: al.project_id,
4650: al.task_id,

Line 4750: FND_GLOBAL.user_id, /* created_by */

4746: project_id,
4747: parent_assignment_id)
4748: select
4749: SYSDATE, /* creation_date */
4750: FND_GLOBAL.user_id, /* created_by */
4751: FND_GLOBAL.login_id, /* last_update_login */
4752: FND_GLOBAL.user_id, /* last_updated_by */
4753: SYSDATE, /* last_update_date */
4754: p_target_version_id, /* use newly-created budget_version_id */

Line 4751: FND_GLOBAL.login_id, /* last_update_login */

4747: parent_assignment_id)
4748: select
4749: SYSDATE, /* creation_date */
4750: FND_GLOBAL.user_id, /* created_by */
4751: FND_GLOBAL.login_id, /* last_update_login */
4752: FND_GLOBAL.user_id, /* last_updated_by */
4753: SYSDATE, /* last_update_date */
4754: p_target_version_id, /* use newly-created budget_version_id */
4755: ppd.resource_assignment_id, /* copy over resource_assignment_id */

Line 4752: FND_GLOBAL.user_id, /* last_updated_by */

4748: select
4749: SYSDATE, /* creation_date */
4750: FND_GLOBAL.user_id, /* created_by */
4751: FND_GLOBAL.login_id, /* last_update_login */
4752: FND_GLOBAL.user_id, /* last_updated_by */
4753: SYSDATE, /* last_update_date */
4754: p_target_version_id, /* use newly-created budget_version_id */
4755: ppd.resource_assignment_id, /* copy over resource_assignment_id */
4756: l_adj_element_id, /* object_id is the newly-created adj_element_id */

Line 4867: FND_GLOBAL.user_id, /* created_by */

4863: resource_id,
4864: record_version_number)
4865: select
4866: SYSDATE, /* creation_date */
4867: FND_GLOBAL.user_id, /* created_by */
4868: FND_GLOBAL.login_id, /* last_update_login */
4869: FND_GLOBAL.user_id, /* last_updated_by */
4870: SYSDATE, /* last_update_date */
4871: l_forecast_element_id, /* use newly-generated forecast_element_id */

Line 4868: FND_GLOBAL.login_id, /* last_update_login */

4864: record_version_number)
4865: select
4866: SYSDATE, /* creation_date */
4867: FND_GLOBAL.user_id, /* created_by */
4868: FND_GLOBAL.login_id, /* last_update_login */
4869: FND_GLOBAL.user_id, /* last_updated_by */
4870: SYSDATE, /* last_update_date */
4871: l_forecast_element_id, /* use newly-generated forecast_element_id */
4872: fe.organization_id,

Line 4869: FND_GLOBAL.user_id, /* last_updated_by */

4865: select
4866: SYSDATE, /* creation_date */
4867: FND_GLOBAL.user_id, /* created_by */
4868: FND_GLOBAL.login_id, /* last_update_login */
4869: FND_GLOBAL.user_id, /* last_updated_by */
4870: SYSDATE, /* last_update_date */
4871: l_forecast_element_id, /* use newly-generated forecast_element_id */
4872: fe.organization_id,
4873: fe.org_id,

Line 4922: FND_GLOBAL.user_id, /* created_by */

4918: unassigned_time_cost,
4919: budget_version_id)
4920: select
4921: SYSDATE, /* creation_date */
4922: FND_GLOBAL.user_id, /* created_by */
4923: FND_GLOBAL.login_id, /* last_update_login */
4924: FND_GLOBAL.user_id, /* last_updated_by */
4925: SYSDATE, /* last_update_date */
4926: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */

Line 4923: FND_GLOBAL.login_id, /* last_update_login */

4919: budget_version_id)
4920: select
4921: SYSDATE, /* creation_date */
4922: FND_GLOBAL.user_id, /* created_by */
4923: FND_GLOBAL.login_id, /* last_update_login */
4924: FND_GLOBAL.user_id, /* last_updated_by */
4925: SYSDATE, /* last_update_date */
4926: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4927: l_forecast_element_id, /* use newly-created forecast_element_id */

Line 4924: FND_GLOBAL.user_id, /* last_updated_by */

4920: select
4921: SYSDATE, /* creation_date */
4922: FND_GLOBAL.user_id, /* created_by */
4923: FND_GLOBAL.login_id, /* last_update_login */
4924: FND_GLOBAL.user_id, /* last_updated_by */
4925: SYSDATE, /* last_update_date */
4926: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4927: l_forecast_element_id, /* use newly-created forecast_element_id */
4928: fl.project_id,

Line 5033: FND_GLOBAL.user_id, /* created_by */

5029: project_id,
5030: parent_assignment_id)
5031: select
5032: SYSDATE, /* creation_date */
5033: FND_GLOBAL.user_id, /* created_by */
5034: FND_GLOBAL.login_id, /* last_update_login */
5035: FND_GLOBAL.user_id, /* last_updated_by */
5036: SYSDATE, /* last_update_date */
5037: p_target_version_id, /* use newly-created budget_version_id */

Line 5034: FND_GLOBAL.login_id, /* last_update_login */

5030: parent_assignment_id)
5031: select
5032: SYSDATE, /* creation_date */
5033: FND_GLOBAL.user_id, /* created_by */
5034: FND_GLOBAL.login_id, /* last_update_login */
5035: FND_GLOBAL.user_id, /* last_updated_by */
5036: SYSDATE, /* last_update_date */
5037: p_target_version_id, /* use newly-created budget_version_id */
5038: ppd.resource_assignment_id, /* use the existing resource_assignment_id */

Line 5035: FND_GLOBAL.user_id, /* last_updated_by */

5031: select
5032: SYSDATE, /* creation_date */
5033: FND_GLOBAL.user_id, /* created_by */
5034: FND_GLOBAL.login_id, /* last_update_login */
5035: FND_GLOBAL.user_id, /* last_updated_by */
5036: SYSDATE, /* last_update_date */
5037: p_target_version_id, /* use newly-created budget_version_id */
5038: ppd.resource_assignment_id, /* use the existing resource_assignment_id */
5039: l_forecast_element_id, /* object_id is the newly-created forecast_element_id */

Line 6134: p_request_id => FND_GLOBAL.conc_request_id,

6130: p_total_capacity => NULL,
6131: p_total_head_count => NULL,
6132: p_total_head_count_adj => NULL,
6133: p_version_type => new_version_info_rec.version_type,
6134: p_request_id => FND_GLOBAL.conc_request_id,
6135: p_total_project_raw_cost => NULL,
6136: p_total_project_burdened_cost => NULL,
6137: p_total_project_revenue => NULL,
6138: p_locked_by_person_id => NULL,

Line 6637: ,last_updated_by = FND_GLOBAL.user_id

6633: SET rbs_element_id = l_rbs_element_id_tbl(j)
6634: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6635: ,record_version_number = record_version_number + 1
6636: ,last_update_date = SYSDATE
6637: ,last_updated_by = FND_GLOBAL.user_id
6638: ,last_update_login = FND_GLOBAL.login_id
6639: WHERE budget_version_id = l_new_budget_version_id
6640: AND resource_assignment_id = l_txn_source_id_tbl(j);
6641: END IF;

Line 6638: ,last_update_login = FND_GLOBAL.login_id

6634: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6635: ,record_version_number = record_version_number + 1
6636: ,last_update_date = SYSDATE
6637: ,last_updated_by = FND_GLOBAL.user_id
6638: ,last_update_login = FND_GLOBAL.login_id
6639: WHERE budget_version_id = l_new_budget_version_id
6640: AND resource_assignment_id = l_txn_source_id_tbl(j);
6641: END IF;
6642: ELSE -- rbs version id is null

Line 6650: ,last_updated_by = FND_GLOBAL.user_id

6646: SET rbs_element_id = null
6647: ,txn_accum_header_id = null
6648: ,record_version_number = record_version_number + 1
6649: ,last_update_date = SYSDATE
6650: ,last_updated_by = FND_GLOBAL.user_id
6651: ,last_update_login = FND_GLOBAL.login_id
6652: WHERE budget_version_id = l_new_budget_version_id;
6653:
6654: END IF;

Line 6651: ,last_update_login = FND_GLOBAL.login_id

6647: ,txn_accum_header_id = null
6648: ,record_version_number = record_version_number + 1
6649: ,last_update_date = SYSDATE
6650: ,last_updated_by = FND_GLOBAL.user_id
6651: ,last_update_login = FND_GLOBAL.login_id
6652: WHERE budget_version_id = l_new_budget_version_id;
6653:
6654: END IF;
6655: END IF;