APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /**This procedure is called to copy actuals to budget version lines**/
6: PROCEDURE COPY_ACTUALS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: P_END_DATE IN DATE,
11: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',

Line 567: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%TYPE;

563: l_res_asg_id_tmp_tab pa_plsql_datatypes.IdTabTyp;
564:
565: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
566: l_txn_currency_flag VARCHAR2(1) := 'Y';
567: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%TYPE;
568:
569: l_etc_start_date DATE;
570: BEGIN
571: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1226: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

1222: END COPY_ACTUALS;
1223:
1224:
1225: PROCEDURE CREATE_RES_ASG (
1226: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1227: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1228: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1229: P_CALLING_PROCESS IN VARCHAR2,
1230: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1818: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

1814: END CREATE_RES_ASG;
1815:
1816:
1817: PROCEDURE UPDATE_RES_ASG (
1818: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1819: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1820: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1821: P_CALLING_PROCESS IN VARCHAR2,
1822: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1992: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

1988: * This procedure is called to collect actuals for a selected resource assignments or
1989: * for a whole budget version given.
1990: **/
1991: PROCEDURE COLLECT_ACTUALS
1992: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1993: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1994: P_RESOURCE_ASSGN_IDS IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1995: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
1996: P_COMMIT_FLAG IN VARCHAR2 default 'N',

Line 2057: FROM PA_PROJ_FP_OPTIONS

2053: -- Cursor to get 'Copy ETC from Plan' flag
2054: CURSOR get_copy_etc_from_plan_csr
2055: IS
2056: SELECT COPY_ETC_FROM_PLAN_FLAG
2057: FROM PA_PROJ_FP_OPTIONS
2058: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
2059: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;
2060:
2061: -- Cursor to get resource assignment ids for a budget version

Line 2059: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;

2055: IS
2056: SELECT COPY_ETC_FROM_PLAN_FLAG
2057: FROM PA_PROJ_FP_OPTIONS
2058: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
2059: l_copy_etc_from_plan_flag PA_PROJ_FP_OPTIONS.COPY_ETC_FROM_PLAN_FLAG%TYPE;
2060:
2061: -- Cursor to get resource assignment ids for a budget version
2062: CURSOR get_resource_assgn_ids_csr IS
2063: SELECT RESOURCE_ASSIGNMENT_ID