[Home] [Help]
1276:
1277: -- Create Worksheet specific instance of a Position. A unique Position Line
1278: -- ID is created for a Position for every Global Worksheet and Local Copy
1279: -- of a Worksheet. This also creates an entry in the Position Matrix table
1280: -- (PSB_WS_LINES_POSITIONS) for the current Worksheet. Entries for the Parent
1281: -- Worksheets, for Distributed Worksheets, must be created using the
1282: -- Worksheet Operations APIs
1283:
1284: PROCEDURE Create_Position_Lines
1310:
1311: cursor c_PosLine is
1312: select b.position_line_id,
1313: b.budget_group_id
1314: from PSB_WS_LINES_POSITIONS a,
1315: PSB_WS_POSITION_LINES b
1316: where a.position_line_id = b.position_line_id
1317: and a.worksheet_id = g_global_worksheet_id
1318: and b.position_id = p_position_id;
1389: last_updated_by = l_userid,
1390: last_update_login = l_loginid
1391: where position_line_id = l_poslineid;
1392:
1393: delete from PSB_WS_LINES_POSITIONS
1394: where position_line_id = l_poslineid;
1395:
1396: if g_local_copy_flag = 'Y' then
1397: begin
1540:
1541: /* ----------------------------------------------------------------------- */
1542:
1543: -- Create or Update entries in the Position Matrix table
1544: -- (PSB_WS_LINES_POSITIONS)
1545:
1546: PROCEDURE Create_Position_Matrix
1547: ( p_api_version IN NUMBER,
1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1573:
1574: l_userid := FND_GLOBAL.USER_ID;
1575: l_loginid := FND_GLOBAL.LOGIN_ID;
1576:
1577: update PSB_WS_LINES_POSITIONS
1578: set freeze_flag = decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),
1579: view_line_flag = decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),
1580: last_update_date = sysdate,
1581: last_updated_by = l_userid,
1585:
1586: if SQL%NOTFOUND then
1587: begin
1588:
1589: insert into PSB_WS_LINES_POSITIONS
1590: (worksheet_id,
1591: position_line_id,
1592: freeze_flag,
1593: view_line_flag,