[Home] [Help]
1097: -- Bug 1555396 : x_start_date and x_end_date should be not null
1098: if x_period_type in ('G','P') AND x_start_date IS NOT NULL AND x_end_date IS NOT NULL then
1099: select period_name
1100: into x_period_name
1101: from pa_budget_periods_v
1102: where period_start_date = x_start_date
1103: and period_end_date = x_end_date
1104: and period_type_code = x_period_type;
1105: end if;
1659: (p_period_name VARCHAR2
1660: ,p_period_type_code VARCHAR2 )
1661: IS
1662: SELECT period_name
1663: FROM pa_budget_periods_v
1664: WHERE period_name = p_period_name
1665: AND period_type_code = p_period_type_code;
1666:
1667:
5587: (p_period_name VARCHAR2
5588: ,p_time_phased_type_code VARCHAR2 )
5589: IS
5590: SELECT trunc(period_start_date), trunc(period_end_date) -- added end_date which is required in validate_budget()
5591: FROM pa_budget_periods_v
5592: WHERE period_name = p_period_name
5593: AND period_type_code = p_time_phased_type_code;
5594:
5595: --needed to validate to given start_date
5598: (p_start_date DATE
5599: ,p_time_phased_type_code VARCHAR2 )
5600: IS
5601: SELECT 1
5602: FROM pa_budget_periods_v
5603: WHERE trunc(period_start_date) = trunc(p_start_date)
5604: AND period_type_code = p_time_phased_type_code;
5605:
5606: --needed to lock the budget line row
6307: (p_period_name VARCHAR2
6308: ,p_period_type_code VARCHAR2 )
6309: IS
6310: SELECT period_name
6311: FROM pa_budget_periods_v
6312: WHERE period_name = p_period_name
6313: AND period_type_code = p_period_type_code;
6314:
6315: -- the uncategorized resource list
6973: (p_period_name VARCHAR2
6974: ,p_period_type_code VARCHAR2 )
6975: IS
6976: SELECT trunc(period_start_date), trunc(period_end_date)
6977: FROM pa_budget_periods_v
6978: WHERE period_name = p_period_name
6979: AND period_type_code = p_period_type_code;
6980:
6981: