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 1005: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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

Line 1911: P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1907:
1908:
1909: PROCEDURE GET_ETC_BDGT_COMPLETE_AMTS
1910: (P_ETC_SOURCE_CODE IN VARCHAR2,
1911: P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1912: P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
1913: P_TASK_ID IN NUMBER,
1914: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1915: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 2651: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2647:
2648: PROCEDURE GET_ETC_WORK_QTY_AMTS
2649: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2650: P_PROJ_CURRENCY_CODE IN VARCHAR2,
2651: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2652: P_TASK_ID IN NUMBER,
2653: P_TARGET_RES_LIST_ID IN NUMBER,
2654: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2655: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 3117: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3113: END GET_ETC_WORK_QTY_AMTS;
3114:
3115: PROCEDURE NONE_ETC_SRC
3116: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
3117: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3118: P_RESOURCE_LIST_ID IN NUMBER,
3119: P_TASK_ID IN NUMBER,
3120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3121: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3244: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3240: END NONE_ETC_SRC;
3241:
3242: PROCEDURE MAINTAIN_BUDGET_VERSION
3243: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
3244: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3245: P_ETC_START_DATE IN DATE,
3246: P_CALL_MAINTAIN_DATA_API IN VARCHAR2,
3247: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3248: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3263: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

3259: -- Bug Fix: 4569365. Removed MRC code.
3260: -- g_mrc_exception EXCEPTION;
3261:
3262: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3263: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
3264:
3265: -- IPM: Added local variable to pass variable values of the
3266: -- p_calling_module parameter of the MAINTAIN_DATA API.
3267: l_calling_module VARCHAR2(30);

Line 3426: FROM pa_budget_versions

3422: END IF;
3423:
3424: SELECT wp_version_flag
3425: INTO l_wp_version_flag
3426: FROM pa_budget_versions
3427: WHERE budget_version_id=p_budget_version_id;
3428:
3429: IF l_wp_version_flag = 'Y' THEN
3430: IF l_fp_cols_rec.x_fin_plan_level_code <> 'P' THEN

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

3937: /*This function can be called under two contexts:
3938: 1.'VER_ID' to get etc workplan version Id
3939: 2.'VER_NAME' to get etc workplan version name*/
3940: FUNCTION GET_ETC_WP_DTLS
3941: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3942: P_CONTEXT IN VARCHAR2)
3943: RETURN VARCHAR2
3944: IS
3945: l_project_id number;

Line 3966: PA_BUDGET_VERSIONS BV

3962: INTO l_etc_wp_bdgt_ver_id,
3963: l_etc_wp_ver_code,
3964: l_project_id
3965: FROM PA_PROJ_FP_OPTIONS OPT,PA_PROJ_FP_OPTIONS OPT1,
3966: PA_BUDGET_VERSIONS BV
3967: WHERE OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
3968: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
3969: --AND OPT.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
3970: AND OPT1.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID

Line 3977: FROM PA_BUDGET_VERSIONS

3973: /* Plan_ver_code is selected at PLAN_TYPE instead of PLAN_VERSION */
3974:
3975: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_ID' THEN
3976: SELECT PROJECT_STRUCTURE_VERSION_ID into l_etc_wp_ver_id
3977: FROM PA_BUDGET_VERSIONS
3978: WHERE BUDGET_VERSION_ID = l_etc_wp_bdgt_ver_id;
3979: RETURN l_etc_wp_ver_id;
3980: END IF;
3981: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN

Line 3983: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el

3979: RETURN l_etc_wp_ver_id;
3980: END IF;
3981: IF l_etc_wp_bdgt_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
3982: SELECT el.name INTO l_etc_wp_ver_name
3983: FROM pa_budget_versions bv, pa_proj_elem_ver_structure el
3984: WHERE bv.budget_version_id = l_etc_wp_bdgt_ver_id
3985: AND bv.project_structure_version_id = el.element_version_id
3986: AND bv.project_id = el.project_id;
3987: RETURN l_etc_wp_ver_name;

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

4034: /*This function can be called under two contexts:
4035: 1.'PTYPE_ID' to get etc finplan type Id
4036: 2.'PTYPE_NAME' to get etc finplan type name*/
4037: FUNCTION GET_ETC_FP_PTYPE_DTLS
4038: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4039: P_CONTEXT IN VARCHAR2)
4040: RETURN VARCHAR2
4041: IS
4042: l_src_plan_type_id varchar2(50);

Line 4055: PA_BUDGET_VERSIONS BV,

4051: PT.NAME
4052: INTO l_src_plan_type_id,
4053: l_src_plan_type_name
4054: FROM PA_PROJ_FP_OPTIONS OPT,
4055: PA_BUDGET_VERSIONS BV,
4056: pa_fin_plan_types_vl PT
4057: WHERE
4058: OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
4059: AND P_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID

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

4078: /*This function can be called under two contexts:
4079: 1.'VER_ID' to get etc finplan version Id
4080: 2.'VER_NAME' to get etc finplan version name*/
4081: FUNCTION GET_ETC_FP_PVERSION_DTLS
4082: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4083: P_CONTEXT IN VARCHAR2)
4084: RETURN VARCHAR2
4085: IS
4086: l_project_id number;

Line 4090: l_etc_fp_ver_name pa_budget_versions.version_name%type;

4086: l_project_id number;
4087: l_etc_fp_ver_code varchar2(20);
4088: l_src_plan_type_id number;
4089: l_etc_fp_ver_id varchar2(50);
4090: l_etc_fp_ver_name pa_budget_versions.version_name%type;
4091: l_fp_options_id number;
4092:
4093: l_return_status varchar2(10);
4094: l_msg_count number;

Line 4117: PA_BUDGET_VERSIONS BV

4113: l_etc_fp_ver_code,
4114: l_src_plan_type_id,
4115: l_project_id
4116: FROM PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
4117: PA_BUDGET_VERSIONS BV
4118: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4119: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
4120: AND OPT1.PROJECT_ID = BV.PROJECT_ID
4121: AND OPT1.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID

Line 4130: FROM PA_BUDGET_VERSIONS

4126: RETURN l_etc_fp_ver_id;
4127: END IF;
4128: IF l_etc_fp_ver_id is not null AND P_CONTEXT = 'VER_NAME' THEN
4129: SELECT version_name INTO l_etc_fp_ver_name
4130: FROM PA_BUDGET_VERSIONS
4131: WHERE BUDGET_VERSION_ID = l_etc_fp_ver_id;
4132: RETURN l_etc_fp_ver_name;
4133: END IF;
4134:

Line 4176: FROM PA_BUDGET_VERSIONS

4172: END IF;
4173:
4174: IF P_CONTEXT = 'VER_NAME' THEN
4175: SELECT version_name INTO l_etc_fp_ver_name
4176: FROM PA_BUDGET_VERSIONS
4177: WHERE BUDGET_VERSION_ID = l_etc_fp_ver_id;
4178: RETURN l_etc_fp_ver_name;
4179: END IF;
4180: EXCEPTION

Line 4207: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;

4203: X_MSG_DATA OUT NOCOPY VARCHAR2 )
4204: IS
4205: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GET_ACTUALS_FOR_RA';
4206:
4207: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4208:
4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4362: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4358: END GET_WP_ACTUALS_FOR_RA;
4359:
4360: PROCEDURE call_clnt_extn_and_update_bl(
4361: p_project_id IN pa_projects_all.project_id%TYPE
4362: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4363: ,x_call_maintain_data_api OUT NOCOPY VARCHAR2
4364: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
4365: ,X_MSG_COUNT OUT NOCOPY NUMBER
4366: ,X_MSG_DATA OUT NOCOPY VARCHAR2) IS