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_BUDGET_PERIOD_PVT dependencies on PSB_BUDGET_PERIODS

Line 95: cursor C is select ROWID from PSB_BUDGET_PERIODS

91: p_context in varchar2,
92: p_mode in varchar2,
93: p_requery OUT NOCOPY varchar2
94: ) is
95: cursor C is select ROWID from PSB_BUDGET_PERIODS
96: where BUDGET_PERIOD_ID = P_BUDGET_PERIOD_ID;
97: P_LAST_UPDATE_DATE DATE;
98: P_LAST_UPDATED_BY NUMBER;
99: P_LAST_UPDATE_LOGIN NUMBER;

Line 177: insert into PSB_BUDGET_PERIODS (

173: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
175: end if;
176: --
177: insert into PSB_BUDGET_PERIODS (
178: budget_period_id,
179: budget_calendar_id,
180: description,
181: start_date,

Line 361: from PSB_BUDGET_PERIODS

357: attribute8,
358: attribute9,
359: attribute10,
360: context
361: from PSB_BUDGET_PERIODS
362: where BUDGET_PERIOD_ID = P_BUDGET_PERIOD_ID
363: for update of BUDGET_PERIOD_ID nowait;
364: tlinfo c1%rowtype;
365: --

Line 582: from psb_budget_periods

578: -- whether to re-create them
579: --
580: select period_distribution_type,calculation_period_type
581: into l_pd_dist_type, l_pd_calc_type
582: from psb_budget_periods
583: where budget_period_id = p_budget_period_id;
584:
585: if sql%notfound then
586: raise FND_API.G_EXC_ERROR;

Line 599: update PSB_BUDGET_PERIODS set

595: end if;
596:
597: -- do the update of the record
598: --
599: update PSB_BUDGET_PERIODS set
600: budget_calendar_id = p_budget_calendar_id,
601: name = p_name,
602: start_date = p_start_date,
603: end_date = p_end_date,

Line 733: cursor c1 is select rowid from PSB_BUDGET_PERIODS

729: p_context in varchar2,
730: p_mode in varchar2,
731: p_requery OUT NOCOPY varchar2
732: ) is
733: cursor c1 is select rowid from PSB_BUDGET_PERIODS
734: where BUDGET_PERIOD_ID = P_BUDGET_PERIOD_ID
735: ;
736: dummy c1%rowtype;
737: --

Line 880: FROM psb_budget_periods

876: --
877: -- check first if calendar not used in worksheet
878: select budget_calendar_id,start_date,end_date,budget_year_type_id
879: into l_budget_calendar_id,l_start_date,l_end_date,l_budget_year_type_id
880: FROM psb_budget_periods
881: WHERE budget_period_id = p_budget_period_id;
882:
883: --
884: Check_Used_In_WS

Line 894: delete from PSB_BUDGET_PERIODS

890: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
892: END IF;
893: --
894: delete from PSB_BUDGET_PERIODS
895: where parent_budget_period_id = p_budget_period_id;
896: if (sql%notfound) THEN
897: null;
898: end if;

Line 900: delete from PSB_BUDGET_PERIODS

896: if (sql%notfound) THEN
897: null;
898: end if;
899:
900: delete from PSB_BUDGET_PERIODS
901: where BUDGET_PERIOD_ID = P_BUDGET_PERIOD_ID;
902: if (sql%notfound) then
903: -- raise no_data_found;
904: raise FND_API.G_EXC_ERROR ;

Line 960: FROM PSB_BUDGET_PERIODS

956: BEGIN
957: --
958: SELECT count(*)
959: INTO l_type_count
960: FROM PSB_BUDGET_PERIODS
961: WHERE budget_calendar_id = p_calendar_id
962: AND budget_year_type_id = p_curr_year_type
963: AND budget_period_id <> p_budget_period_id ;
964: --

Line 1012: FROM psb_budget_periods a,

1008: l_next_start_date DATE;
1009: --
1010: CURSOR prior_year_csr IS
1011: SELECT max(b.sequence_number), end_date
1012: FROM psb_budget_periods a,
1013: psb_budget_year_types b,
1014: psb_budget_year_types c
1015: WHERE a.budget_year_type_id = b.budget_year_type_id
1016: AND b.sequence_number < c.sequence_number

Line 1024: FROM psb_budget_periods a,

1020: ORDER BY end_date DESC;
1021: --
1022: CURSOR next_year_csr IS
1023: SELECT min(b.sequence_number), start_date
1024: FROM psb_budget_periods a,
1025: psb_budget_year_types b,
1026: psb_budget_year_types c
1027: WHERE a.budget_year_type_id = b.budget_year_type_id
1028: AND b.sequence_number > c.sequence_number

Line 1191: SELECT psb_budget_periods_s.nextval

1187: --
1188: l_end_date := LAST_DAY(l_lstart_date) ;
1189: l_short_name := substr(p_parent_name, 1, 10)||'-'||to_char(l_counter);
1190: --
1191: SELECT psb_budget_periods_s.nextval
1192: INTO l_budget_period_id
1193: FROM dual;
1194: --
1195: --

Line 1334: delete from psb_budget_periods where

1330: IF (p_update_dist = 'Y') THEN
1331:
1332: -- delete old distribution lines
1333:
1334: delete from psb_budget_periods where
1335: budget_calendar_id = p_calendar_id
1336: AND parent_budget_period_id = p_year_id
1337: AND budget_period_type = 'P';
1338: if sql%notfound then

Line 1372: delete from psb_budget_periods where

1368: -- delete current calc records and create new ones
1369:
1370: IF (p_update_calc = 'Y') THEN
1371:
1372: delete from psb_budget_periods where
1373: budget_calendar_id = p_calendar_id
1374: AND parent_budget_period_id = p_year_id
1375: AND budget_period_type = 'C' ;
1376: if sql%notfound then

Line 1540: FROM psb_budget_periods a,

1536: a.attribute9,
1537: a.attribute10,
1538: a.context,
1539: b.year_category_type
1540: FROM psb_budget_periods a,
1541: psb_budget_year_types b
1542: WHERE budget_calendar_id = p_source_cal_id
1543: AND a.budget_year_type_id = b.budget_year_type_id
1544: ORDER BY start_date;

Line 1610: SELECT psb_budget_periods_s.nextval

1606: l_skip_first_rec := FALSE ;
1607: -- disregard first year to be shifted
1608: ELSE
1609: --
1610: SELECT psb_budget_periods_s.nextval
1611: INTO l_year_id
1612: FROM dual;
1613: --
1614: IF p_shift_flag = 'N' THEN

Line 1674: UPDATE psb_budget_periods a

1670: -- When copying calendar the period names of the target periods must
1671: -- same as the source. Since the Insert_Row creates it with default
1672: -- names we are updating it with source names
1673: --
1674: UPDATE psb_budget_periods a
1675: SET (name, description) =
1676: (SELECT name, description
1677: FROM psb_budget_periods b
1678: WHERE budget_calendar_id = p_source_cal_id

Line 1677: FROM psb_budget_periods b

1673: --
1674: UPDATE psb_budget_periods a
1675: SET (name, description) =
1676: (SELECT name, description
1677: FROM psb_budget_periods b
1678: WHERE budget_calendar_id = p_source_cal_id
1679: AND budget_period_type = 'P'
1680: AND b.start_date = a.start_date)
1681: WHERE a.budget_calendar_id = p_target_cal_id