APPS.GMS_SWEEPER dependencies on GMS_BALANCES

Line 365: from gms_balances

361: --## for the new budget version. As we're running baseline in 'B' mode for that award/projcet again
362: --## we need to clean up and rebuild data.
363:
364: Delete
365: from gms_balances
366: where project_id = p_project_id
367: and award_id = p_award_id
368: and budget_version_id = l_bvid
369: and balance_type='REV';

Line 427: FROM gms_balances gb

423: p_bud_task_id NUMBER,
424: p_check_task VARCHAR2,
425: p_expenditure_item_date DATE) IS
426: SELECT MAX(TRUNC(gb.start_date)),MIN(TRUNC(gb.end_date))
427: FROM gms_balances gb
428: WHERE gb.project_id = p_project_id
429: AND gb.award_id = p_award_id
430: AND gb.budget_version_id = p_budget_version_id
431: AND gb.balance_type = 'BGT'

Line 975: -- 1. Update revenue amout in GMS_BALANCES for each record in gms_rev cursor.

971: --5481465: End
972:
973: Begin
974:
975: -- 1. Update revenue amout in GMS_BALANCES for each record in gms_rev cursor.
976:
977: -- Bug 4732065: Shifted logic for deriving SOB inside LOOP
978: -- Start of the bug 5481465
979:

Line 1249: UPDATE gms_balances gb

1245: -- 4c. Update balance
1246:
1247: x_stage:='Update balance';
1248:
1249: UPDATE gms_balances gb
1250: set revenue_period_to_date = nvl(revenue_period_to_date,0) + nvl(l_amount_tbl(i),0) --nvl(rev_gen.amount,0) as part of the bug 5481465
1251: WHERE gb.project_id = l_project_id_tbl(i) --rev_gen.project_id as part of the bug 5481465
1252: AND gb.award_id = l_award_id_tbl(i)--rev_gen.award_id as part of the bug 5481465
1253: AND (gb.task_id = l_task_id_tbl(i) --rev_gen.task_id as part of the bug 5481465

Line 1297: from gms_balances gb

1293: -- a record in balances as actuals are already posted. Bug 3487431
1294:
1295: select gb.start_date, gb.end_date
1296: into x_start_date, x_end_date
1297: from gms_balances gb
1298: where gb.budget_version_id = x_budget_version_id
1299: and /* rev_gen.expenditure_item_date for bug 5481465 */ l_ei_date_tbl(i) between
1300: gb.start_date and gb.end_date
1301: and rownum = 1;

Line 1367: insert into gms_balances (project_id

1363: END if;
1364:
1365: x_stage:='Insert New Balance';
1366:
1367: insert into gms_balances (project_id
1368: ,award_id
1369: ,task_id
1370: ,resource_list_member_id
1371: ,set_of_books_id

Line 1748: x_stage := '400'; -- Update GMS_BALANCES record

1744: ---------------------------------------------------------------------------------------------------+
1745: -- Bug 4053891 Ends
1746:
1747:
1748: x_stage := '400'; -- Update GMS_BALANCES record
1749: IF L_DEBUG = 'Y' THEN
1750: gms_error_pkg.gms_debug('----------------------------------------------','C');
1751: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1752: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');

Line 1766: UPDATE gms_balances gb

1762: /* UPDATE sql commented and rewritten into two separate queries
1763: inside IF..ELSE blocks based on rec_gms_packets.document_type */
1764:
1765: /*
1766: UPDATE gms_balances gb
1767: SET gb.actual_period_to_date = nvl(gb.actual_period_to_date,0) +
1768: (nvl(rec_gms_packets.entered_dr,0)- nvl(rec_gms_packets.entered_cr,0)) *
1769: decode(rec_gms_packets.document_type,'EXP',1,0),
1770: gb.encumb_period_to_date = nvl(gb.encumb_period_to_date,0) +

Line 1788: UPDATE gms_balances gb

1784: AND rownum = 1;
1785: */
1786: IF (rec_gms_packets.document_type = 'BGT') THEN
1787:
1788: UPDATE gms_balances gb
1789: SET gb.actual_period_to_date = nvl(gb.actual_period_to_date,0) +
1790: (nvl(rec_gms_packets.entered_dr,0)- nvl(rec_gms_packets.entered_cr,0)) *
1791: decode(rec_gms_packets.document_type,'EXP',1,0),
1792: gb.encumb_period_to_date = nvl(gb.encumb_period_to_date,0) +

Line 1807: UPDATE gms_balances gb

1803: AND rownum = 1;
1804:
1805: ELSIF (rec_gms_packets.document_type <>'BGT') THEN
1806:
1807: UPDATE gms_balances gb
1808: SET gb.actual_period_to_date = nvl(gb.actual_period_to_date,0) +
1809: (nvl(rec_gms_packets.entered_dr,0)- nvl(rec_gms_packets.entered_cr,0)) *
1810: decode(rec_gms_packets.document_type,'EXP',1,0),
1811: gb.encumb_period_to_date = nvl(gb.encumb_period_to_date,0) +

Line 1912: -- Insert GMS_BALANCES record where balance record not exist

1908: END if;
1909:
1910: x_stage := '800';
1911:
1912: -- Insert GMS_BALANCES record where balance record not exist
1913:
1914: insert into gms_balances (project_id
1915: ,award_id
1916: ,task_id

Line 1914: insert into gms_balances (project_id

1910: x_stage := '800';
1911:
1912: -- Insert GMS_BALANCES record where balance record not exist
1913:
1914: insert into gms_balances (project_id
1915: ,award_id
1916: ,task_id
1917: ,top_task_id
1918: ,resource_list_member_id