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.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_FTE

Line 4762: UPDATE PSB_POSITION_FTE

4758: -- for bug 4545590
4759: IF NOT g_wks_new_hr_budget THEN
4760:
4761: FORALL i IN 1..l_count_fte
4762: UPDATE PSB_POSITION_FTE
4763: SET fte =l_fte_fte(i),
4764: last_update_date = sysdate,
4765: last_updated_by = FND_GLOBAL.USER_ID,
4766: last_update_login = FND_GLOBAL.LOGIN_ID

Line 5000: UPDATE PSB_POSITION_FTE

4996: -- for bug 4545590
4997: IF NOT g_wks_new_hr_budget THEN
4998:
4999: FORALL i IN 1..l_count_fte
5000: UPDATE PSB_POSITION_FTE
5001: SET fte = l_fte_fte(i),
5002: last_update_date = sysdate,
5003: last_updated_by = FND_GLOBAL.USER_ID,
5004: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7418: insert into PSB_POSITION_FTE

7414:
7415: BEGIN
7416:
7417:
7418: insert into PSB_POSITION_FTE
7419: (position_fte_line_id, position_id, hr_budget_id, budget_revision_id, base_line_version,
7420: start_date, end_date, fte, last_update_date, last_updated_by, last_update_login,
7421: created_by, creation_date)
7422: VALUES (PSB_POSITION_FTE_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_base_line_version,

Line 7422: VALUES (PSB_POSITION_FTE_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_base_line_version,

7418: insert into PSB_POSITION_FTE
7419: (position_fte_line_id, position_id, hr_budget_id, budget_revision_id, base_line_version,
7420: start_date, end_date, fte, last_update_date, last_updated_by, last_update_login,
7421: created_by, creation_date)
7422: VALUES (PSB_POSITION_FTE_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_base_line_version,
7423: p_start_date, p_end_date, nvl(p_fte, 0), sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
7424: FND_GLOBAL.USER_ID, sysdate) RETURNING position_fte_line_id INTO l_position_fte_line_id;
7425:
7426: -- Initialize API return status to success

Line 7474: update PSB_POSITION_FTE

7470: l_api_name CONSTANT VARCHAR2(30) := 'Update_Position_FTE';
7471:
7472: BEGIN
7473:
7474: update PSB_POSITION_FTE
7475: set fte = nvl(p_fte, 0),
7476: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
7477: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
7478: last_update_date = sysdate,

Line 7528: delete from PSB_POSITION_FTE

7524: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Position_FTE';
7525:
7526: BEGIN
7527:
7528: delete from PSB_POSITION_FTE
7529: where position_fte_line_id = p_position_fte_line_id;
7530:
7531: -- Initialize API return status to success
7532: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7598: from PSB_POSITION_FTE

7594: l_return_status VARCHAR2(1);
7595:
7596: cursor c_Overlap is
7597: select *
7598: from PSB_POSITION_FTE
7599: where position_id = p_position_id
7600: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7601: and nvl(budget_revision_id, -1) = nvl(p_budget_revision_id, -1)
7602: and nvl(base_line_version, FND_API.G_MISS_CHAR) = nvl(p_base_line_version, FND_API.G_MISS_CHAR)

Line 7635: update PSB_POSITION_FTE

7631: /*For Bug No : 1808322 Start*/
7632: IF p_budget_revision_id IS NOT null THEN
7633: /*For Bug No : 1808322 End*/
7634:
7635: update PSB_POSITION_FTE
7636: set fte = nvl(p_fte, 0),
7637: last_update_date = sysdate,
7638: last_updated_by = FND_GLOBAL.USER_ID,
7639: last_update_login = FND_GLOBAL.LOGIN_ID

Line 9454: from psb_positions pp, psb_position_fte ppf

9450: and b.position_id is not null;
9451:
9452: cursor c_total_fte_bp is
9453: select sum(avg(ppf.fte)) total_fte
9454: from psb_positions pp, psb_position_fte ppf
9455: where pp.data_extract_id = p_system_data_extract_id
9456: and exists
9457: (select 'Exists'
9458: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

Line 10162: from psb_position_fte ppf,

10158: (
10159: select ppf.start_date,
10160: ppf.end_date,
10161: sum(ppf.fte) fte
10162: from psb_position_fte ppf,
10163: psb_positions pp
10164: where pp.data_extract_id = p_system_data_extract_id
10165: and pp.hr_position_id = p_hr_position_id
10166: and ppf.position_id = pp.position_id

Line 10839: from psb_positions pp, psb_position_fte ppf

10835: (
10836: select pp.hr_position_id fte_position_id, sum(avg_fte) fte
10837: from
10838: (select pp.position_id, avg(ppf.fte) avg_fte
10839: from psb_positions pp, psb_position_fte ppf
10840: where ppf.position_id = pp.position_id
10841: and ppf.base_line_version = 'C'
10842: and ppf.hr_budget_id = p_hr_budget_id
10843: and ((ppf.start_date between p_start_date and p_end_date)

Line 11625: from psb_position_fte

11621: /*For Bug No : 2292003 End*/
11622:
11623: cursor c_revision_dates is
11624: select min(start_date) start_date, max(end_date) end_date
11625: from psb_position_fte
11626: where budget_revision_id = p_source_id
11627: and hr_budget_id = p_hr_budget_id;
11628:
11629: BEGIN