PACKAGE: APPS.PA_FP_GEN_FCST_AMT_PUB3

Source

1 PACKAGE PA_FP_GEN_FCST_AMT_PUB3 as
2 /* $Header: PAFPFG3S.pls 120.1 2005/07/28 16:21:08 appldev noship $ */
3 
4 /**Valid values for param:P_ETC_SOURCE_CODE
5   * --ETC_WP
6   * --ETC_FP
7   * --TARGET_FP
8   **/
9 PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
10 	  (P_SRC_RES_ASG_ID		IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
11 	   P_TGT_RES_ASG_ID		IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
12 	   P_FP_COLS_SRC_REC		IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
13 	   P_FP_COLS_TGT_REC		IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14 	   P_TASK_ID			IN PA_TASKS.TASK_ID%TYPE,
15 	   P_RESOURCE_LIST_MEMBER_ID	IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
16 	   P_ETC_SOURCE_CODE		IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
17 	   P_WP_STRUCTURE_VERSION_ID    IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
18 	   P_ACTUALS_THRU_DATE 		IN PA_PERIODS_ALL.END_DATE%TYPE,
19 	   P_PLANNING_OPTIONS_FLAG	IN VARCHAR2,
20 	   X_RETURN_STATUS		OUT  NOCOPY VARCHAR2,
21 	   X_MSG_COUNT			OUT  NOCOPY NUMBER,
22 	   X_MSG_DATA	           	OUT  NOCOPY VARCHAR2);
23 
24 PROCEDURE CHECK_SINGLE_CURRENCY
25 	  (P_TGT_RES_ASG_ID		IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
26 	   X_SINGLE_CURRENCY_FLAG	OUT  NOCOPY VARCHAR2,
27 	   X_RETURN_STATUS		OUT  NOCOPY VARCHAR2,
28 	   X_MSG_COUNT			OUT  NOCOPY NUMBER,
29 	   X_MSG_DATA	           	OUT  NOCOPY VARCHAR2);
30 
31 /* Bug 4369741: Replaced single planning options flag parameter with
32  * 2 separate parameters - 1 for Workplan and 1 for Financial Plan. */
33 
34 PROCEDURE GET_ETC_COMMITMENT_AMTS
35 	  (P_FP_COLS_TGT_REC		IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
36 	   P_WP_PLANNING_OPTIONS_FLAG	IN VARCHAR2, /* Added for Bug 4369741 */
37 	   P_FP_PLANNING_OPTIONS_FLAG	IN VARCHAR2, /* Added for Bug 4369741 */
38 	   X_RETURN_STATUS		OUT  NOCOPY VARCHAR2,
39 	   X_MSG_COUNT			OUT  NOCOPY NUMBER,
40 	   X_MSG_DATA	           	OUT  NOCOPY VARCHAR2);
41 
42 PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK(
43             P_SRC_RES_ASG_ID_TAB        IN  PA_PLSQL_DATATYPES.IdTabTyp,
44             P_TGT_RES_ASG_ID_TAB        IN  PA_PLSQL_DATATYPES.IdTabTyp,
45             P_FP_COLS_SRC_REC_FP        IN  PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
46             P_FP_COLS_SRC_REC_WP        IN  PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
47             P_FP_COLS_TGT_REC           IN  PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
48             P_TASK_ID_TAB               IN  PA_PLSQL_DATATYPES.IdTabTyp,
49             P_RES_LIST_MEMBER_ID_TAB    IN  PA_PLSQL_DATATYPES.IdTabTyp,
50             P_ETC_SOURCE_CODE_TAB       IN  PA_PLSQL_DATATYPES.Char30TabTyp,
51             P_WP_STRUCTURE_VERSION_ID   IN  PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
52             P_ACTUALS_THRU_DATE         IN  PA_PERIODS_ALL.END_DATE%TYPE,
53             P_PLANNING_OPTIONS_FLAG     IN  VARCHAR2,
54             X_RETURN_STATUS             OUT NOCOPY VARCHAR2,
55             X_MSG_COUNT                 OUT NOCOPY NUMBER,
56             X_MSG_DATA                  OUT NOCOPY VARCHAR2);
57 
58 END PA_FP_GEN_FCST_AMT_PUB3;