APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_PROJECTS_ALL

Line 51: l_pc_currency_code pa_projects_all.project_currency_code%type;

47: l_prorating_always_flag VARCHAR2(1);
48: l_target_version_type pa_budget_versions.version_type%type;
49:
50: /* For PC amounts */
51: l_pc_currency_code pa_projects_all.project_currency_code%type;
52: l_tot_quantity_pc_pfc NUMBER;
53: l_tot_raw_cost_pc_pfc NUMBER;
54: l_tot_brdn_cost_pc_pfc NUMBER;
55: l_tot_revenue_pc_pfc NUMBER;

Line 87: l_pfc_currency_code pa_projects_all.project_currency_code%type;

83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
84: l_act_quantity_sum NUMBER;
85:
86: /* ForPFC amounts */
87: l_pfc_currency_code pa_projects_all.project_currency_code%type;
88: l_rev_gen_method VARCHAR2(3);
89:
90:
91: /* For ETC amounts */

Line 154: g_project_name pa_projects_all.name%TYPE;

150: l_projfunc_raw_cost NUMBER;
151:
152: /* Status variable for GET_CURRENCY_AMOUNTS api */
153: l_status Varchar2(100);
154: g_project_name pa_projects_all.name%TYPE;
155:
156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(2000);
158: l_data VARCHAR2(2000);

Line 927: PA_PROJECTS_ALL WHERE

923: x_return_status := FND_API.G_RET_STS_ERROR;
924: g_project_name := NULL;
925: BEGIN
926: SELECT name INTO g_project_name from
927: PA_PROJECTS_ALL WHERE
928: project_id = p_fp_cols_tgt_rec.x_project_id;
929: EXCEPTION
930: WHEN OTHERS THEN
931: g_project_name := NULL;

Line 1238: l_pc_currency_code pa_projects_all.project_currency_code%type;

1234: l_src_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp; /* Created for bug fix 4117267*/
1235: l_cmt_count NUMBER;
1236:
1237: /* For PC amounts */
1238: l_pc_currency_code pa_projects_all.project_currency_code%type;
1239: l_cmt_quantity_pc_pfc NUMBER;
1240: l_cmt_raw_cost_pc_pfc NUMBER;
1241: l_cmt_brdn_cost_pc_pfc NUMBER;
1242: l_cmt_revenue_pc_pfc NUMBER;

Line 1248: l_pfc_currency_code pa_projects_all.project_currency_code%type;

1244: l_etc_quantity_pc_pfc NUMBER;
1245: l_etc_noncmt_quantity_pc_pfc NUMBER;
1246:
1247: /* For PFC amounts */
1248: l_pfc_currency_code pa_projects_all.project_currency_code%type;
1249: l_rev_gen_method VARCHAR2(3);
1250:
1251: /* For TC amounts */
1252: l_etc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2356: l_pc_currency_code pa_projects_all.project_currency_code%type;

2352: l_target_version_type pa_budget_versions.version_type%type;
2353: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
2354:
2355: /* For PC amounts */
2356: l_pc_currency_code pa_projects_all.project_currency_code%type;
2357: l_tot_quantity_pc_pfc NUMBER;
2358: l_tot_raw_cost_pc_pfc NUMBER;
2359: l_tot_brdn_cost_pc_pfc NUMBER;
2360: l_tot_revenue_pc_pfc NUMBER;

Line 2392: l_pfc_currency_code pa_projects_all.project_currency_code%type;

2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2389: l_act_quantity_sum NUMBER;
2390:
2391: /* ForPFC amounts */
2392: l_pfc_currency_code pa_projects_all.project_currency_code%type;
2393: l_rev_gen_method VARCHAR2(3);
2394:
2395:
2396: /* For ETC amounts */

Line 2459: g_project_name pa_projects_all.name%TYPE;

2455: l_projfunc_raw_cost NUMBER;
2456:
2457: /* Status variable for GET_CURRENCY_AMOUNTS api */
2458: l_status Varchar2(100);
2459: g_project_name pa_projects_all.name%TYPE;
2460:
2461: /* Variables for Performance Bug 4194849 */
2462: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2463: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

Line 3486: PA_PROJECTS_ALL WHERE

3482: x_return_status := FND_API.G_RET_STS_ERROR;
3483: g_project_name := NULL;
3484: BEGIN
3485: SELECT name INTO g_project_name from
3486: PA_PROJECTS_ALL WHERE
3487: project_id = p_fp_cols_tgt_rec.x_project_id;
3488: EXCEPTION
3489: WHEN OTHERS THEN
3490: g_project_name := NULL;