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_FCST_AMT_PUB1 dependencies on PA_BUDGET_VERSIONS

Line 27: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

23: * Also worth noting is that this procedure is package-private.
24: */
25: PROCEDURE UPD_NRB_TXN_OVR_RATES
26: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
27: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
28: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
29: P_ETC_START_DATE IN DATE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,

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

619: * Currently the P_FP_COLS_REC parameter is unused. This, however, will likely
620: * change with future modifications.
621: */
622: PROCEDURE CHK_UPD_RATE_BASED_FLAG
623: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
624: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
625: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
626: X_MSG_COUNT OUT NOCOPY NUMBER,
627: X_MSG_DATA OUT NOCOPY VARCHAR2)

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

999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1000: END CALL_SUMM_POP_TMPS;
1001:
1002: PROCEDURE GEN_AVERAGE_OF_ACTUALS_WRP
1003: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1004: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1005: P_ACTUALS_THRU_DATE IN DATE,
1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

Line 1888: P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1884:
1885:
1886: PROCEDURE GET_ETC_BDGT_COMPLETE_AMTS
1887: (P_ETC_SOURCE_CODE IN VARCHAR2,
1888: P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1889: P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
1890: P_TASK_ID IN NUMBER,
1891: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1892: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 2628: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2624:
2625: PROCEDURE GET_ETC_WORK_QTY_AMTS
2626: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2627: P_PROJ_CURRENCY_CODE IN VARCHAR2,
2628: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2629: P_TASK_ID IN NUMBER,
2630: P_TARGET_RES_LIST_ID IN NUMBER,
2631: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2632: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 3094: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3090: END GET_ETC_WORK_QTY_AMTS;
3091:
3092: PROCEDURE NONE_ETC_SRC
3093: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
3094: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3095: P_RESOURCE_LIST_ID IN NUMBER,
3096: P_TASK_ID IN NUMBER,
3097: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3098: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3221: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3217: END NONE_ETC_SRC;
3218:
3219: PROCEDURE MAINTAIN_BUDGET_VERSION
3220: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
3221: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3222: P_ETC_START_DATE IN DATE,
3223: P_CALL_MAINTAIN_DATA_API IN VARCHAR2,
3224: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3225: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3240: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

3236: -- Bug Fix: 4569365. Removed MRC code.
3237: -- g_mrc_exception EXCEPTION;
3238:
3239: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3240: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
3241:
3242: -- IPM: Added local variable to pass variable values of the
3243: -- p_calling_module parameter of the MAINTAIN_DATA API.
3244: l_calling_module VARCHAR2(30);

Line 3402: FROM pa_budget_versions

3398: END IF;
3399:
3400: SELECT wp_version_flag
3401: INTO l_wp_version_flag
3402: FROM pa_budget_versions
3403: WHERE budget_version_id=p_budget_version_id;
3404:
3405: IF l_wp_version_flag = 'Y' THEN
3406: IF l_fp_cols_rec.x_fin_plan_level_code <> 'P' THEN

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

3913: /*This function can be called under two contexts:
3914: 1.'VER_ID' to get etc workplan version Id
3915: 2.'VER_NAME' to get etc workplan version name*/
3916: FUNCTION GET_ETC_WP_DTLS
3917: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3918: P_CONTEXT IN VARCHAR2)
3919: RETURN VARCHAR2
3920: IS
3921: l_project_id number;

Line 3942: PA_BUDGET_VERSIONS BV

3938: INTO l_etc_wp_bdgt_ver_id,
3939: l_etc_wp_ver_code,
3940: l_project_id
3941: FROM PA_PROJ_FP_OPTIONS OPT,PA_PROJ_FP_OPTIONS OPT1,
3942: PA_BUDGET_VERSIONS BV
3943: WHERE OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
3944: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
3945: --AND OPT.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
3946: AND OPT1.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID

Line 3953: FROM PA_BUDGET_VERSIONS

3949: /* Plan_ver_code is selected at PLAN_TYPE instead of PLAN_VERSION */
3950:
3951: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_ID' THEN
3952: SELECT PROJECT_STRUCTURE_VERSION_ID into l_etc_wp_ver_id
3953: FROM PA_BUDGET_VERSIONS
3954: WHERE BUDGET_VERSION_ID = l_etc_wp_bdgt_ver_id;
3955: RETURN l_etc_wp_ver_id;
3956: END IF;
3957: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN

Line 3959: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el

3955: RETURN l_etc_wp_ver_id;
3956: END IF;
3957: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
3958: SELECT el.name INTO l_etc_wp_ver_name
3959: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el
3960: WHERE bv.budget_version_id = l_etc_wp_bdgt_ver_id
3961: AND bv.project_structure_version_id = el.element_version_id
3962: AND bv.project_id = el.project_id;
3963: RETURN l_etc_wp_ver_name;

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

4010: /*This function can be called under two contexts:
4011: 1.'PTYPE_ID' to get etc finplan type Id
4012: 2.'PTYPE_NAME' to get etc finplan type name*/
4013: FUNCTION GET_ETC_FP_PTYPE_DTLS
4014: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4015: P_CONTEXT IN VARCHAR2)
4016: RETURN VARCHAR2
4017: IS
4018: l_src_plan_type_id varchar2(50);

Line 4031: PA_BUDGET_VERSIONS BV,

4027: PT.NAME
4028: INTO l_src_plan_type_id,
4029: l_src_plan_type_name
4030: FROM PA_PROJ_FP_OPTIONS OPT,
4031: PA_BUDGET_VERSIONS BV,
4032: pa_fin_plan_types_vl PT
4033: WHERE
4034: OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
4035: AND P_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID

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

4054: /*This function can be called under two contexts:
4055: 1.'VER_ID' to get etc finplan version Id
4056: 2.'VER_NAME' to get etc finplan version name*/
4057: FUNCTION GET_ETC_FP_PVERSION_DTLS
4058: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4059: P_CONTEXT IN VARCHAR2)
4060: RETURN VARCHAR2
4061: IS
4062: l_project_id number;

Line 4066: l_etc_fp_ver_name pa_budget_versions.version_name%type;

4062: l_project_id number;
4063: l_etc_fp_ver_code varchar2(20);
4064: l_src_plan_type_id number;
4065: l_etc_fp_ver_id varchar2(50);
4066: l_etc_fp_ver_name pa_budget_versions.version_name%type;
4067: l_fp_options_id number;
4068:
4069: l_return_status varchar2(10);
4070: l_msg_count number;

Line 4093: PA_BUDGET_VERSIONS BV

4089: l_etc_fp_ver_code,
4090: l_src_plan_type_id,
4091: l_project_id
4092: FROM PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
4093: PA_BUDGET_VERSIONS BV
4094: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4095: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
4096: AND OPT1.PROJECT_ID = BV.PROJECT_ID
4097: AND OPT1.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID

Line 4106: FROM PA_BUDGET_VERSIONS

4102: RETURN l_etc_fp_ver_id;
4103: END IF;
4104: IF l_etc_fp_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
4105: SELECT version_name INTO l_etc_fp_ver_name
4106: FROM PA_BUDGET_VERSIONS
4107: WHERE BUDGET_VERSION_ID = l_etc_fp_ver_id;
4108: RETURN l_etc_fp_ver_name;
4109: END IF;
4110:

Line 4152: FROM PA_BUDGET_VERSIONS

4148: END IF;
4149:
4150: IF P_CONTEXT = 'VER_NAME' THEN
4151: SELECT version_name INTO l_etc_fp_ver_name
4152: FROM PA_BUDGET_VERSIONS
4153: WHERE BUDGET_VERSION_ID = l_etc_fp_ver_id;
4154: RETURN l_etc_fp_ver_name;
4155: END IF;
4156: EXCEPTION

Line 4183: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;

4179: X_MSG_DATA OUT NOCOPY VARCHAR2 )
4180: IS
4181: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GET_ACTUALS_FOR_RA';
4182:
4183: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4184:
4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4338: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4334: END GET_WP_ACTUALS_FOR_RA;
4335:
4336: PROCEDURE call_clnt_extn_and_update_bl(
4337: p_project_id IN pa_projects_all.project_id%TYPE
4338: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4339: ,x_call_maintain_data_api OUT NOCOPY VARCHAR2
4340: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
4341: ,X_MSG_COUNT OUT NOCOPY NUMBER
4342: ,X_MSG_DATA OUT NOCOPY VARCHAR2) IS