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_CREATE_BR_PVT dependencies on PSB_BUDGET_REVISION_POS_LINES

Line 443: FROM psb_budget_revision_pos_lines lines,

439: WHERE budget_revision_id = p_budget_revision_id;
440:
441: CURSOR l_budget_by_position_csr IS
442: SELECT count(*)
443: FROM psb_budget_revision_pos_lines lines,
444: psb_budget_revisions rev
445: WHERE rev.budget_revision_id = p_budget_revision_id
446: AND rev.budget_revision_id = lines.budget_revision_id;
447:

Line 666: -- Maintain psb_budget_revision_pos_lines if budget revision

662: END IF;
663: --
664: END LOOP;
665: --
666: -- Maintain psb_budget_revision_pos_lines if budget revision
667: -- contains positions.(This also means the budget revision includes
668: -- position budgeting.)
669: --
670: OPEN l_budget_by_position_csr;

Line 685: FROM psb_budget_revision_pos_lines lines ,

681: --
682: FOR l_lines_rec IN
683: (
684: SELECT lines.*
685: FROM psb_budget_revision_pos_lines lines ,
686: psb_budget_revision_positions pos
687: WHERE lines.budget_revision_id = p_budget_revision_id
688: AND lines.budget_revision_pos_line_id
689: = pos.budget_revision_pos_line_id

Line 710: -- psb_budget_revision_pos_lines

706: debug('Budget Revision Position line id '||
707: l_lines_rec.budget_revision_pos_line_id);
708:
709: -- Put the budget_revision_pos_line_id in the
710: -- psb_budget_revision_pos_lines
711: -- table for the new budget revision.
712:
713: Insert_BR_Pos_Lines_Pvt
714: ( p_budget_revision_id => l_new_budget_revision_id,

Line 941: -- Update freeze_flag in psb_budget_revision_pos_lines.

937: WHERE budget_revision_id = p_budget_revision_id;
938:
939: IF g_budget_by_position IS NOT NULL THEN
940: --
941: -- Update freeze_flag in psb_budget_revision_pos_lines.
942: --
943: UPDATE psb_budget_revision_pos_lines
944: SET freeze_flag = p_freeze_flag
945: WHERE budget_revision_id = p_budget_revision_id;

Line 943: UPDATE psb_budget_revision_pos_lines

939: IF g_budget_by_position IS NOT NULL THEN
940: --
941: -- Update freeze_flag in psb_budget_revision_pos_lines.
942: --
943: UPDATE psb_budget_revision_pos_lines
944: SET freeze_flag = p_freeze_flag
945: WHERE budget_revision_id = p_budget_revision_id;
946: --
947: END IF;

Line 1541: l_br_lines_pos_rec psb_budget_revision_pos_lines%ROWTYPE;

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(*)
1545: FROM psb_budget_revision_pos_lines lines,

Line 1545: FROM psb_budget_revision_pos_lines lines,

1541: l_br_lines_pos_rec psb_budget_revision_pos_lines%ROWTYPE;
1542:
1543: CURSOR l_budget_by_position_csr IS
1544: SELECT count(*)
1545: FROM psb_budget_revision_pos_lines lines,
1546: psb_budget_revisions rev
1547: WHERE rev.budget_revision_id = p_source_budget_revision_id
1548: AND rev.budget_revision_id = lines.budget_revision_id;
1549:

Line 1711: FROM psb_budget_revision_pos_lines lines ,

1707: --
1708: FOR l_lines_pos_rec IN
1709: (
1710: SELECT lines.budget_revision_pos_line_id
1711: FROM psb_budget_revision_pos_lines lines ,
1712: psb_budget_revision_positions pos
1713: WHERE lines.budget_revision_id = p_source_budget_revision_id
1714: AND lines.budget_revision_pos_line_id
1715: = pos.budget_revision_pos_line_id

Line 1731: FROM psb_budget_revision_pos_lines

1727: bg.parent_budget_group_id
1728: )
1729: MINUS
1730: SELECT budget_revision_pos_line_id
1731: FROM psb_budget_revision_pos_lines
1732: WHERE budget_revision_id = p_target_budget_revision_id
1733: )
1734: LOOP
1735:

Line 1737: FROM psb_budget_revision_pos_lines

1733: )
1734: LOOP
1735:
1736: SELECT * INTO l_br_lines_pos_rec
1737: FROM psb_budget_revision_pos_lines
1738: WHERE budget_revision_id = p_source_budget_revision_id
1739: AND budget_revision_pos_line_id
1740: = l_lines_pos_rec.budget_revision_pos_line_id ;
1741:

Line 1896: -- psb_budget_revision_pos_lines table.

1892: | PROCEDURE Insert_BR_Pos_Lines_Pvt ( Private ) |
1893: +===========================================================================*/
1894: --
1895: -- The private procedure inserts a new record in
1896: -- psb_budget_revision_pos_lines table.
1897: --
1898: PROCEDURE Insert_BR_Pos_Lines_Pvt
1899: (
1900: p_budget_revision_id IN NUMBER,

Line 1919: update psb_budget_revision_pos_lines

1915: BEGIN
1916: --
1917: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1918: --
1919: update psb_budget_revision_pos_lines
1920: set freeze_flag = p_freeze_flag,
1921: view_line_flag = p_view_line_flag,
1922: last_update_date = g_current_date,
1923: last_updated_by = g_current_user_id,

Line 1930: INSERT INTO psb_budget_revision_pos_lines

1926: and budget_revision_id = p_budget_revision_id;
1927:
1928: IF SQL%NOTFOUND THEN
1929:
1930: INSERT INTO psb_budget_revision_pos_lines
1931: (
1932: budget_revision_id,
1933: budget_revision_pos_line_id,
1934: freeze_flag,