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_WS_OPS_PVT dependencies on PSB_WS_FTE_LINES

Line 1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;

1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
1478: l_new_position_assignment_id
1479: psb_position_assignments.position_assignment_id%TYPE ;
1480: l_rowid VARCHAR2(2000);

Line 1667: -- The related rows in psb_ws_fte_lines and psb_ws_element_lines will

1663:
1664: --
1665: -- We need to find all the position_line_id for the worksheet and each of
1666: -- the position_line_id needs to be copied in psb_ws_position_lines table.
1667: -- The related rows in psb_ws_fte_lines and psb_ws_element_lines will
1668: -- also be copied and assigned new position_line_id as created in the
1669: -- psb_ws_position_lines table.
1670: --
1671:

Line 1757: -- Copy each record in psb_ws_fte_lines table for the current

1753: ) ;
1754: */
1755:
1756: --
1757: -- Copy each record in psb_ws_fte_lines table for the current
1758: -- l_lines_pos_rec.position_line_id. The new l_new_position_line_id
1759: -- will replace the position_line_id column in new created records.
1760: --
1761: FOR l_fte_rec IN

Line 1764: FROM psb_ws_fte_lines

1760: --
1761: FOR l_fte_rec IN
1762: (
1763: SELECT *
1764: FROM psb_ws_fte_lines
1765: WHERE position_line_id = l_lines_pos_rec.position_line_id
1766: )
1767: LOOP
1768:

Line 1833: -- API to create new fte lines in psb_ws_fte_lines.

1829: l_period_fte_tbl(58) := l_fte_rec.period58_fte ;
1830: l_period_fte_tbl(59) := l_fte_rec.period59_fte ;
1831: l_period_fte_tbl(60) := l_fte_rec.period60_fte ;
1832:
1833: -- API to create new fte lines in psb_ws_fte_lines.
1834: PSB_WS_Pos_Pvt.Create_FTE_Lines
1835: (
1836: p_api_version => 1.0 ,
1837: p_init_msg_list => FND_API.G_FALSE ,

Line 2073: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;

2069: l_target_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2070: l_target_position_id psb_ws_position_lines.position_id%TYPE;
2071: --
2072: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2073: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
2074: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
2075: l_new_position_assignment_id
2076: psb_position_assignments.position_assignment_id%TYPE ;
2077: l_rowid VARCHAR2(2000);

Line 2541: -- Create new records in psb_ws_fte_lines table for each occurance of

2537: END IF;
2538:
2539:
2540: --
2541: -- Create new records in psb_ws_fte_lines table for each occurance of
2542: -- l_lines_pos_rec.position_line_id. The new l_new_position_line_id
2543: -- will replace the position_line_id column in new created records.
2544: --
2545: FOR l_fte_rec IN

Line 2548: FROM psb_ws_fte_lines

2544: --
2545: FOR l_fte_rec IN
2546: (
2547: SELECT *
2548: FROM psb_ws_fte_lines
2549: WHERE position_line_id = l_lines_pos_rec.position_line_id
2550: )
2551: LOOP
2552:

Line 2617: -- API to create new fte lines in psb_ws_fte_lines.

2613: l_period_fte_tbl(58) := l_fte_rec.period58_fte ;
2614: l_period_fte_tbl(59) := l_fte_rec.period59_fte ;
2615: l_period_fte_tbl(60) := l_fte_rec.period60_fte ;
2616:
2617: -- API to create new fte lines in psb_ws_fte_lines.
2618: PSB_WS_Pos_Pvt.Create_FTE_Lines
2619: (
2620: p_api_version => 1.0 ,
2621: p_init_msg_list => FND_API.G_FALSE ,

Line 2998: -- Wipe out records in psb_ws_fte_lines related to the original line

2994: END LOOP ;
2995: /*For Bug No : 2534088 End*/
2996:
2997: --
2998: -- Wipe out records in psb_ws_fte_lines related to the original line
2999: -- l_target_position_line_id and create new records from the local
3000: -- l_lines_pos_rec.position_line_id . The l_target_position_line_id
3001: -- will replace the position_line_id column in new created records.
3002: --

Line 3004: DELETE psb_ws_fte_lines

3000: -- l_lines_pos_rec.position_line_id . The l_target_position_line_id
3001: -- will replace the position_line_id column in new created records.
3002: --
3003:
3004: DELETE psb_ws_fte_lines
3005: WHERE position_line_id = l_target_position_line_id ;
3006:
3007: FOR l_fte_rec IN
3008: (

Line 3010: FROM psb_ws_fte_lines

3006:
3007: FOR l_fte_rec IN
3008: (
3009: SELECT *
3010: FROM psb_ws_fte_lines
3011: WHERE position_line_id = l_lines_pos_rec.position_line_id
3012: )
3013: LOOP
3014:

Line 3079: -- API to create new fte lines in psb_ws_fte_lines.

3075: l_period_fte_tbl(58) := l_fte_rec.period58_fte ;
3076: l_period_fte_tbl(59) := l_fte_rec.period59_fte ;
3077: l_period_fte_tbl(60) := l_fte_rec.period60_fte ;
3078:
3079: -- API to create new fte lines in psb_ws_fte_lines.
3080: PSB_WS_Pos_Pvt.Create_FTE_Lines
3081: (
3082: p_api_version => 1.0 ,
3083: p_init_msg_list => FND_API.G_FALSE ,

Line 4967: -- Update all the lines in psb_ws_fte_lines as no service package

4963: WHERE worksheet_id = p_worksheet_id ) ;
4964:
4965: IF l_budget_by_position = 'Y' THEN
4966: --
4967: -- Update all the lines in psb_ws_fte_lines as no service package
4968: -- selection exists.
4969: --
4970: UPDATE psb_ws_fte_lines
4971: SET current_stage_seq = l_target_stage_seq

Line 4970: UPDATE psb_ws_fte_lines

4966: --
4967: -- Update all the lines in psb_ws_fte_lines as no service package
4968: -- selection exists.
4969: --
4970: UPDATE psb_ws_fte_lines
4971: SET current_stage_seq = l_target_stage_seq
4972: WHERE l_target_stage_seq > current_stage_seq
4973: AND end_stage_seq is null
4974: AND position_line_id IN

Line 5018: -- Update psb_ws_fte_lines as per the service package selection.

5014: --
5015: IF l_budget_by_position = 'Y' THEN
5016:
5017: --
5018: -- Update psb_ws_fte_lines as per the service package selection.
5019: --
5020: UPDATE psb_ws_fte_lines
5021: SET current_stage_seq = l_target_stage_seq
5022: WHERE l_target_stage_seq > current_stage_seq

Line 5020: UPDATE psb_ws_fte_lines

5016:
5017: --
5018: -- Update psb_ws_fte_lines as per the service package selection.
5019: --
5020: UPDATE psb_ws_fte_lines
5021: SET current_stage_seq = l_target_stage_seq
5022: WHERE l_target_stage_seq > current_stage_seq
5023: AND end_stage_seq is null
5024: AND position_line_id IN

Line 6389: -- Deleting records from psb_ws_fte_lines.

6385: -- Deleting records from psb_ws_position_lines.
6386: DELETE psb_ws_position_lines
6387: WHERE position_line_id = l_position_line_id;
6388:
6389: -- Deleting records from psb_ws_fte_lines.
6390: DELETE psb_ws_fte_lines
6391: WHERE position_line_id = l_position_line_id;
6392:
6393: -- Deleting records from psb_ws_element_lines.

Line 6390: DELETE psb_ws_fte_lines

6386: DELETE psb_ws_position_lines
6387: WHERE position_line_id = l_position_line_id;
6388:
6389: -- Deleting records from psb_ws_fte_lines.
6390: DELETE psb_ws_fte_lines
6391: WHERE position_line_id = l_position_line_id;
6392:
6393: -- Deleting records from psb_ws_element_lines.
6394: DELETE psb_ws_element_lines