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 1502: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1498: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_REMAIN_BDGT_AMTS';
1499:
1500: l_currency_count_tot NUMBER;
1501: l_currency_count_act NUMBER;
1502: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1503: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1504: l_currency_flag VARCHAR2(2);
1505: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1506:

Line 1503: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1499:
1500: l_currency_count_tot NUMBER;
1501: l_currency_count_act NUMBER;
1502: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1503: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1504: l_currency_flag VARCHAR2(2);
1505: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1506:
1507: l_tot_qty NUMBER;

Line 1505: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1501: l_currency_count_act NUMBER;
1502: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1503: l_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1504: l_currency_flag VARCHAR2(2);
1505: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1506:
1507: l_tot_qty NUMBER;
1508: l_tot_txn_raw_cost NUMBER;
1509: l_tot_txn_brdn_cost NUMBER;

Line 1926: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1922: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_BDGT_COMPLETE_AMTS';
1923:
1924: l_currency_count_tot NUMBER;
1925: l_currency_count_bsl NUMBER;
1926: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1927: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1928: l_currency_flag VARCHAR2(2);
1929: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1930:

Line 1927: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1923:
1924: l_currency_count_tot NUMBER;
1925: l_currency_count_bsl NUMBER;
1926: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1927: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1928: l_currency_flag VARCHAR2(2);
1929: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1930:
1931: l_tot_txn_currency_code NUMBER;

Line 1929: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1925: l_currency_count_bsl NUMBER;
1926: l_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1927: l_currency_code_bsl PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1928: l_currency_flag VARCHAR2(2);
1929: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1930:
1931: l_tot_txn_currency_code NUMBER;
1932: l_tot_qty NUMBER;
1933: l_tot_txn_raw_cost NUMBER;

Line 2194: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2190: IS
2191: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_EARNED_VALUE_AMTS';
2192:
2193: l_txn_currency_count_act NUMBER;
2194: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2195: l_txn_currency_count_tot NUMBER;
2196: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2197: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2198:

Line 2196: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2192:
2193: l_txn_currency_count_act NUMBER;
2194: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2195: l_txn_currency_count_tot NUMBER;
2196: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2197: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2198:
2199: l_act_qty NUMBER;
2200: l_act_txn_raw_cost NUMBER;

Line 2197: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

2193: l_txn_currency_count_act NUMBER;
2194: l_txn_currency_code_act PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2195: l_txn_currency_count_tot NUMBER;
2196: l_txn_currency_code_tot PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2197: l_etc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
2198:
2199: l_act_qty NUMBER;
2200: l_act_txn_raw_cost NUMBER;
2201: l_act_txn_brdn_cost NUMBER;

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

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

Line 2663: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;

2659: X_MSG_DATA OUT NOCOPY VARCHAR2)
2660: IS
2661: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GEN_ETC_WORK_QTY_AMT';
2662:
2663: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
2664:
2665: l_act_work_qty NUMBER :=0;
2666: l_act_raw_cost_pc NUMBER :=0;
2667: l_act_brdn_cost_pc NUMBER :=0;

Line 3025: FROM pa_projects_all

3021: ELSE
3022: SELECT nvl(start_date,l_sysdate),
3023: nvl(completion_date,l_sysdate)
3024: INTO l_start_date, l_completion_date
3025: FROM pa_projects_all
3026: WHERE project_id = p_project_id;
3027:
3028: END IF;
3029: /**For work quantity, we needn't do mapping, because we get the corresponding res

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

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

Line 3154: FROM pa_projects_all WHERE

3150: ELSE
3151: SELECT nvl(start_date,l_sysdate),
3152: nvl(completion_date,l_sysdate)
3153: INTO l_task_start_date, l_task_completion_date
3154: FROM pa_projects_all WHERE
3155: project_id = p_project_id;
3156: END IF;
3157: /* for etc source as NULL or NONE the planning resource will be
3158: created based on the task + people resourece class combination.

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

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

Line 4361: p_project_id IN pa_projects_all.project_id%TYPE

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