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 1318: last_updated_by=FND_GLOBAL.user_id,

1314: pa_budget_versions
1315: set
1316: current_working_flag = 'Y',
1317: last_update_date=SYSDATE,
1318: last_updated_by=FND_GLOBAL.user_id,
1319: last_update_login=FND_GLOBAL.login_id,
1320: record_version_number=record_version_number+1
1321: where
1322: project_id = p_project_id and

Line 1319: last_update_login=FND_GLOBAL.login_id,

1315: set
1316: current_working_flag = 'Y',
1317: last_update_date=SYSDATE,
1318: last_updated_by=FND_GLOBAL.user_id,
1319: last_update_login=FND_GLOBAL.login_id,
1320: record_version_number=record_version_number+1
1321: where
1322: project_id = p_project_id and
1323: fin_plan_type_id = l_fin_plan_type_id and

Line 1790: ,last_updated_by = FND_GLOBAL.user_id

1786: ,gen_src_all_wp_version_id = DECODE(gen_src_all_wp_version_id
1787: ,p_budget_version_id,NULL,gen_src_all_wp_version_id)
1788: ,record_version_number = record_version_number + 1
1789: ,last_update_date = SYSDATE
1790: ,last_updated_by = FND_GLOBAL.user_id
1791: ,last_update_login = FND_GLOBAL.login_id
1792: WHERE project_id = l_project_id
1793: AND fin_plan_option_level_code = 'PLAN_VERSION'
1794: AND (gen_src_cost_plan_version_id = p_budget_version_id OR

Line 1791: ,last_update_login = FND_GLOBAL.login_id

1787: ,p_budget_version_id,NULL,gen_src_all_wp_version_id)
1788: ,record_version_number = record_version_number + 1
1789: ,last_update_date = SYSDATE
1790: ,last_updated_by = FND_GLOBAL.user_id
1791: ,last_update_login = FND_GLOBAL.login_id
1792: WHERE project_id = l_project_id
1793: AND fin_plan_option_level_code = 'PLAN_VERSION'
1794: AND (gen_src_cost_plan_version_id = p_budget_version_id OR
1795: gen_src_rev_plan_version_id = p_budget_version_id OR

Line 3247: l_created_by:=FND_GLOBAL.user_id;

3243: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3244: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
3245: end if;
3246: /* check to see if the current user is an EMPLOYEE; ONLY EMPLOYEES CAN BASELINE */
3247: l_created_by:=FND_GLOBAL.user_id;
3248: IF P_PA_DEBUG_MODE = 'Y' THEN
3249: pa_debug.write_file('Baseline: ' || 'created by= ' || l_created_by);
3250: END IF;
3251: l_emp_id := PA_UTILS.GetEmpIdFromUser(l_created_by);

Line 3341: last_updated_by = FND_GLOBAL.user_id,

3337: update
3338: pa_budget_versions
3339: set
3340: last_update_date = SYSDATE,
3341: last_updated_by = FND_GLOBAL.user_id,
3342: last_update_login = FND_GLOBAL.login_id,
3343: budget_status_code = 'W',
3344: record_version_number = record_version_number+1
3345: where

Line 3342: last_update_login = FND_GLOBAL.login_id,

3338: pa_budget_versions
3339: set
3340: last_update_date = SYSDATE,
3341: last_updated_by = FND_GLOBAL.user_id,
3342: last_update_login = FND_GLOBAL.login_id,
3343: budget_status_code = 'W',
3344: record_version_number = record_version_number+1
3345: where
3346: budget_version_id = p_budget_version_id;

Line 3352: last_updated_by = FND_GLOBAL.user_id,

3348: update
3349: pa_budget_versions
3350: set
3351: last_update_date = SYSDATE,
3352: last_updated_by = FND_GLOBAL.user_id,
3353: last_update_login = FND_GLOBAL.login_id,
3354: current_flag = 'N',
3355: record_version_number = record_version_number+1
3356: where

Line 3353: last_update_login = FND_GLOBAL.login_id,

3349: pa_budget_versions
3350: set
3351: last_update_date = SYSDATE,
3352: last_updated_by = FND_GLOBAL.user_id,
3353: last_update_login = FND_GLOBAL.login_id,
3354: current_flag = 'N',
3355: record_version_number = record_version_number+1
3356: where
3357: budget_version_id=p_orig_budget_version_id;

Line 4405: last_updated_by = FND_GLOBAL.user_id,

4401: version_name = p_version_name,
4402: description = p_description,
4403: change_reason_code = p_change_reason_code,
4404: last_update_date = SYSDATE,
4405: last_updated_by = FND_GLOBAL.user_id,
4406: last_update_login = FND_GLOBAL.login_id,
4407: /* Code addition for bug 3088010 starts */
4408: attribute_category = p_attribute_category,
4409: attribute1 = p_attribute1,

Line 4406: last_update_login = FND_GLOBAL.login_id,

4402: description = p_description,
4403: change_reason_code = p_change_reason_code,
4404: last_update_date = SYSDATE,
4405: last_updated_by = FND_GLOBAL.user_id,
4406: last_update_login = FND_GLOBAL.login_id,
4407: /* Code addition for bug 3088010 starts */
4408: attribute_category = p_attribute_category,
4409: attribute1 = p_attribute1,
4410: attribute2 = p_attribute2,

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

4592: ae.task_id,
4593: ae.adjustment_reason_code,
4594: ae.adjustment_comments,
4595: SYSDATE, /* creation_date */
4596: FND_GLOBAL.user_id, /* created_by */
4597: FND_GLOBAL.login_id, /* last_update_login */
4598: FND_GLOBAL.user_id, /* last_updated_by */
4599: SYSDATE /* last_update_date */
4600: from

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

4593: ae.adjustment_reason_code,
4594: ae.adjustment_comments,
4595: SYSDATE, /* creation_date */
4596: FND_GLOBAL.user_id, /* created_by */
4597: FND_GLOBAL.login_id, /* last_update_login */
4598: FND_GLOBAL.user_id, /* last_updated_by */
4599: SYSDATE /* last_update_date */
4600: from
4601: pa_fp_adj_elements ae

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

4594: ae.adjustment_comments,
4595: SYSDATE, /* creation_date */
4596: FND_GLOBAL.user_id, /* created_by */
4597: FND_GLOBAL.login_id, /* last_update_login */
4598: FND_GLOBAL.user_id, /* last_updated_by */
4599: SYSDATE /* last_update_date */
4600: from
4601: pa_fp_adj_elements ae
4602: where

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

4624: head_count_adjustment)
4625: select
4626: l_adj_element_id, /* use newly-created adj_element_id */
4627: SYSDATE, /* creation_date */
4628: FND_GLOBAL.user_id, /* created_by */
4629: FND_GLOBAL.login_id, /* last_update_login */
4630: FND_GLOBAL.user_id, /* last_updated_by */
4631: SYSDATE, /* last_update_date */
4632: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */

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

4625: select
4626: l_adj_element_id, /* use newly-created adj_element_id */
4627: SYSDATE, /* creation_date */
4628: FND_GLOBAL.user_id, /* created_by */
4629: FND_GLOBAL.login_id, /* last_update_login */
4630: FND_GLOBAL.user_id, /* last_updated_by */
4631: SYSDATE, /* last_update_date */
4632: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4633: al.project_id,

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

4626: l_adj_element_id, /* use newly-created adj_element_id */
4627: SYSDATE, /* creation_date */
4628: FND_GLOBAL.user_id, /* created_by */
4629: FND_GLOBAL.login_id, /* last_update_login */
4630: FND_GLOBAL.user_id, /* last_updated_by */
4631: SYSDATE, /* last_update_date */
4632: pa_fin_plan_adj_lines_s.nextVal, /* use nextVal for fin_plan_adj_line_id */
4633: al.project_id,
4634: al.task_id,

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

4730: project_id,
4731: parent_assignment_id)
4732: select
4733: SYSDATE, /* creation_date */
4734: FND_GLOBAL.user_id, /* created_by */
4735: FND_GLOBAL.login_id, /* last_update_login */
4736: FND_GLOBAL.user_id, /* last_updated_by */
4737: SYSDATE, /* last_update_date */
4738: p_target_version_id, /* use newly-created budget_version_id */

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

4731: parent_assignment_id)
4732: select
4733: SYSDATE, /* creation_date */
4734: FND_GLOBAL.user_id, /* created_by */
4735: FND_GLOBAL.login_id, /* last_update_login */
4736: FND_GLOBAL.user_id, /* last_updated_by */
4737: SYSDATE, /* last_update_date */
4738: p_target_version_id, /* use newly-created budget_version_id */
4739: ppd.resource_assignment_id, /* copy over resource_assignment_id */

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

4732: select
4733: SYSDATE, /* creation_date */
4734: FND_GLOBAL.user_id, /* created_by */
4735: FND_GLOBAL.login_id, /* last_update_login */
4736: FND_GLOBAL.user_id, /* last_updated_by */
4737: SYSDATE, /* last_update_date */
4738: p_target_version_id, /* use newly-created budget_version_id */
4739: ppd.resource_assignment_id, /* copy over resource_assignment_id */
4740: l_adj_element_id, /* object_id is the newly-created adj_element_id */

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

4847: resource_id,
4848: record_version_number)
4849: select
4850: SYSDATE, /* creation_date */
4851: FND_GLOBAL.user_id, /* created_by */
4852: FND_GLOBAL.login_id, /* last_update_login */
4853: FND_GLOBAL.user_id, /* last_updated_by */
4854: SYSDATE, /* last_update_date */
4855: l_forecast_element_id, /* use newly-generated forecast_element_id */

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

4848: record_version_number)
4849: select
4850: SYSDATE, /* creation_date */
4851: FND_GLOBAL.user_id, /* created_by */
4852: FND_GLOBAL.login_id, /* last_update_login */
4853: FND_GLOBAL.user_id, /* last_updated_by */
4854: SYSDATE, /* last_update_date */
4855: l_forecast_element_id, /* use newly-generated forecast_element_id */
4856: fe.organization_id,

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

4849: select
4850: SYSDATE, /* creation_date */
4851: FND_GLOBAL.user_id, /* created_by */
4852: FND_GLOBAL.login_id, /* last_update_login */
4853: FND_GLOBAL.user_id, /* last_updated_by */
4854: SYSDATE, /* last_update_date */
4855: l_forecast_element_id, /* use newly-generated forecast_element_id */
4856: fe.organization_id,
4857: fe.org_id,

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

4902: unassigned_time_cost,
4903: budget_version_id)
4904: select
4905: SYSDATE, /* creation_date */
4906: FND_GLOBAL.user_id, /* created_by */
4907: FND_GLOBAL.login_id, /* last_update_login */
4908: FND_GLOBAL.user_id, /* last_updated_by */
4909: SYSDATE, /* last_update_date */
4910: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */

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

4903: budget_version_id)
4904: select
4905: SYSDATE, /* creation_date */
4906: FND_GLOBAL.user_id, /* created_by */
4907: FND_GLOBAL.login_id, /* last_update_login */
4908: FND_GLOBAL.user_id, /* last_updated_by */
4909: SYSDATE, /* last_update_date */
4910: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4911: l_forecast_element_id, /* use newly-created forecast_element_id */

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

4904: select
4905: SYSDATE, /* creation_date */
4906: FND_GLOBAL.user_id, /* created_by */
4907: FND_GLOBAL.login_id, /* last_update_login */
4908: FND_GLOBAL.user_id, /* last_updated_by */
4909: SYSDATE, /* last_update_date */
4910: pa_org_forecast_lines_s.nextVal, /* use nextVal to generate next forecast_line_id */
4911: l_forecast_element_id, /* use newly-created forecast_element_id */
4912: fl.project_id,

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

5013: project_id,
5014: parent_assignment_id)
5015: select
5016: SYSDATE, /* creation_date */
5017: FND_GLOBAL.user_id, /* created_by */
5018: FND_GLOBAL.login_id, /* last_update_login */
5019: FND_GLOBAL.user_id, /* last_updated_by */
5020: SYSDATE, /* last_update_date */
5021: p_target_version_id, /* use newly-created budget_version_id */

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

5014: parent_assignment_id)
5015: select
5016: SYSDATE, /* creation_date */
5017: FND_GLOBAL.user_id, /* created_by */
5018: FND_GLOBAL.login_id, /* last_update_login */
5019: FND_GLOBAL.user_id, /* last_updated_by */
5020: SYSDATE, /* last_update_date */
5021: p_target_version_id, /* use newly-created budget_version_id */
5022: ppd.resource_assignment_id, /* use the existing resource_assignment_id */

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

5015: select
5016: SYSDATE, /* creation_date */
5017: FND_GLOBAL.user_id, /* created_by */
5018: FND_GLOBAL.login_id, /* last_update_login */
5019: FND_GLOBAL.user_id, /* last_updated_by */
5020: SYSDATE, /* last_update_date */
5021: p_target_version_id, /* use newly-created budget_version_id */
5022: ppd.resource_assignment_id, /* use the existing resource_assignment_id */
5023: l_forecast_element_id, /* object_id is the newly-created forecast_element_id */

Line 6117: p_request_id => FND_GLOBAL.conc_request_id,

6113: p_total_capacity => NULL,
6114: p_total_head_count => NULL,
6115: p_total_head_count_adj => NULL,
6116: p_version_type => new_version_info_rec.version_type,
6117: p_request_id => FND_GLOBAL.conc_request_id,
6118: p_total_project_raw_cost => NULL,
6119: p_total_project_burdened_cost => NULL,
6120: p_total_project_revenue => NULL,
6121: p_locked_by_person_id => NULL,

Line 6617: ,last_updated_by = FND_GLOBAL.user_id

6613: SET rbs_element_id = l_rbs_element_id_tbl(j)
6614: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6615: ,record_version_number = record_version_number + 1
6616: ,last_update_date = SYSDATE
6617: ,last_updated_by = FND_GLOBAL.user_id
6618: ,last_update_login = FND_GLOBAL.login_id
6619: WHERE budget_version_id = l_new_budget_version_id
6620: AND resource_assignment_id = l_txn_source_id_tbl(j);
6621: END IF;

Line 6618: ,last_update_login = FND_GLOBAL.login_id

6614: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6615: ,record_version_number = record_version_number + 1
6616: ,last_update_date = SYSDATE
6617: ,last_updated_by = FND_GLOBAL.user_id
6618: ,last_update_login = FND_GLOBAL.login_id
6619: WHERE budget_version_id = l_new_budget_version_id
6620: AND resource_assignment_id = l_txn_source_id_tbl(j);
6621: END IF;
6622: ELSE -- rbs version id is null

Line 6630: ,last_updated_by = FND_GLOBAL.user_id

6626: SET rbs_element_id = null
6627: ,txn_accum_header_id = null
6628: ,record_version_number = record_version_number + 1
6629: ,last_update_date = SYSDATE
6630: ,last_updated_by = FND_GLOBAL.user_id
6631: ,last_update_login = FND_GLOBAL.login_id
6632: WHERE budget_version_id = l_new_budget_version_id;
6633:
6634: END IF;

Line 6631: ,last_update_login = FND_GLOBAL.login_id

6627: ,txn_accum_header_id = null
6628: ,record_version_number = record_version_number + 1
6629: ,last_update_date = SYSDATE
6630: ,last_updated_by = FND_GLOBAL.user_id
6631: ,last_update_login = FND_GLOBAL.login_id
6632: WHERE budget_version_id = l_new_budget_version_id;
6633:
6634: END IF;
6635: END IF;