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_PROJ_FP_OPTIONS

Line 230: FROM pa_proj_fp_options opt,

226: l_proj_rev_rate_tab(1),
227: l_projfunc_rev_rate_type_tab(1),
228: l_projfunc_rev_rate_date_tab(1),
229: l_projfunc_rev_rate_tab(1)
230: FROM pa_proj_fp_options opt,
231: pa_fp_txn_currencies tc
232: WHERE opt.fin_plan_version_id = P_BUDGET_VERSION_ID
233: --AND opt.fin_plan_version_id = tc.fin_plan_version_id(+)
234: AND opt.proj_fp_options_id = tc.proj_fp_options_id(+) /* Added for Bug 5112436 */

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

402: END CONVERT_TXN_AMT_TO_PC_PFC;
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,

Line 420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,

416:
417: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GEN_BILLING_AMOUNTS';
418:
419: --Cursor used to sum the revenue amount
420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%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,

Line 424: c_multi_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,

420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%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)*/

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

1717: * This API has been created for the GET_BILLING_EVENT_AMT_IN_PFC
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,

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

1990: *
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,

Line 1997: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

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,
2000: X_MSG_COUNT OUT NOCOPY NUMBER,
2001: X_MSG_DATA OUT NOCOPY VARCHAR2) IS