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

Line 659: ,fnd_global.user_id

655: ,plannable_flag /* Same as plannable_flag */
656: ,top_task_planning_level /* Same as top_task_planning_level */
657: ,1
658: ,sysdate
659: ,fnd_global.user_id
660: ,sysdate
661: ,fnd_global.user_id
662: ,fnd_global.login_id
663: FROM pa_fp_elements

Line 661: ,fnd_global.user_id

657: ,1
658: ,sysdate
659: ,fnd_global.user_id
660: ,sysdate
661: ,fnd_global.user_id
662: ,fnd_global.login_id
663: FROM pa_fp_elements
664: WHERE proj_fp_options_id = l_from_proj_fp_option_id
665: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type)

Line 662: ,fnd_global.login_id

658: ,sysdate
659: ,fnd_global.user_id
660: ,sysdate
661: ,fnd_global.user_id
662: ,fnd_global.login_id
663: FROM pa_fp_elements
664: WHERE proj_fp_options_id = l_from_proj_fp_option_id
665: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type)
666: AND NVL(plan_amount_exists_flag,'N') = decode(p_copy_mode,PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED,'Y',NVL(plan_amount_exists_flag,'N')); /* Bug 2920954 */

Line 719: ,fnd_global.user_id

715: ,plannable_flag /* Same as plannable_flag */
716: ,top_task_planning_level /* Same as top_task_planning_level */
717: ,1
718: ,sysdate
719: ,fnd_global.user_id
720: ,sysdate
721: ,fnd_global.user_id
722: ,fnd_global.login_id
723: FROM pa_fp_elements fp,

Line 721: ,fnd_global.user_id

717: ,1
718: ,sysdate
719: ,fnd_global.user_id
720: ,sysdate
721: ,fnd_global.user_id
722: ,fnd_global.login_id
723: FROM pa_fp_elements fp,
724: pa_tasks source_pt,
725: pa_tasks target_pt

Line 722: ,fnd_global.login_id

718: ,sysdate
719: ,fnd_global.user_id
720: ,sysdate
721: ,fnd_global.user_id
722: ,fnd_global.login_id
723: FROM pa_fp_elements fp,
724: pa_tasks source_pt,
725: pa_tasks target_pt
726: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id

Line 806: ,fnd_global.user_id

802: ,plannable_flag /* Same as plannable_flag */
803: ,top_task_planning_level /* Same as top_task_planning_level */
804: ,1
805: ,sysdate
806: ,fnd_global.user_id
807: ,sysdate
808: ,fnd_global.user_id
809: ,fnd_global.login_id
810: FROM pa_fp_elements fp

Line 808: ,fnd_global.user_id

804: ,1
805: ,sysdate
806: ,fnd_global.user_id
807: ,sysdate
808: ,fnd_global.user_id
809: ,fnd_global.login_id
810: FROM pa_fp_elements fp
811: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id
812: AND fp.task_id = 0

Line 809: ,fnd_global.login_id

805: ,sysdate
806: ,fnd_global.user_id
807: ,sysdate
808: ,fnd_global.user_id
809: ,fnd_global.login_id
810: FROM pa_fp_elements fp
811: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id
812: AND fp.task_id = 0
813: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type);

Line 1274: ,fnd_global.user_id

1270: ,l_plannable_flag_tbl(i) -- Same as plannable_flag
1271: ,l_top_plan_level_tbl(i) -- Same as top_task_planning_level
1272: ,1
1273: ,sysdate
1274: ,fnd_global.user_id
1275: ,sysdate
1276: ,fnd_global.user_id
1277: ,fnd_global.login_id);
1278:

Line 1276: ,fnd_global.user_id

1272: ,1
1273: ,sysdate
1274: ,fnd_global.user_id
1275: ,sysdate
1276: ,fnd_global.user_id
1277: ,fnd_global.login_id);
1278:
1279: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': inserted ' || sql%rowcount || ' records';
1280: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1277: ,fnd_global.login_id);

1273: ,sysdate
1274: ,fnd_global.user_id
1275: ,sysdate
1276: ,fnd_global.user_id
1277: ,fnd_global.login_id);
1278:
1279: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': inserted ' || sql%rowcount || ' records';
1280: IF P_PA_DEBUG_MODE = 'Y' THEN
1281: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1359: ,fnd_global.user_id

1355: ,l_plannable_flag_tbl(i) -- Same as plannable_flag
1356: ,l_top_plan_level_tbl(i) -- Same as top_task_planning_level
1357: ,1
1358: ,sysdate
1359: ,fnd_global.user_id
1360: ,sysdate
1361: ,fnd_global.user_id
1362: ,fnd_global.login_id);
1363:

Line 1361: ,fnd_global.user_id

1357: ,1
1358: ,sysdate
1359: ,fnd_global.user_id
1360: ,sysdate
1361: ,fnd_global.user_id
1362: ,fnd_global.login_id);
1363:
1364: END IF;
1365:

Line 1362: ,fnd_global.login_id);

1358: ,sysdate
1359: ,fnd_global.user_id
1360: ,sysdate
1361: ,fnd_global.user_id
1362: ,fnd_global.login_id);
1363:
1364: END IF;
1365:
1366: EXIT WHEN nvl(l_task_id_tbl.last,0) < l_plsql_max_array_size;

Line 1658: last_updated_by = FND_GLOBAL.USER_ID,

1654: update pa_fp_elements
1655: set plan_amount_exists_flag = 'N',
1656: record_version_number = record_version_number + 1,
1657: last_update_date = sysdate,
1658: last_updated_by = FND_GLOBAL.USER_ID,
1659: last_update_login = FND_GLOBAL.LOGIN_ID
1660: where proj_fp_options_id = l_proj_fp_options_id
1661: and task_id = l_top_task_id
1662: and not exists

Line 1659: last_update_login = FND_GLOBAL.LOGIN_ID

1655: set plan_amount_exists_flag = 'N',
1656: record_version_number = record_version_number + 1,
1657: last_update_date = sysdate,
1658: last_updated_by = FND_GLOBAL.USER_ID,
1659: last_update_login = FND_GLOBAL.LOGIN_ID
1660: where proj_fp_options_id = l_proj_fp_options_id
1661: and task_id = l_top_task_id
1662: and not exists
1663: (

Line 1704: last_updated_by = FND_GLOBAL.USER_ID,

1700: update pa_fp_elements
1701: set plan_amount_exists_flag = 'N',
1702: record_version_number = record_version_number + 1,
1703: last_update_date = sysdate,
1704: last_updated_by = FND_GLOBAL.USER_ID,
1705: last_update_login = FND_GLOBAL.LOGIN_ID
1706: where proj_fp_options_id = l_proj_fp_options_id
1707: and resource_list_member_id = 0
1708: and task_id = p_task_id

Line 1705: last_update_login = FND_GLOBAL.LOGIN_ID

1701: set plan_amount_exists_flag = 'N',
1702: record_version_number = record_version_number + 1,
1703: last_update_date = sysdate,
1704: last_updated_by = FND_GLOBAL.USER_ID,
1705: last_update_login = FND_GLOBAL.LOGIN_ID
1706: where proj_fp_options_id = l_proj_fp_options_id
1707: and resource_list_member_id = 0
1708: and task_id = p_task_id
1709: and not exists

Line 1732: last_updated_by = FND_GLOBAL.USER_ID,

1728: update pa_fp_elements
1729: set plan_amount_exists_flag = 'N',
1730: record_version_number = record_version_number + 1,
1731: last_update_date = sysdate,
1732: last_updated_by = FND_GLOBAL.USER_ID,
1733: last_update_login = FND_GLOBAL.LOGIN_ID
1734: where proj_fp_options_id = l_proj_fp_options_id
1735: and resource_list_member_id = 0
1736: and task_id = l_top_task_id

Line 1733: last_update_login = FND_GLOBAL.LOGIN_ID

1729: set plan_amount_exists_flag = 'N',
1730: record_version_number = record_version_number + 1,
1731: last_update_date = sysdate,
1732: last_updated_by = FND_GLOBAL.USER_ID,
1733: last_update_login = FND_GLOBAL.LOGIN_ID
1734: where proj_fp_options_id = l_proj_fp_options_id
1735: and resource_list_member_id = 0
1736: and task_id = l_top_task_id
1737: and not exists

Line 1790: last_updated_by = FND_GLOBAL.USER_ID,

1786: UPDATE pa_fp_elements
1787: SET resources_planned_for_task = 'N',
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 proj_fp_options_id = l_proj_fp_options_id
1793: AND task_id = p_task_id
1794: AND resource_list_member_id = 0;

Line 1791: last_update_login = FND_GLOBAL.LOGIN_ID

1787: SET resources_planned_for_task = 'N',
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 proj_fp_options_id = l_proj_fp_options_id
1793: AND task_id = p_task_id
1794: AND resource_list_member_id = 0;
1795: END IF;

Line 1930: ,fnd_global.user_id

1926: ,p_plannable_flag_tbl(i)
1927: ,p_task_planning_level_tbl(i)
1928: ,1
1929: ,sysdate
1930: ,fnd_global.user_id
1931: ,sysdate
1932: ,fnd_global.user_id
1933: ,fnd_global.login_id);
1934:

Line 1932: ,fnd_global.user_id

1928: ,1
1929: ,sysdate
1930: ,fnd_global.user_id
1931: ,sysdate
1932: ,fnd_global.user_id
1933: ,fnd_global.login_id);
1934:
1935: pa_debug.reset_err_stack;
1936: EXCEPTION

Line 1933: ,fnd_global.login_id);

1929: ,sysdate
1930: ,fnd_global.user_id
1931: ,sysdate
1932: ,fnd_global.user_id
1933: ,fnd_global.login_id);
1934:
1935: pa_debug.reset_err_stack;
1936: EXCEPTION
1937: WHEN OTHERS THEN

Line 2032: ,fnd_global.user_id -- LAST_UPDATED_BY

2028: ,p_project_id -- PROJECT_ID
2029: ,p_task_id_tbl(i) -- TASK_ID
2030: ,p_res_list_mem_id_tbl(i) -- RESOURCE_LIST_MEMBER_ID
2031: ,sysdate -- LAST_UPDATE_DATE
2032: ,fnd_global.user_id -- LAST_UPDATED_BY
2033: ,sysdate -- CREATION_DATE
2034: ,fnd_global.user_id -- CREATED_BY
2035: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
2036: ,p_unit_of_measure_tbl(i) -- UNIT_OF_MEASURE

Line 2034: ,fnd_global.user_id -- CREATED_BY

2030: ,p_res_list_mem_id_tbl(i) -- RESOURCE_LIST_MEMBER_ID
2031: ,sysdate -- LAST_UPDATE_DATE
2032: ,fnd_global.user_id -- LAST_UPDATED_BY
2033: ,sysdate -- CREATION_DATE
2034: ,fnd_global.user_id -- CREATED_BY
2035: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
2036: ,p_unit_of_measure_tbl(i) -- UNIT_OF_MEASURE
2037: ,p_track_as_labor_flag_tbl(i) -- TRACK_AS_LABOR_FLAG
2038: ,-1 -- PROJECT_ASSIGNMENT_ID

Line 2035: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

2031: ,sysdate -- LAST_UPDATE_DATE
2032: ,fnd_global.user_id -- LAST_UPDATED_BY
2033: ,sysdate -- CREATION_DATE
2034: ,fnd_global.user_id -- CREATED_BY
2035: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
2036: ,p_unit_of_measure_tbl(i) -- UNIT_OF_MEASURE
2037: ,p_track_as_labor_flag_tbl(i) -- TRACK_AS_LABOR_FLAG
2038: ,-1 -- PROJECT_ASSIGNMENT_ID
2039: ,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) ; -- RESOURCE_ASSIGNMENT_TYPE

Line 3532: ,last_updated_by = FND_GLOBAL.USER_ID

3528: SET resource_planning_level = l_res_planning_level
3529: ,resources_planned_for_task = 'N'
3530: ,record_version_number = record_version_number + 1
3531: ,last_update_date = sysdate
3532: ,last_updated_by = FND_GLOBAL.USER_ID
3533: ,last_update_login = FND_GLOBAL.LOGIN_ID
3534: WHERE proj_fp_options_id = p_proj_fp_options_id
3535: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
3536: END IF; /* Bug 2920954 */

Line 3533: ,last_update_login = FND_GLOBAL.LOGIN_ID

3529: ,resources_planned_for_task = 'N'
3530: ,record_version_number = record_version_number + 1
3531: ,last_update_date = sysdate
3532: ,last_updated_by = FND_GLOBAL.USER_ID
3533: ,last_update_login = FND_GLOBAL.LOGIN_ID
3534: WHERE proj_fp_options_id = p_proj_fp_options_id
3535: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
3536: END IF; /* Bug 2920954 */
3537: END IF;

Line 3619: ,last_updated_by = FND_GLOBAL.USER_ID

3615: SET resource_planning_level = l_res_planning_level
3616: ,resources_planned_for_task = 'N' --for bug 2676456
3617: ,record_version_number = record_version_number + 1
3618: ,last_update_date = sysdate
3619: ,last_updated_by = FND_GLOBAL.USER_ID
3620: ,last_update_login = FND_GLOBAL.LOGIN_ID
3621: WHERE proj_fp_options_id = p_proj_fp_options_id
3622: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
3623: END IF; /* Bug 2920954 */

Line 3620: ,last_update_login = FND_GLOBAL.LOGIN_ID

3616: ,resources_planned_for_task = 'N' --for bug 2676456
3617: ,record_version_number = record_version_number + 1
3618: ,last_update_date = sysdate
3619: ,last_updated_by = FND_GLOBAL.USER_ID
3620: ,last_update_login = FND_GLOBAL.LOGIN_ID
3621: WHERE proj_fp_options_id = p_proj_fp_options_id
3622: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
3623: END IF; /* Bug 2920954 */
3624:

Line 3706: ,last_updated_by = FND_GLOBAL.USER_ID

3702: SET resource_planning_level = l_res_planning_level
3703: ,resources_planned_for_task = 'N' --for bug 2676456
3704: ,record_version_number = record_version_number + 1
3705: ,last_update_date = sysdate
3706: ,last_updated_by = FND_GLOBAL.USER_ID
3707: ,last_update_login = FND_GLOBAL.LOGIN_ID
3708: WHERE proj_fp_options_id = p_proj_fp_options_id
3709: AND element_type = p_element_type;
3710: END IF; /* Bug 2920954 */

Line 3707: ,last_update_login = FND_GLOBAL.LOGIN_ID

3703: ,resources_planned_for_task = 'N' --for bug 2676456
3704: ,record_version_number = record_version_number + 1
3705: ,last_update_date = sysdate
3706: ,last_updated_by = FND_GLOBAL.USER_ID
3707: ,last_update_login = FND_GLOBAL.LOGIN_ID
3708: WHERE proj_fp_options_id = p_proj_fp_options_id
3709: AND element_type = p_element_type;
3710: END IF; /* Bug 2920954 */
3711:

Line 4961: ,fnd_global.user_id

4957: ,'Y' -- tmp_plannable_flag
4958: ,NULL -- tmp_top_task_planning_level
4959: ,1 -- record_version_number
4960: ,sysdate
4961: ,fnd_global.user_id
4962: ,sysdate
4963: ,fnd_global.user_id
4964: ,fnd_global.login_id);
4965: END LOOP;

Line 4963: ,fnd_global.user_id

4959: ,1 -- record_version_number
4960: ,sysdate
4961: ,fnd_global.user_id
4962: ,sysdate
4963: ,fnd_global.user_id
4964: ,fnd_global.login_id);
4965: END LOOP;
4966:
4967: -- Bulk update all the task records to reflect that resources selection is done

Line 4964: ,fnd_global.login_id);

4960: ,sysdate
4961: ,fnd_global.user_id
4962: ,sysdate
4963: ,fnd_global.user_id
4964: ,fnd_global.login_id);
4965: END LOOP;
4966:
4967: -- Bulk update all the task records to reflect that resources selection is done
4968:

Line 4982: ,last_updated_by = FND_GLOBAL.USER_ID

4978: SET resources_planned_for_task = 'Y'
4979: ,resource_planning_level = p_res_planning_level
4980: ,record_version_number = record_version_number + 1
4981: ,last_update_date = sysdate
4982: ,last_updated_by = FND_GLOBAL.USER_ID
4983: ,last_update_login = FND_GLOBAL.LOGIN_ID
4984: WHERE proj_fp_options_id = p_proj_fp_options_id
4985: AND element_type = p_element_type
4986: AND task_id = l_task_id_tbl(l_task_tbl_index)

Line 4983: ,last_update_login = FND_GLOBAL.LOGIN_ID

4979: ,resource_planning_level = p_res_planning_level
4980: ,record_version_number = record_version_number + 1
4981: ,last_update_date = sysdate
4982: ,last_updated_by = FND_GLOBAL.USER_ID
4983: ,last_update_login = FND_GLOBAL.LOGIN_ID
4984: WHERE proj_fp_options_id = p_proj_fp_options_id
4985: AND element_type = p_element_type
4986: AND task_id = l_task_id_tbl(l_task_tbl_index)
4987: AND resource_list_member_id = 0;

Line 5815: last_updated_by = FND_GLOBAL.USER_ID,

5811: pfe.tmp_plannable_flag = 'N',
5812: pfe.resources_planned_for_task = Null,
5813: pfe.record_version_number = pfe.record_version_number + 1,
5814: last_update_date = sysdate,
5815: last_updated_by = FND_GLOBAL.USER_ID,
5816: last_update_login = FND_GLOBAL.LOGIN_ID
5817: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id
5818: AND pfe.element_type = p_element_type
5819: AND pfe.task_id = p_tasks_tbl(i).parent_task_id

Line 5816: last_update_login = FND_GLOBAL.LOGIN_ID

5812: pfe.resources_planned_for_task = Null,
5813: pfe.record_version_number = pfe.record_version_number + 1,
5814: last_update_date = sysdate,
5815: last_updated_by = FND_GLOBAL.USER_ID,
5816: last_update_login = FND_GLOBAL.LOGIN_ID
5817: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id
5818: AND pfe.element_type = p_element_type
5819: AND pfe.task_id = p_tasks_tbl(i).parent_task_id
5820: AND pfe.resource_list_member_id = 0;

Line 5896: ,FND_GLOBAL.USER_ID

5892: ,l_task_plannable_flag -- tmp_plannable_flag
5893: ,l_top_task_planning_level -- tmp_top_task_planning_level
5894: ,1
5895: ,SYSDATE
5896: ,FND_GLOBAL.USER_ID
5897: ,SYSDATE
5898: ,FND_GLOBAL.USER_ID
5899: ,FND_GLOBAL.LOGIN_ID);
5900:

Line 5898: ,FND_GLOBAL.USER_ID

5894: ,1
5895: ,SYSDATE
5896: ,FND_GLOBAL.USER_ID
5897: ,SYSDATE
5898: ,FND_GLOBAL.USER_ID
5899: ,FND_GLOBAL.LOGIN_ID);
5900:
5901: IF proj_fp_options_rec.auto_res_selection_flag = 'Y' THEN
5902:

Line 5899: ,FND_GLOBAL.LOGIN_ID);

5895: ,SYSDATE
5896: ,FND_GLOBAL.USER_ID
5897: ,SYSDATE
5898: ,FND_GLOBAL.USER_ID
5899: ,FND_GLOBAL.LOGIN_ID);
5900:
5901: IF proj_fp_options_rec.auto_res_selection_flag = 'Y' THEN
5902:
5903: /* We should be adding resources only if p_task_id is a plannable task record.

Line 7167: pfo.last_updated_by = FND_GLOBAL.USER_ID,

7163: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last
7164: UPDATE pa_proj_fp_options pfo
7165: SET pfo.record_version_number = pfo.record_version_number + 1,
7166: pfo.last_update_date = sysdate,
7167: pfo.last_updated_by = FND_GLOBAL.USER_ID,
7168: pfo.last_update_login = FND_GLOBAL.LOGIN_ID
7169: WHERE pfo.proj_fp_options_id = l_all_fp_options_tbl(i);
7170:
7171: /* Since resource assignments might have been deleted and recreated

Line 7168: pfo.last_update_login = FND_GLOBAL.LOGIN_ID

7164: UPDATE pa_proj_fp_options pfo
7165: SET pfo.record_version_number = pfo.record_version_number + 1,
7166: pfo.last_update_date = sysdate,
7167: pfo.last_updated_by = FND_GLOBAL.USER_ID,
7168: pfo.last_update_login = FND_GLOBAL.LOGIN_ID
7169: WHERE pfo.proj_fp_options_id = l_all_fp_options_tbl(i);
7170:
7171: /* Since resource assignments might have been deleted and recreated
7172: for the new task, the version has been modified and its

Line 7179: bv.last_updated_by = FND_GLOBAL.USER_ID,

7175: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last
7176: UPDATE pa_budget_versions bv
7177: SET bv.record_version_number = bv.record_version_number + 1,
7178: bv.last_update_date = sysdate,
7179: bv.last_updated_by = FND_GLOBAL.USER_ID,
7180: bv.last_update_login = FND_GLOBAL.LOGIN_ID
7181: WHERE bv.budget_version_id in (SELECT pfo.fin_plan_version_id
7182: FROM pa_proj_fp_options pfo
7183: WHERE pfo.proj_fp_options_id = l_all_fp_options_tbl(i));

Line 7180: bv.last_update_login = FND_GLOBAL.LOGIN_ID

7176: UPDATE pa_budget_versions bv
7177: SET bv.record_version_number = bv.record_version_number + 1,
7178: bv.last_update_date = sysdate,
7179: bv.last_updated_by = FND_GLOBAL.USER_ID,
7180: bv.last_update_login = FND_GLOBAL.LOGIN_ID
7181: WHERE bv.budget_version_id in (SELECT pfo.fin_plan_version_id
7182: FROM pa_proj_fp_options pfo
7183: WHERE pfo.proj_fp_options_id = l_all_fp_options_tbl(i));
7184: