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_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 2357: l_pc_currency_code pa_projects_all.project_currency_code%type;

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

Line 2393: l_pfc_currency_code pa_projects_all.project_currency_code%type;

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

Line 2460: g_project_name pa_projects_all.name%TYPE;

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

Line 3500: PA_PROJECTS_ALL WHERE

3496: x_return_status := FND_API.G_RET_STS_ERROR;
3497: g_project_name := NULL;
3498: BEGIN
3499: SELECT name INTO g_project_name from
3500: PA_PROJECTS_ALL WHERE
3501: project_id = p_fp_cols_tgt_rec.x_project_id;
3502: EXCEPTION
3503: WHEN OTHERS THEN
3504: g_project_name := NULL;

Line 3765: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3761: l_txn_currency_flag varchar2(1) := 'Y';
3762:
3763: -- Cursor For fully coping budget lines from source.
3764: CURSOR fcst_budget_line_src_tgt_all
3765: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3766: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3767: c_target_bv_id NUMBER,
3768: c_project_id NUMBER ) IS
3769: SELECT ra.resource_assignment_id,

Line 3766: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3762:
3763: -- Cursor For fully coping budget lines from source.
3764: CURSOR fcst_budget_line_src_tgt_all
3765: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3766: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3767: c_target_bv_id NUMBER,
3768: c_project_id NUMBER ) IS
3769: SELECT ra.resource_assignment_id,
3770: ra.rate_based_flag,

Line 3832: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3828: NULL;
3829:
3830: -- This cursor is used to copy budget lines when one of the source has same time phase.
3831: CURSOR fcst_budget_line_src_tgt_ptl
3832: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3833: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3834: c_target_bv_id NUMBER,
3835: c_project_id NUMBER,
3836: c_gen_source VARCHAR2 ) IS

Line 3833: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3829:
3830: -- This cursor is used to copy budget lines when one of the source has same time phase.
3831: CURSOR fcst_budget_line_src_tgt_ptl
3832: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3833: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3834: c_target_bv_id NUMBER,
3835: c_project_id NUMBER,
3836: c_gen_source VARCHAR2 ) IS
3837: SELECT ra.resource_assignment_id,

Line 3900: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3896:
3897: -- This cursor will summ the budget lines when the source time phase is diff and source period span is
3898: -- smaller than destination based on the one of the plans which has issue.
3899: CURSOR fcst_bdgt_line_src_tgt_sum
3900: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3901: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3902: c_target_bv_id NUMBER,
3903: c_project_id NUMBER,
3904: c_time_phase VARCHAR2 ) IS

Line 3901: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3897: -- This cursor will summ the budget lines when the source time phase is diff and source period span is
3898: -- smaller than destination based on the one of the plans which has issue.
3899: CURSOR fcst_bdgt_line_src_tgt_sum
3900: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3901: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3902: c_target_bv_id NUMBER,
3903: c_project_id NUMBER,
3904: c_time_phase VARCHAR2 ) IS
3905: SELECT ra.resource_assignment_id,

Line 3972: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3968:
3969: -- This cursor will summ the budget lines when the source time phase is diff and source period span is
3970: -- smaller than destination based on the one of the plans which has issue.
3971: CURSOR fcst_bdgt_line_src_tgt_sum_ptl
3972: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3973: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3974: c_target_bv_id NUMBER,
3975: c_project_id NUMBER,
3976: c_gen_source VARCHAR2,

Line 3973: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3969: -- This cursor will summ the budget lines when the source time phase is diff and source period span is
3970: -- smaller than destination based on the one of the plans which has issue.
3971: CURSOR fcst_bdgt_line_src_tgt_sum_ptl
3972: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3973: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3974: c_target_bv_id NUMBER,
3975: c_project_id NUMBER,
3976: c_gen_source VARCHAR2,
3977: c_time_phase VARCHAR2 ) IS

Line 4045: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

4041:
4042: -- This cursor will distribute the source budget amounts into the destination budget lines uniformly such
4043: -- destinations end periods fall in the source period span when source period span is greater than dest.
4044: CURSOR fcst_bdgt_line_src_tgt_dist
4045: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4046: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4047: c_target_bv_id NUMBER,
4048: c_project_id NUMBER,
4049: c_time_phase VARCHAR2 ) IS

Line 4046: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

4042: -- This cursor will distribute the source budget amounts into the destination budget lines uniformly such
4043: -- destinations end periods fall in the source period span when source period span is greater than dest.
4044: CURSOR fcst_bdgt_line_src_tgt_dist
4045: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4046: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4047: c_target_bv_id NUMBER,
4048: c_project_id NUMBER,
4049: c_time_phase VARCHAR2 ) IS
4050: SELECT ra.resource_assignment_id,

Line 4117: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

4113:
4114: -- This cursor will distribute the source budget amounts into the destination budget lines uniformly such
4115: -- destinations end periods fall in the source period span when source period span is greater than dest.
4116: CURSOR fcst_bdgt_line_src_tgt_dist_pt
4117: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4118: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4119: c_target_bv_id NUMBER,
4120: c_project_id NUMBER,
4121: c_gen_source VARCHAR2,

Line 4118: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

4114: -- This cursor will distribute the source budget amounts into the destination budget lines uniformly such
4115: -- destinations end periods fall in the source period span when source period span is greater than dest.
4116: CURSOR fcst_bdgt_line_src_tgt_dist_pt
4117: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4118: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
4119: c_target_bv_id NUMBER,
4120: c_project_id NUMBER,
4121: c_gen_source VARCHAR2,
4122: c_time_phase VARCHAR2 ) IS