DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_VERSIONS

Line 13: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

9: * for list of valid parameter values.
10: **/
11: PROCEDURE GENERATE_BUDGET_AMT_WRP
12: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
13: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
15: P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
16: P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'Y',
17: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2 DEFAULT 'Y',

Line 26: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

22:
23:
24: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
25: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
26: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
27: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
28: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
29: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
30: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 31: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

27: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
28: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
29: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
30: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
31: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
32: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
33: P_CALLED_MODE IN VARCHAR2 := 'SELF_SERVICE',
34: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 49: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

45: X_MSG_DATA OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE CREATE_RES_ASG
48: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
49: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
50: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
51: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
52: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
53: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,

Line 53: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,

49: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
50: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
51: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
52: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
53: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,
56: X_MSG_DATA OUT NOCOPY VARCHAR2);
57:

Line 60: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

56: X_MSG_DATA OUT NOCOPY VARCHAR2);
57:
58: PROCEDURE UPDATE_RES_ASG
59: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
60: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
61: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
62: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
63: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
64: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,

Line 64: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,

60: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
61: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
62: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
63: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
64: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,
65: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66: X_MSG_COUNT OUT NOCOPY NUMBER,
67: X_MSG_DATA OUT NOCOPY VARCHAR2);
68:

Line 72: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

68:
69:
70: PROCEDURE DEL_MANUAL_BDGT_LINES
71: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
72: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
73: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
74: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 81: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

77: X_MSG_DATA OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE UPDATE_INIT_AMOUNTS
80: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
81: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
82: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
83: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
84: X_MSG_COUNT OUT NOCOPY NUMBER,
85: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 92: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

88: PROCEDURE UPDATE_BV_FOR_GEN_DATE
89: (P_PROJECT_ID IN
90: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91: P_BUDGET_VERSION_ID IN
92: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93: P_ETC_START_DATE IN
94: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 94: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,

90: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91: P_BUDGET_VERSION_ID IN
92: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93: P_ETC_START_DATE IN
94: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2);
98:

Line 101: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

97: X_MSG_DATA OUT NOCOPY VARCHAR2);
98:
99: PROCEDURE GET_GENERATED_RES_ASG
100: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
101: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
102: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
103: P_CHK_DUPLICATE_FLAG IN VARCHAR2 := 'N',
104: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 110: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

106: X_MSG_DATA OUT NOCOPY VARCHAR2);
107:
108: PROCEDURE INSERT_TXN_CURRENCY
109: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE DEFAULT NULL,
110: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
111: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS DEFAULT NULL,
112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113: X_MSG_COUNT OUT NOCOPY NUMBER,
114: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 117: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

113: X_MSG_COUNT OUT NOCOPY NUMBER,
114: X_MSG_DATA OUT NOCOPY VARCHAR2);
115:
116: PROCEDURE RESET_COST_AMOUNTS
117: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: X_MSG_COUNT OUT NOCOPY NUMBER,
120: X_MSG_DATA OUT NOCOPY VARCHAR2);
121:

Line 124: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

120: X_MSG_DATA OUT NOCOPY VARCHAR2);
121:
122: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
123: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
124: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
125: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
126: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
127: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
128: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 129: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

125: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
126: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
127: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
128: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
129: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
130: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
131: P_CALLED_MODE IN VARCHAR2 := 'SELF_SERVICE',
132: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
133: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 147: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

143: X_MSG_DATA OUT NOCOPY VARCHAR2);
144:
145: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
146: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
147: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
148: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE
149: default 'Budget',
150: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE
151: default 'WORKPLAN_RESOURCES',

Line 153: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE

149: default 'Budget',
150: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE
151: default 'WORKPLAN_RESOURCES',
152: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
153: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE
154: default null,
155: P_RETAIN_MANUAL_FLAG IN VARCHAR2 default null,
156: P_CALLED_MODE IN VARCHAR2 default 'SELF_SERVICE',
157: P_INC_CHG_DOC_FLAG IN VARCHAR2 default 'N',