1 PACKAGE PA_FP_GEN_FCST_AMT_PUB1 as
2 /* $Header: PAFPFG2S.pls 120.1 2007/02/06 09:51:07 dthakker ship $ */
3
4 PROCEDURE POPULATE_GEN_RATE
5 (P_SOURCE_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
6 P_TARGET_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
7 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
8 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9 X_MSG_COUNT OUT NOCOPY NUMBER,
10 X_MSG_DATA OUT NOCOPY VARCHAR2);
11
12 PROCEDURE CHK_UPD_RATE_BASED_FLAG
13 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
16 X_MSG_COUNT OUT NOCOPY NUMBER,
17 X_MSG_DATA OUT NOCOPY VARCHAR2);
18
19 PROCEDURE CALL_SUMM_POP_TMPS
20 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
21 P_CALENDAR_TYPE IN VARCHAR2,
22 P_RECORD_TYPE IN VARCHAR2,
23 P_RESOURCE_LIST_ID IN NUMBER,
24 P_STRUCT_VER_ID IN NUMBER,
25 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
26 P_DATA_TYPE_CODE IN VARCHAR2,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER,
29 X_MSG_DATA OUT NOCOPY VARCHAR2);
30
31 PROCEDURE GEN_AVERAGE_OF_ACTUALS_WRP
32 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
33 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
34 P_ACTUALS_THRU_DATE IN DATE,
35 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
36 P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
37 P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
38 P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
39 P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
40 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
41 X_MSG_COUNT OUT NOCOPY NUMBER,
42 X_MSG_DATA OUT NOCOPY VARCHAR2);
43
44 PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
45 (P_ETC_SOURCE_CODE IN VARCHAR2,
46 P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
47 P_TASK_ID IN NUMBER,
48 P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
49 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
50 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
51 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
52 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
53 X_MSG_COUNT OUT NOCOPY NUMBER,
54 X_MSG_DATA OUT NOCOPY VARCHAR2);
55
56 PROCEDURE GET_ETC_BDGT_COMPLETE_AMTS
57 (P_ETC_SOURCE_CODE IN VARCHAR2,
58 P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
59 P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
60 P_TASK_ID IN NUMBER,
61 P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
62 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
63 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
64 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2);
68
69 PROCEDURE GET_ETC_EARNED_VALUE_AMTS
70 (P_ETC_SOURCE_CODE IN VARCHAR2,
71 P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
72 P_TASK_ID IN NUMBER,
73 P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
74 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
75 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
76 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
77 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
78 X_MSG_COUNT OUT NOCOPY NUMBER,
79 X_MSG_DATA OUT NOCOPY VARCHAR2);
80
81 PROCEDURE GET_ETC_WORK_QTY_AMTS
82 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
83 P_PROJ_CURRENCY_CODE IN VARCHAR2,
84 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
85 P_TASK_ID IN NUMBER,
86 P_TARGET_RES_LIST_ID IN NUMBER,
87 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
88 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
89 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
90 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91 X_MSG_COUNT OUT NOCOPY NUMBER,
92 X_MSG_DATA OUT NOCOPY VARCHAR2 );
93
94 PROCEDURE NONE_ETC_SRC
95 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
96 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
97 P_RESOURCE_LIST_ID IN NUMBER,
98 P_TASK_ID IN NUMBER,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100 X_MSG_COUNT OUT NOCOPY NUMBER,
101 X_MSG_DATA OUT NOCOPY VARCHAR2 );
102
103 PROCEDURE MAINTAIN_BUDGET_VERSION
104 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
105 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
106 P_ETC_START_DATE IN DATE DEFAULT NULL,
107 P_CALL_MAINTAIN_DATA_API IN VARCHAR2 DEFAULT 'Y',
108 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109 X_MSG_COUNT OUT NOCOPY NUMBER,
110 X_MSG_DATA OUT NOCOPY VARCHAR2 );
111
112
113 FUNCTION GET_ETC_WP_DTLS
114 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
115 P_CONTEXT IN VARCHAR2)
116 RETURN VARCHAR2;
117
118 FUNCTION GET_ETC_FP_PTYPE_DTLS
119 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
120 P_CONTEXT IN VARCHAR2)
121 RETURN VARCHAR2;
122
123 FUNCTION GET_ETC_FP_PVERSION_DTLS
124 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
125 P_CONTEXT IN VARCHAR2)
126 RETURN VARCHAR2;
127
128 PROCEDURE GET_WP_ACTUALS_FOR_RA
129 (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
130 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
131 P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
132 P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
133 P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
134 P_ACTUALS_THRU_DATE IN DATE,
135 X_ACT_QUANTITY OUT NOCOPY NUMBER,
136 X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
137 X_ACT_TXN_RAW_COST OUT NOCOPY NUMBER,
138 X_ACT_TXN_BRDN_COST OUT NOCOPY NUMBER,
139 X_ACT_PC_RAW_COST OUT NOCOPY NUMBER,
140 X_ACT_PC_BRDN_COST OUT NOCOPY NUMBER,
141 X_ACT_PFC_RAW_COST OUT NOCOPY NUMBER,
142 X_ACT_PFC_BRDN_COST OUT NOCOPY NUMBER,
143 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
144 X_MSG_COUNT OUT NOCOPY NUMBER,
145 X_MSG_DATA OUT NOCOPY VARCHAR2 );
146
147 -- Start Bug 5726785
148 PROCEDURE call_clnt_extn_and_update_bl
149 ( p_project_id IN pa_projects_all.project_id%TYPE
150 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
151 ,x_call_maintain_data_api OUT NOCOPY VARCHAR2
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2 );
155 -- End Bug 5726785
156
157 END PA_FP_GEN_FCST_AMT_PUB1;