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_WEBADI_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1855: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

1851:
1852: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1853: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;
1854: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
1856: l_not_null_period_cnt NUMBER;
1857: l_fix_sc_amt_pd_curr_index NUMBER; /* to get the period index for which amount is present if the spread curve */
1858: l_fix_sc_amt_pd_next_index NUMBER; /* associated with the resource is fixed date type */
1859:

Line 1875: l_ra_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE; -- Bug 5068203.

1871: l_ratxn_etc_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1872: l_ratxn_etc_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1873: l_ratxn_etc_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1874: l_ratxn_etc_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1875: l_ra_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE; -- Bug 5068203.
1876:
1877:
1878: -- cursor to get the start/end date of the first period before the first period displayed in the period mask
1879: CURSOR l_first_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,

Line 1925: c_task_id IN pa_resource_assignments.task_id%TYPE,

1921: new entity pa_resource_asgn_curr. This is done as part of merging MRUP3 changes done in 11i
1922: into R12.
1923: */
1924: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1925: c_task_id IN pa_resource_assignments.task_id%TYPE,
1926: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1927: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)
1928: IS
1929: SELECT rac.total_display_quantity,

Line 1926: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

1922: into R12.
1923: */
1924: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1925: c_task_id IN pa_resource_assignments.task_id%TYPE,
1926: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1927: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)
1928: IS
1929: SELECT rac.total_display_quantity,
1930: rac.total_txn_raw_cost,

Line 1942: pa_resource_assignments pra

1938: rac.txn_burden_cost_rate_override,
1939: rac.txn_bill_rate_override,
1940: pra.rate_based_flag
1941: FROM pa_resource_asgn_curr rac,
1942: pa_resource_assignments pra
1943: WHERE rac.budget_version_id = c_budget_version_id
1944: AND rac.budget_version_id = pra.budget_version_id
1945: AND rac.resource_assignment_id = pra.resource_assignment_id
1946: AND pra.task_id = c_task_id

Line 1954: l_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

1950: TYPE l_cached_ra_id_info IS TABLE OF NUMBER INDEX BY VARCHAR2(32);
1951:
1952: l_cached_ra_id_tbl l_cached_ra_id_info;
1953: l_cached_ra_index VARCHAR2(32);
1954: l_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
1955: l_start_ra_index NUMBER :=1;
1956: l_end_ra_index NUMBER :=1;
1957: l_sp_fix_prd_st_dt DATE;
1958: l_sp_fix_prd_en_dt DATE;

Line 1960: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;

1956: l_end_ra_index NUMBER :=1;
1957: l_sp_fix_prd_st_dt DATE;
1958: l_sp_fix_prd_en_dt DATE;
1959:
1960: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1961: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1962: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1963:
1964: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1961: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

1957: l_sp_fix_prd_st_dt DATE;
1958: l_sp_fix_prd_en_dt DATE;
1959:
1960: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1961: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1962: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1963:
1964: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1965: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 1962: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;

1958: l_sp_fix_prd_en_dt DATE;
1959:
1960: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1961: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1962: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1963:
1964: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1965: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1966: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2955: -- deriving planning dates and spread curve information from pa_resource_assignments for existing RAs

2951: l_cached_ra_index := 'T' || l_inf_tbl_data_curr_rec.task_id || 'R' || l_inf_tbl_data_curr_rec.resource_list_member_id;
2952:
2953: -- checking if the RA is an existing one or a new one
2954: IF NOT l_cached_ra_id_tbl.EXISTS(l_cached_ra_index) THEN
2955: -- deriving planning dates and spread curve information from pa_resource_assignments for existing RAs
2956: -- or from pa_resource_list_members for new RAs.
2957: BEGIN
2958: SELECT resource_assignment_id,
2959: planning_start_date,

Line 2974: FROM pa_resource_assignments

2970: l_sp_fixed_date,
2971: l_rbs_elem_id,
2972: l_res_class_code,
2973: l_rate_based_flag
2974: FROM pa_resource_assignments
2975: WHERE project_id = p_version_info_rec.x_project_id
2976: AND budget_version_id = p_version_info_rec.x_budget_version_id
2977: AND task_id = l_inf_tbl_data_curr_rec.task_id
2978: AND resource_list_member_id = l_inf_tbl_data_curr_rec.resource_list_member_id

Line 6300: pa_resource_assignments pra

6296: l_fcst_revenue_tbl,
6297: l_etc_revenue_tbl,
6298: l_txn_currency_code_tbl
6299: FROM pa_budget_lines pbl,
6300: pa_resource_assignments pra
6301: WHERE pra.budget_version_id=p_budget_version_id
6302: AND pra.project_id=p_project_id
6303: AND pra.task_id=p_task_id
6304: AND pra.resource_list_member_id=p_resource_list_member_id

Line 6353: pa_resource_assignments pra

6349: l_txn_currency_code_tbl,
6350: l_start_date_tbl,
6351: l_end_date_tbl
6352: FROM pa_budget_lines pbl,
6353: pa_resource_assignments pra
6354: WHERE pra.budget_version_id=p_budget_version_id
6355: AND pra.project_id=p_project_id
6356: AND pra.task_id=p_task_id
6357: AND pra.resource_list_member_id=p_resource_list_member_id

Line 6796: l_skip_task_id pa_resource_assignments.task_id%TYPE;

6792: l_tmp_burd_cost NUMBER;
6793: l_tmp_revenue NUMBER;
6794: l_allow_qty_flag VARCHAR2(1);
6795: l_skip_ra_flag VARCHAR2(1);
6796: l_skip_task_id pa_resource_assignments.task_id%TYPE;
6797: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
6798:
6799:
6800: --These tbls will be prepared in this manner

Line 6797: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

6793: l_tmp_revenue NUMBER;
6794: l_allow_qty_flag VARCHAR2(1);
6795: l_skip_ra_flag VARCHAR2(1);
6796: l_skip_task_id pa_resource_assignments.task_id%TYPE;
6797: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
6798:
6799:
6800: --These tbls will be prepared in this manner
6801: ----First element is for the proceeding bucket . Next p_prd_mask_st_date_tbl.COUNT buckets will contain

Line 8175: l_new_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

8171: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8172:
8173:
8174: -- for budget line context to spread the amounts
8175: l_new_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
8176: l_calc_calling_context VARCHAR2(30);
8177:
8178: -- variables used to call update_reporting_lines
8179: l_pji_res_ass_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8207: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;

8203: l_distinct_new_ra_tbl varchar_32_indexed_num_tbl_typ;
8204: l_distinct_new_ra_index VARCHAR2(32);
8205:
8206:
8207: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8208: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8209: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8210:
8211: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;

Line 8208: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;

8204: l_distinct_new_ra_index VARCHAR2(32);
8205:
8206:
8207: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8208: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8209: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8210:
8211: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
8212: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;

Line 8209: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

8205:
8206:
8207: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8208: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8209: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8210:
8211: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
8212: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
8213: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;

Line 8742: --Note down the current value of pa_resource_assignments_s.nextval

8738: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8739: END IF;
8740: -- Calling add_planning_transaction for those records for which RA doesnot exists
8741:
8742: --Note down the current value of pa_resource_assignments_s.nextval
8743: BEGIN
8744: --log1('----- STAGE PBL15-------');
8745: SELECT pa_resource_assignments_s.nextval
8746: INTO l_curr_ra_id_seq

Line 8745: SELECT pa_resource_assignments_s.nextval

8741:
8742: --Note down the current value of pa_resource_assignments_s.nextval
8743: BEGIN
8744: --log1('----- STAGE PBL15-------');
8745: SELECT pa_resource_assignments_s.nextval
8746: INTO l_curr_ra_id_seq
8747: FROM DUAL
8748: WHERE 1 = 1;
8749: --log1('----- STAGE PBL16-------');

Line 8805: FROM pa_resource_assignments pra

8801: INTO l_new_ra_id,
8802: l_new_res_asg_rbs_elem_id,
8803: l_new_res_asg_res_class_code,
8804: l_new_res_asg_rate_based_flag
8805: FROM pa_resource_assignments pra
8806: WHERE pra.budget_version_id = p_budget_version_id
8807: AND pra.project_id = p_version_info_rec.x_project_id
8808: AND pra.task_id = l_task_id_tbl(i)
8809: AND pra.resource_list_member_id = l_rlm_id_tbl(i)

Line 11876: FROM pa_resource_assignments pra,

11872: pftc.project_cost_exchange_rate project_cost_exchange_rate,
11873: pftc.project_rev_exchange_rate project_rev_exchange_rate,
11874: pftc.projfunc_cost_exchange_rate projfunc_cost_exchange_rate,
11875: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate
11876: FROM pa_resource_assignments pra,
11877: pa_resource_asgn_curr prac,
11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,