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

Line 407: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

403:
404:
405: PROCEDURE GEN_BILLING_AMOUNTS
406: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
407: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
408: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
409: P_ETC_START_DATE IN
410: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
411: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 410: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

406: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
407: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
408: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
409: P_ETC_START_DATE IN
410: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
411: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
412: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
413: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
414: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 425: c_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

421: c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE,
422: c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
423: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE,
424: c_multi_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
425: c_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
426: c_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE)
427: IS
428: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
429: P.RESOURCE_ASSIGNMENT_ID,

Line 568: l_approved_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_REV_PLAN_TYPE_FLAG%TYPE;

564: l_proj_burdened_cost NUMBER;
565: l_proj_revenue NUMBER;
566: l_proj_rejection_code VARCHAR2(50);
567:
568: l_approved_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_REV_PLAN_TYPE_FLAG%TYPE;
569:
570: l_count1 NUMBER;
571: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
572: --Local pl/sql table to call Map_Rlmi_Rbs api

Line 942: FROM pa_budget_versions

938: dbms_output.put_line('aft cursor fetch rev sum:'||l_rev_sum(1)); */
939: -- hr_utility.trace('aft cursor fetch '||l_res_asg_id.count);
940: SELECT NVL(approved_rev_plan_type_flag,'N')
941: INTO l_approved_rev_plan_type_flag
942: FROM pa_budget_versions
943: WHERE budget_version_id = p_budget_version_id;
944:
945: /* dbms_output.put_line('plan_in_multi_curr_flag: '||p_fp_cols_rec.x_plan_in_multi_curr_flag);
946: dbms_output.put_line('approved_rev_plan_type_flag: '||l_approved_rev_plan_type_flag); */

Line 1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,

1382: END GEN_BILLING_AMOUNTS;
1383:
1384: PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC
1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,
1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,
1390: X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,

Line 1441: FROM pa_budget_versions

1437: X_PROJECT_REVENUE := 0;
1438:
1439: SELECT etc_start_date
1440: INTO l_etc_start_date
1441: FROM pa_budget_versions
1442: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1443:
1444: -- Bug 4067837: Added check for Retain Manual Lines flag. If the flag
1445: -- is 'N', then we fetch Billing Event amounts using the original query.

Line 1722: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1718: * API to address bug 4067836.
1719: */
1720: PROCEDURE MAP_BILLING_EVENT_RLMI_RBS
1721: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1722: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1723: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1724: X_TXN_SOURCE_ID_COUNT OUT NOCOPY NUMBER,
1725: X_TXN_SOURCE_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1726: X_RES_LIST_MEMBER_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 1995: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1991: * Note: parameter P_WP_STRUCTURE_VER_ID has Default value of Null.
1992: */
1993: PROCEDURE UPD_TMP4_TXN_RA_ID_AND_ML
1994: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1995: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1996: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1997: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
1998: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
1999: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1998: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

1994: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1995: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1996: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1997: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
1998: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
1999: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2000: X_MSG_COUNT OUT NOCOPY NUMBER,
2001: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2002: