eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_BUDGET_VERSIONS

Line 5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1: PACKAGE PA_FP_GEN_AMOUNT_UTILS as
2: /* $Header: PAFPGAUS.pls 120.7 2007/02/06 09:56:53 dthakker ship $ */
3: TYPE FP_COLS IS RECORD (
4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,

Line 54: X_PROJECT_STRUCTURE_VERSION_ID PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

50: X_ALL_QUANTITY_FLAG PA_FIN_PLAN_AMOUNT_SETS.ALL_QTY_FLAG%TYPE,
51: X_BILL_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.BILL_RATE_FLAG%TYPE,
52: X_COST_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.COST_RATE_FLAG%TYPE,
53: X_BURDEN_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE,
54: X_PROJECT_STRUCTURE_VERSION_ID PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
55: X_PLAN_CLASS_CODE PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
56: X_VERSION_TYPE PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
57: X_PROJECT_VALUE PA_PROJECTS_ALL.PROJECT_VALUE%TYPE,
58: X_TRACK_WORKPLAN_COSTS_FLAG PA_PROJ_FP_OPTIONS.TRACK_WORKPLAN_COSTS_FLAG%TYPE,

Line 56: X_VERSION_TYPE PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

52: X_COST_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.COST_RATE_FLAG%TYPE,
53: X_BURDEN_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE,
54: X_PROJECT_STRUCTURE_VERSION_ID PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
55: X_PLAN_CLASS_CODE PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
56: X_VERSION_TYPE PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
57: X_PROJECT_VALUE PA_PROJECTS_ALL.PROJECT_VALUE%TYPE,
58: X_TRACK_WORKPLAN_COSTS_FLAG PA_PROJ_FP_OPTIONS.TRACK_WORKPLAN_COSTS_FLAG%TYPE,
59: X_REVENUE_DERIVATION_METHOD VARCHAR2(1), -- bug 5152892
60: X_GEN_SRC_WP_VERSION_ID NUMBER(15),

Line 65: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

61: X_GEN_SRC_WP_VER_CODE VARCHAR2(30));
62:
63: PROCEDURE GET_PLAN_VERSION_DTLS
64: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE DEFAULT NULL,
65: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
66: X_FP_COLS_REC OUT NOCOPY FP_COLS,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
68: X_MSG_COUNT OUT NOCOPY NUMBER,
69: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,

76: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
77:
78: PROCEDURE Get_Curr_Original_Version_Info(
79: p_project_id IN pa_projects_all.project_id%TYPE,
80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
81: p_version_type IN pa_budget_versions.version_type%TYPE,
82: p_status_code IN VARCHAR2 DEFAULT 'CURRENT_ORIGINAL',
83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,
84: x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE,

Line 81: p_version_type IN pa_budget_versions.version_type%TYPE,

77:
78: PROCEDURE Get_Curr_Original_Version_Info(
79: p_project_id IN pa_projects_all.project_id%TYPE,
80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
81: p_version_type IN pa_budget_versions.version_type%TYPE,
82: p_status_code IN VARCHAR2 DEFAULT 'CURRENT_ORIGINAL',
83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,
84: x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,

Line 91: P_SRC_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

87: x_msg_data OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE VALIDATE_PLAN_VERSION
90: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91: P_SRC_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
92: P_TRGT_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2);

Line 92: P_TRGT_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

88:
89: PROCEDURE VALIDATE_PLAN_VERSION
90: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91: P_SRC_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
92: P_TRGT_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
96:

Line 157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);

153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
162: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
163: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
164: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
165: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.txn_currency_code%TYPE,

Line 182: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

178: P_MSG IN VARCHAR2,
179: P_MODULE_NAME IN VARCHAR2 DEFAULT NULL,
180: P_LOG_LEVEL IN NUMBER DEFAULT 5);
181:
182: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
183: RETURN DATE;
184:
185: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
186: RETURN DATE;

Line 185: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

181:
182: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
183: RETURN DATE;
184:
185: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
186: RETURN DATE;
187:
188: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
189: RETURN VARCHAR2;

Line 188: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)

184:
185: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
186: RETURN DATE;
187:
188: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
189: RETURN VARCHAR2;
190:
191: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
192: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)

Line 191: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,

187:
188: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
189: RETURN VARCHAR2;
190:
191: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
192: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
193: RETURN NUMBER;
194: /* This function returns the RLM ID for the given
195: project id + res list id + resource class level resource combination. */

Line 197: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,

193: RETURN NUMBER;
194: /* This function returns the RLM ID for the given
195: project id + res list id + resource class level resource combination. */
196: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
197: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
198: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
199: RETURN NUMBER;
200:
201: /**