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_PROJECTS_ALL

Line 26: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

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

Line 744: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

740: *are same between eitehr two or 3 of them. If they do, we only need to call
741: *this procedure 2 or 1 times, instead of 3.
742: *WILL BE CHANGED LATER**/
743: PROCEDURE CALL_SUMM_POP_TMPS
744: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
745: P_CALENDAR_TYPE IN VARCHAR2,
746: P_RECORD_TYPE IN VARCHAR2,
747: P_RESOURCE_LIST_ID IN NUMBER,
748: P_STRUCT_VER_ID IN NUMBER,

Line 1479: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1475: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_REMAIN_BDGT_AMTS';
1476:
1477: l_currency_count_tot NUMBER;
1478: l_currency_count_act NUMBER;
1479: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1480: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1481: l_currency_flag VARCHAR2(2);
1482: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1483:

Line 1480: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1476:
1477: l_currency_count_tot NUMBER;
1478: l_currency_count_act NUMBER;
1479: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1480: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1481: l_currency_flag VARCHAR2(2);
1482: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1483:
1484: l_tot_qty NUMBER;

Line 1482: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1478: l_currency_count_act NUMBER;
1479: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1480: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1481: l_currency_flag VARCHAR2(2);
1482: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1483:
1484: l_tot_qty NUMBER;
1485: l_tot_txn_raw_cost NUMBER;
1486: l_tot_txn_brdn_cost NUMBER;

Line 1903: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1899: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_BDGT_COMPLETE_AMTS';
1900:
1901: l_currency_count_tot NUMBER;
1902: l_currency_count_bsl NUMBER;
1903: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1904: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1905: l_currency_flag VARCHAR2(2);
1906: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1907:

Line 1904: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1900:
1901: l_currency_count_tot NUMBER;
1902: l_currency_count_bsl NUMBER;
1903: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1904: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1905: l_currency_flag VARCHAR2(2);
1906: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1907:
1908: l_tot_txn_currency_code NUMBER;

Line 1906: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1902: l_currency_count_bsl NUMBER;
1903: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1904: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1905: l_currency_flag VARCHAR2(2);
1906: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1907:
1908: l_tot_txn_currency_code NUMBER;
1909: l_tot_qty NUMBER;
1910: l_tot_txn_raw_cost NUMBER;

Line 2171: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2167: IS
2168: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_EARNED_VALUE_AMTS';
2169:
2170: l_txn_currency_count_act NUMBER;
2171: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2172: l_txn_currency_count_tot NUMBER;
2173: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2174: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2175:

Line 2173: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2169:
2170: l_txn_currency_count_act NUMBER;
2171: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2172: l_txn_currency_count_tot NUMBER;
2173: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2174: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2175:
2176: l_act_qty NUMBER;
2177: l_act_txn_raw_cost NUMBER;

Line 2174: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2170: l_txn_currency_count_act NUMBER;
2171: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2172: l_txn_currency_count_tot NUMBER;
2173: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2174: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2175:
2176: l_act_qty NUMBER;
2177: l_act_txn_raw_cost NUMBER;
2178: l_act_txn_brdn_cost NUMBER;

Line 2626: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END GET_ETC_EARNED_VALUE_AMTS;
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,

Line 2640: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;

2636: X_MSG_DATA OUT NOCOPY VARCHAR2)
2637: IS
2638: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_WORK_QTY_AMT';
2639:
2640: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
2641:
2642: l_act_work_qty NUMBER :=0;
2643: l_act_raw_cost_pc NUMBER :=0;
2644: l_act_brdn_cost_pc NUMBER :=0;

Line 3002: FROM pa_projects_all

2998: ELSE
2999: SELECT nvl(start_date,l_sysdate),
3000: nvl(completion_date,l_sysdate)
3001: INTO l_start_date, l_completion_date
3002: FROM pa_projects_all
3003: WHERE project_id = p_project_id;
3004:
3005: END IF;
3006: /**For work quantity, we needn't do mapping, because we get the corresponding res

Line 3093: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,

Line 3131: FROM pa_projects_all WHERE

3127: ELSE
3128: SELECT nvl(start_date,l_sysdate),
3129: nvl(completion_date,l_sysdate)
3130: INTO l_task_start_date, l_task_completion_date
3131: FROM pa_projects_all WHERE
3132: project_id = p_project_id;
3133: END IF;
3134: /* for etc source as NULL or NONE the planning resource will be
3135: created based on the task + people resourece class combination.

Line 3220: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

3216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,

Line 4337: p_project_id IN pa_projects_all.project_id%TYPE

4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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