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.IGW_GENERATE_PERIODS dependencies on IGW_BUDGET_PERIODS

Line 4: l_proposal_id IGW_budget_periods.proposal_id%TYPE

1: PACKAGE BODY IGW_GENERATE_PERIODS as
2: -- $Header: igwbugpb.pls 115.29 2002/11/19 23:47:56 vmedikon ship $
3: PROCEDURE create_budget_detail(
4: l_proposal_id IGW_budget_periods.proposal_id%TYPE
5: ,l_version_id IGW_budget_periods.version_id%TYPE
6: ,l_budget_period_id IGW_budget_periods.budget_period_id%TYPE
7: ,l_line_item_id IGW_budget_details.line_item_id%TYPE
8: ,l_expenditure_type IGW_budget_details.expenditure_type%TYPE

Line 5: ,l_version_id IGW_budget_periods.version_id%TYPE

1: PACKAGE BODY IGW_GENERATE_PERIODS as
2: -- $Header: igwbugpb.pls 115.29 2002/11/19 23:47:56 vmedikon ship $
3: PROCEDURE create_budget_detail(
4: l_proposal_id IGW_budget_periods.proposal_id%TYPE
5: ,l_version_id IGW_budget_periods.version_id%TYPE
6: ,l_budget_period_id IGW_budget_periods.budget_period_id%TYPE
7: ,l_line_item_id IGW_budget_details.line_item_id%TYPE
8: ,l_expenditure_type IGW_budget_details.expenditure_type%TYPE
9: ,l_budget_category_code IGW_budget_details.budget_category_code%TYPE

Line 6: ,l_budget_period_id IGW_budget_periods.budget_period_id%TYPE

2: -- $Header: igwbugpb.pls 115.29 2002/11/19 23:47:56 vmedikon ship $
3: PROCEDURE create_budget_detail(
4: l_proposal_id IGW_budget_periods.proposal_id%TYPE
5: ,l_version_id IGW_budget_periods.version_id%TYPE
6: ,l_budget_period_id IGW_budget_periods.budget_period_id%TYPE
7: ,l_line_item_id IGW_budget_details.line_item_id%TYPE
8: ,l_expenditure_type IGW_budget_details.expenditure_type%TYPE
9: ,l_budget_category_code IGW_budget_details.budget_category_code%TYPE
10: ,l_expenditure_category_flag IGW_budget_details.expenditure_category_flag%TYPE

Line 176: from igw_budget_periods

172:
173:
174: cursor c_budget_periods is
175: select count(*)
176: from igw_budget_periods
177: where proposal_id = p_proposal_id
178: and version_id = p_version_id;
179:
180:

Line 367: from igw_budget_periods

363: begin
364: select start_date, end_date
365: into l_budget_start_date
366: , l_budget_end_date
367: from igw_budget_periods
368: where proposal_id = p_proposal_id
369: and version_id = p_version_id
370: and budget_period_id = l_budget_period_id;
371: exception

Line 385: from igw_budget_periods

381: if i = (l_no_of_periods - 1) then
382: begin
383: select max(end_date)
384: into l_budget_end_date
385: from igw_budget_periods
386: where proposal_id = p_proposal_id
387: and version_id = p_version_id;
388: exception
389: when no_data_found then

Line 545: from igw_budget_periods

541: end if;
542:
543: select max(end_date), max(start_date)
544: into l_max_budget_end_date, l_max_budget_start_date
545: from igw_budget_periods
546: where proposal_id = p_proposal_id
547: and version_id = p_version_id;
548:
549: l_line_item_id := rec_budget_details.line_item_id;

Line 555: from igw_budget_periods

551:
552: BEGIN
553: select '1'
554: into l_dummy_value
555: from igw_budget_periods
556: where ((end_date-start_date) < 364 or (end_date-start_date) > 365)
557: --and start_date <> l_max_budget_start_date
558: and proposal_id = p_proposal_id
559: and version_id = p_version_id

Line 573: from igw_budget_periods

569: begin
570: select start_date, end_date
571: into l_budget_start_date
572: , l_budget_end_date
573: from igw_budget_periods
574: where proposal_id = p_proposal_id
575: and version_id = p_version_id
576: and budget_period_id = l_budget_period_id;
577: exception

Line 1001: update igw_budget_periods

997: from igw_rate_classes pr
998: where pc.rate_class_id = pr.rate_class_id
999: and pr.rate_class_type = 'E');
1000:
1001: update igw_budget_periods
1002: set total_cost = (l_direct_cost1+l_direct_cost2+l_indirect_cost)
1003: , total_direct_cost = (l_direct_cost1+l_direct_cost2)
1004: , total_indirect_cost = l_indirect_cost
1005: , cost_sharing_amount = (l_cost_share1+l_cost_share2+l_cost_share3)

Line 1025: from igw_budget_periods

1021: , l_total_indirect_cost
1022: , l_cost_sharing_amt
1023: , l_underrecovery_amount
1024: , l_total_cost_limit
1025: from igw_budget_periods
1026: where proposal_id = p_proposal_id
1027: and version_id = p_version_id;
1028:
1029:

Line 1093: from igw_budget_periods

1089: ,x_msg_count OUT NOCOPY NUMBER) is
1090:
1091: cursor c_budget_periods is
1092: select count(*)
1093: from igw_budget_periods
1094: where proposal_id = p_proposal_id
1095: and version_id = p_version_id
1096: and budget_period_id > p_budget_period_id;
1097:

Line 1266: from igw_budget_periods

1262: begin
1263: select start_date, end_date
1264: into l_budget_start_date
1265: , l_budget_end_date
1266: from igw_budget_periods
1267: where proposal_id = p_proposal_id
1268: and version_id = p_version_id
1269: and budget_period_id = i;
1270: exception

Line 1416: from igw_budget_periods

1412: l_input_amount := rec_budget_details.line_item_cost;
1413:
1414: select max(end_date), max(start_date)
1415: into l_max_budget_end_date, l_max_budget_start_date
1416: from igw_budget_periods
1417: where proposal_id = p_proposal_id
1418: and version_id = p_version_id;
1419:
1420: l_line_item_id := rec_budget_details.line_item_id;

Line 1426: from igw_budget_periods

1422:
1423: BEGIN
1424: select '1'
1425: into l_dummy_value
1426: from igw_budget_periods
1427: where ((end_date-start_date) < 364 or (end_date-start_date) > 365)
1428: --and start_date <> l_max_budget_start_date
1429: and proposal_id = p_proposal_id
1430: and version_id = p_version_id

Line 1475: from igw_budget_periods

1471: begin
1472: select start_date, end_date
1473: into l_budget_start_date
1474: , l_budget_end_date
1475: from igw_budget_periods
1476: where proposal_id = p_proposal_id
1477: and version_id = p_version_id
1478: and budget_period_id = i;
1479: exception

Line 1853: update igw_budget_periods

1849: from igw_rate_classes pr
1850: where pc.rate_class_id = pr.rate_class_id
1851: and pr.rate_class_type = 'E');
1852:
1853: update igw_budget_periods
1854: set total_cost = (l_direct_cost1+l_direct_cost2+l_indirect_cost)
1855: , total_direct_cost = (l_direct_cost1+l_direct_cost2)
1856: , total_indirect_cost = l_indirect_cost
1857: , cost_sharing_amount = (l_cost_share1+l_cost_share2+l_cost_share3)

Line 1877: from igw_budget_periods

1873: , l_total_indirect_cost
1874: , l_cost_sharing_amt
1875: , l_underrecovery_amount
1876: , l_total_cost_limit
1877: from igw_budget_periods
1878: where proposal_id = p_proposal_id
1879: and version_id = p_version_id;
1880:
1881:

Line 1949: from igw_budget_periods

1945: ,x_msg_count OUT NOCOPY NUMBER) is
1946:
1947: cursor c_budget_periods is
1948: select total_cost
1949: from igw_budget_periods
1950: where proposal_id = p_proposal_id
1951: and version_id = p_version_id
1952: and budget_period_id = p_budget_period_id;
1953:

Line 2115: from igw_budget_periods

2111:
2112: begin
2113: select total_cost_limit
2114: into l_period_cost_limit
2115: from igw_budget_periods
2116: where proposal_id = l_proposal_id
2117: and version_id = l_version_id
2118: and budget_period_id = l_budget_period_id;
2119: exception