APPS.IGW_BUDGET_PERIODS_PVT dependencies on IGW_BUDGET_PERIODS

Line 1: PACKAGE BODY IGW_BUDGET_PERIODS_PVT AS

1: PACKAGE BODY IGW_BUDGET_PERIODS_PVT AS
2: --$Header: igwvbprb.pls 115.14 2002/11/14 18:41:02 vmedikon ship $
3:
4:
5: procedure check_duplicate_period(p_proposal_id NUMBER

Line 14: from igw_budget_periods

10: l_api_name VARCHAR2(30) := 'CHECK_DUPLICATE_PERIOD';
11: begin
12: select '1'
13: into l_exists
14: from igw_budget_periods
15: where proposal_id = p_proposal_id
16: and version_id = p_version_id
17: and budget_period_id = p_budget_period_id;
18:

Line 106: from igw_budget_periods

102: l_api_name VARCHAR2(30) := 'VALIDATE_PERIOD_DATE';
103: begin
104: select '1'
105: into x_dummy
106: from igw_budget_periods
107: where proposal_id = p_proposal_id
108: and version_id = p_version_id
109: and p_date BETWEEN start_date and end_date
110: and budget_period_id <> p_budget_period_id

Line 231: igw_budget_periods_tbh.insert_row(

227:
228: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
229:
230: l_total_cost := nvl(p_total_indirect_cost,0) + nvl(p_total_direct_Cost,0);
231: igw_budget_periods_tbh.insert_row(
232: p_proposal_id => p_proposal_id
233: ,p_version_id => p_version_id
234: ,p_budget_period_id => p_budget_period_id
235: ,p_start_date => p_start_date

Line 365: from igw_budget_periods

361:
362: if p_rowid is not null then
363: select budget_period_id
364: into l_orig_budget_period_id
365: from igw_budget_periods
366: where rowid = p_rowid;
367: end if;
368:
369:

Line 432: FROM igw_budget_periods

428: End if;
429:
430: BEGIN
431: SELECT 'x' INTO l_dummy
432: FROM igw_budget_periods
433: WHERE ((proposal_id = p_proposal_id AND version_id = p_version_id
434: AND budget_period_id = p_budget_period_id)
435: OR rowid = p_rowid)
436: AND record_version_number = p_record_version_number;

Line 466: igw_budget_periods_tbh.update_row(

462: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
463:
464: l_total_cost := nvl(p_total_indirect_cost,0) + nvl(p_total_direct_Cost,0);
465:
466: igw_budget_periods_tbh.update_row(
467: p_rowid => p_rowid
468: ,p_proposal_id => p_proposal_id
469: ,p_version_id => p_version_id
470: ,p_budget_period_id => p_budget_period_id

Line 607: FROM igw_budget_periods

603: x_return_status := 'S';
604:
605: BEGIN
606: SELECT 'x' INTO l_dummy
607: FROM igw_budget_periods
608: WHERE ((proposal_id = p_proposal_id AND version_id = p_version_id
609: AND budget_period_id = p_budget_period_id)
610: OR rowid = p_rowid)
611: AND record_version_number = p_record_version_number;

Line 639: igw_budget_periods_tbh.delete_row (

635: END IF;
636:
637: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
638:
639: igw_budget_periods_tbh.delete_row (
640: p_rowid => p_rowid,
641: p_proposal_id => p_proposal_id,
642: p_version_id => p_version_id,
643: p_budget_period_id => p_budget_period_id,

Line 718: END IGW_BUDGET_PERIODS_PVT;

714:
715: END; --DELETE BUDGET VERSION
716:
717:
718: END IGW_BUDGET_PERIODS_PVT;