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.

[Home] [Help]

APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_COSTS

Line 4831: UPDATE PSB_POSITION_COSTS

4827: -- 4545590
4828: IF NOT g_wks_new_hr_budget THEN
4829:
4830: FORALL i IN 1..l_count_costs
4831: UPDATE PSB_POSITION_COSTS
4832: SET element_cost = l_cost_element_cost(i),
4833: last_update_date = sysdate,
4834: last_updated_by = FND_GLOBAL.USER_ID,
4835: last_update_login = FND_GLOBAL.LOGIN_ID

Line 5070: UPDATE PSB_POSITION_COSTS

5066: -- for bug 4545590
5067: IF NOT g_wks_new_hr_budget THEN
5068:
5069: FORALL i IN 1..l_count_costs
5070: UPDATE PSB_POSITION_COSTS
5071: SET element_cost = l_cost_element_cost(i),
5072: last_update_date = sysdate,
5073: last_updated_by = FND_GLOBAL.USER_ID,
5074: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6839: insert into PSB_POSITION_COSTS

6835: l_position_element_line_id NUMBER;
6836:
6837: BEGIN
6838:
6839: insert into PSB_POSITION_COSTS
6840: (position_element_line_id, position_id, hr_budget_id, pay_element_id, budget_revision_id,
6841: base_line_version, currency_code, start_date, end_date,
6842: element_cost, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6843: values (PSB_POSITION_COSTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_pay_element_id, p_budget_revision_id,

Line 6843: values (PSB_POSITION_COSTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_pay_element_id, p_budget_revision_id,

6839: insert into PSB_POSITION_COSTS
6840: (position_element_line_id, position_id, hr_budget_id, pay_element_id, budget_revision_id,
6841: base_line_version, currency_code, start_date, end_date,
6842: element_cost, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6843: values (PSB_POSITION_COSTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_pay_element_id, p_budget_revision_id,
6844: p_base_line_version, p_currency_code, p_start_date, p_end_date,
6845: p_element_cost, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
6846: RETURNING position_element_line_id INTO l_position_element_line_id;
6847:

Line 6893: update PSB_POSITION_COSTS

6889: l_api_name CONSTANT VARCHAR2(30) := 'Update_Position_Costs';
6890:
6891: BEGIN
6892:
6893: update PSB_POSITION_COSTS
6894: set element_cost = p_element_cost,
6895: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6896: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
6897: last_update_date = sysdate,

Line 6947: delete from PSB_POSITION_COSTS

6943: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Position_Costs';
6944:
6945: BEGIN
6946:
6947: delete from PSB_POSITION_COSTS
6948: where position_element_line_id = p_position_element_line_id;
6949:
6950: -- Initialize API return status to success
6951: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7019: from PSB_POSITION_COSTS

7015: /*For Bug No : 1808322 End*/
7016:
7017: cursor c_Overlap is
7018: select *
7019: from PSB_POSITION_COSTS
7020: where position_id = p_position_id
7021: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7022: and pay_element_id = p_pay_element_id
7023: and currency_code = p_currency_code

Line 7057: update PSB_POSITION_COSTS

7053:
7054: /*For Bug No : 1808322 Start*/
7055: IF p_budget_revision_id IS NOT null THEN
7056: /*For Bug No : 1808322 End*/
7057: update PSB_POSITION_COSTS
7058: set element_cost = p_element_cost,
7059: last_update_date = sysdate,
7060: last_updated_by = FND_GLOBAL.USER_ID,
7061: last_update_login = FND_GLOBAL.LOGIN_ID

Line 8567: psb_position_costs ppc,

8563:
8564: cursor c_Element_Costs is
8565: select ppe.pay_element_id, ppe.budget_set_id, sum(nvl(ppc.element_cost,0)) element_cost
8566: from psb_pay_elements ppe,
8567: psb_position_costs ppc,
8568: psb_positions pp
8569: where ppe.data_extract_id = p_data_extract_id
8570: and ppc.pay_element_id = ppe.pay_element_id
8571: and pp.data_extract_id = p_data_extract_id

Line 9424: from psb_positions pp, psb_position_costs ppc

9420: and date_to = p_end_date;
9421:
9422: cursor c_total_cost_bp is
9423: select sum(ppc.element_cost) total_cost
9424: from psb_positions pp, psb_position_costs ppc
9425: where pp.data_extract_id = p_system_data_extract_id
9426: and exists
9427: (select 'Exists'
9428: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

Line 10176: from psb_position_costs ppc, psb_positions pp

10172: or ((ppf.start_date < p_start_date) and (ppf.end_date > p_end_date)))
10173: group by ppf.start_date, ppf.end_date
10174: ) a,
10175: (select ppc.start_date, ppc.end_date, sum(ppc.element_cost) cost
10176: from psb_position_costs ppc, psb_positions pp
10177: where pp.data_extract_id = p_system_data_extract_id
10178: and pp.hr_position_id = p_hr_position_id
10179: and ppc.position_id = pp.position_id
10180: and ppc.hr_budget_id = p_hr_budget_id

Line 10220: psb_position_costs ppc,

10216: cursor c_budget_set_cost (startdate DATE, enddate DATE) is
10217: select ppe.budget_set_id hr_budget_set_id,
10218: sum(nvl(ppc.element_cost,0)) budget_set_cost
10219: from psb_pay_elements ppe,
10220: psb_position_costs ppc,
10221: psb_positions pp
10222: where ppe.data_extract_id = p_system_data_extract_id
10223: and pp.hr_position_id = p_hr_position_id
10224: and pp.data_extract_id = p_system_data_extract_id

Line 10853: from psb_position_costs ppc, psb_positions pp

10849: group by pp.hr_position_id
10850: ) a,
10851: (
10852: select pp.hr_position_id cost_position_id, sum(ppc.element_cost) cost
10853: from psb_position_costs ppc, psb_positions pp
10854: where pp.data_extract_id = p_system_data_extract_id
10855: and ppc.hr_budget_id = p_hr_budget_id
10856: and ppc.position_id = pp.position_id
10857: and ppc.base_line_version = 'C'