APPS.PSB_CREATE_BR_PVT dependencies on PSB_BUDGET_REVISION_LINES

Line 614: -- which will be used to maintain psb_budget_revision_lines table.

610: END IF;
611: --
612: --
613: -- This LOOP gets all the account_line_id for the new budget revision
614: -- which will be used to maintain psb_budget_revision_lines table.
615: --
616: FOR l_lines_rec IN
617: (
618: SELECT lines.*

Line 619: FROM psb_budget_revision_lines lines,

615: --
616: FOR l_lines_rec IN
617: (
618: SELECT lines.*
619: FROM psb_budget_revision_lines lines,
620: psb_budget_revision_accounts acct
621: WHERE lines.budget_revision_id = p_budget_revision_id
622: AND lines.budget_revision_acct_line_id =
623: acct.budget_revision_acct_line_id

Line 641: -- Put the account line ids in the psb_budget_revision_lines table

637:
638: debug('Budget Revision Account line id '||
639: l_lines_rec.budget_revision_acct_line_id);
640: --
641: -- Put the account line ids in the psb_budget_revision_lines table
642: -- for the new budget revision.
643: --
644: Insert_BR_Lines_Pvt
645: ( p_budget_revision_id => l_new_budget_revision_id,

Line 933: -- Update freeze_flag in psb_budget_revision_lines.

929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
931: END IF;
932: --
933: -- Update freeze_flag in psb_budget_revision_lines.
934:
935: UPDATE psb_budget_revision_lines
936: SET freeze_flag = p_freeze_flag
937: WHERE budget_revision_id = p_budget_revision_id;

Line 935: UPDATE psb_budget_revision_lines

931: END IF;
932: --
933: -- Update freeze_flag in psb_budget_revision_lines.
934:
935: UPDATE psb_budget_revision_lines
936: SET freeze_flag = p_freeze_flag
937: WHERE budget_revision_id = p_budget_revision_id;
938:
939: IF g_budget_by_position IS NOT NULL THEN

Line 1540: l_br_lines_rec psb_budget_revision_lines%ROWTYPE;

1536: l_target_budget_revision_id NUMBER;
1537: l_target_global_budget_rev_id NUMBER;
1538: --
1539: l_budget_calendar_id NUMBER;
1540: l_br_lines_rec psb_budget_revision_lines%ROWTYPE;
1541: l_br_lines_pos_rec psb_budget_revision_pos_lines%ROWTYPE;
1542:
1543: CURSOR l_budget_by_position_csr IS
1544: SELECT count(*)

Line 1638: FROM psb_budget_revision_lines lines,

1634: --
1635: FOR l_account_line_id_rec IN
1636: (
1637: SELECT lines.budget_revision_acct_line_id
1638: FROM psb_budget_revision_lines lines,
1639: psb_budget_revision_accounts acct
1640: WHERE lines.budget_revision_id = p_source_budget_revision_id
1641: AND lines.budget_revision_acct_line_id
1642: =

Line 1657: FROM psb_budget_revision_lines lines

1653: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
1654: )
1655: MINUS
1656: SELECT lines.budget_revision_acct_line_id
1657: FROM psb_budget_revision_lines lines
1658: WHERE budget_revision_id = p_target_budget_revision_id
1659: )
1660: LOOP
1661:

Line 1663: FROM psb_budget_revision_lines

1659: )
1660: LOOP
1661:
1662: SELECT * INTO l_br_lines_rec
1663: FROM psb_budget_revision_lines
1664: WHERE budget_revision_id = p_source_budget_revision_id
1665: AND budget_revision_acct_line_id =
1666: l_account_line_id_rec.budget_revision_acct_line_id ;
1667:

Line 1838: update psb_budget_revision_lines

1834: BEGIN
1835: --
1836: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1837: --
1838: update psb_budget_revision_lines
1839: set freeze_flag = p_freeze_flag,
1840: view_line_flag = p_view_line_flag,
1841: last_update_date = g_current_date,
1842: last_updated_by = g_current_user_id,

Line 1849: INSERT INTO psb_budget_revision_lines

1845: and budget_revision_id = p_budget_revision_id;
1846:
1847: IF SQL%NOTFOUND THEN
1848:
1849: INSERT INTO psb_budget_revision_lines
1850: (
1851: budget_revision_id,
1852: budget_revision_acct_line_id,
1853: freeze_flag,