[Home] [Help]
841: (
842: SELECT pos_lines.* ,
843: pos.position_id
844: FROM psb_ws_lines_positions pos_lines ,
845: psb_ws_position_lines pos
846: WHERE pos_lines.worksheet_id = p_worksheet_id
847: AND pos.position_line_id = pos_lines.position_line_id
848: AND (
849: l_service_package_count = 0
1311: FOR l_lines_rec IN
1312: (
1313: SELECT lines.*
1314: FROM psb_ws_lines_positions lines ,
1315: psb_ws_position_lines pos
1316: WHERE lines.worksheet_id = p_worksheet_id
1317: AND lines.position_line_id = pos.position_line_id
1318: /*For Bug No : 2236283 Start*/
1319: /*
1662: IF l_budget_by_position = 'Y' THEN
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: --
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:
1672: FOR l_lines_pos_rec IN
1673: (
1672: FOR l_lines_pos_rec IN
1673: (
1674: SELECT positions.*
1675: FROM psb_ws_lines_positions lines ,
1676: psb_ws_position_lines positions
1677: WHERE lines.worksheet_id = p_worksheet_id
1678: AND lines.position_line_id = positions.position_line_id
1679: )
1680: LOOP
1680: LOOP
1681:
1682: --
1683: -- API creates records in psb_ws_lines_positions and
1684: -- psb_ws_position_lines for the new worksheet.
1685: --
1686: PSB_WS_Pos_Pvt.Create_Position_Lines
1687: (
1688: p_api_version => 1.0 ,
1916: --
1917: FOR l_asgn_rec IN
1918: (
1919: SELECT asgn.*
1920: FROM psb_ws_position_lines pos ,
1921: psb_position_assignments asgn
1922: WHERE pos.position_line_id = l_lines_pos_rec.position_line_id
1923: AND asgn.worksheet_id = l_ws_row_type.global_worksheet_id
1924: AND asgn.position_id = pos.position_id
1972: --
1973: END LOOP; -- To process assignments in psb_position_assignments for
1974: -- current position line l_lines_pos_rec.position_line_id.
1975:
1976: END LOOP; -- To process position_lines in psb_ws_position_lines.
1977:
1978:
1979: END IF;
1980:
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_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 ;
2098: --
2099: CURSOR l_ws_position_lines_csr
2100: (
2101: c_copy_of_position_line_id
2102: psb_ws_position_lines.copy_of_position_line_id%TYPE
2103: )
2104: IS
2105: SELECT position_line_id, position_id
2106: FROM psb_ws_position_lines
2102: psb_ws_position_lines.copy_of_position_line_id%TYPE
2103: )
2104: IS
2105: SELECT position_line_id, position_id
2106: FROM psb_ws_position_lines
2107: WHERE position_line_id = NVL( c_copy_of_position_line_id , -99)
2108: AND ROWNUM < 2 ;
2109: --
2110: BEGIN
2421: FOR l_lines_pos_rec IN
2422: (
2423: SELECT positions.*
2424: FROM psb_ws_lines_positions lines ,
2425: psb_ws_position_lines positions
2426: WHERE lines.worksheet_id = p_source_worksheet_id
2427: AND lines.position_line_id = positions.position_line_id
2428:
2429: )
2429: )
2430: LOOP
2431:
2432: --
2433: -- Finding p_target_worksheet_id in psb_ws_position_lines.
2434: --
2435: OPEN l_ws_position_lines_csr( l_lines_pos_rec.copy_of_position_line_id );
2436:
2437: FETCH l_ws_position_lines_csr INTO l_target_position_line_id ,
4223: p_msg_count OUT NOCOPY NUMBER ,
4224: p_msg_data OUT NOCOPY VARCHAR2 ,
4225: --
4226: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
4227: p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
4228: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
4229: )
4230: IS
4231: --
4437: p_return_status OUT NOCOPY VARCHAR2 ,
4438: p_msg_count OUT NOCOPY NUMBER ,
4439: p_msg_data OUT NOCOPY VARCHAR2 ,
4440: --
4441: p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
4442: p_worksheet_tbl IN Worksheet_Tbl_Type
4443: )
4444: IS
4445: --
5906: FOR l_lines_pos_rec IN
5907: (
5908: SELECT lines.position_line_id
5909: FROM psb_ws_lines_positions lines ,
5910: psb_ws_position_lines pos
5911: WHERE lines.worksheet_id = p_source_worksheet_id
5912: AND lines.position_line_id = pos.position_line_id
5913: /*For Bug No : 2236283 Start*/
5914: /*
6331: p_return_status := FND_API.G_RET_STS_SUCCESS ;
6332:
6333: --
6334: -- p_delete_lines_flag specifies whether psb_ws_account_lines and
6335: -- psb_ws_position_lines related tables will be deleted or not.
6336: --
6337: IF p_delete_lines_flag = 'Y' THEN
6338:
6339: --
6381: IF ( l_ws_position_lines_csr%NOTFOUND ) THEN
6382: EXIT;
6383: END IF;
6384:
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.
6382: EXIT;
6383: END IF;
6384:
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
6831: (
6832: SELECT pos_lines.* ,
6833: pos.position_id
6834: FROM psb_ws_lines_positions pos_lines ,
6835: psb_ws_position_lines pos ,
6836: psb_positions positions
6837: WHERE pos_lines.worksheet_id = p_worksheet_id
6838: AND pos.position_line_id = pos_lines.position_line_id
6839: AND positions.position_id = pos.position_id