1 package PA_DATE_RANGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: PADTRNGS.pls 120.0 2005/05/30 20:51:47 appldev noship $ */
3 procedure DATE_RANGE_UPGRD(
4 P_BUDGET_VERSIONS IN SYSTEM.PA_NUM_TBL_TYPE,
5 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6 X_MSG_COUNT OUT NOCOPY NUMBER,
7 X_MSG_DATA OUT NOCOPY VARCHAR2);
8
9 --Bug 4046492. This API returns the Time Phase into which a budget version should be upgraded. The values
10 --that can be returned are
11 --'P' if the budget version has to upgraded to PA Time Phase
12 --'G' if the budget version has to upgraded to GL Time Phase
13 --'N' if the budget version has to upgraded to None Time Phase
14 --This function will be called from the upgrade script paupg102.sql and PADTRNGB.DATE_RANGE_UPGRD
15 function get_time_phase_mode
16 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
17 ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE
18 ,p_gl_period_type IN gl_sets_of_books.accounted_period_type%TYPE
19 ,p_org_id IN pa_projects_all.org_id%TYPE) RETURN VARCHAR2;
20 end PA_DATE_RANGE_PKG;
[Home] [Help]