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 1857: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

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

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

1873: l_ratxn_etc_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1874: l_ratxn_etc_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1875: l_ratxn_etc_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1876: l_ratxn_etc_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1877: l_ra_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE; -- Bug 5068203.
1878:
1879: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
1880:
1881:

Line 1929: c_task_id IN pa_resource_assignments.task_id%TYPE,

1925: new entity pa_resource_asgn_curr. This is done as part of merging MRUP3 changes done in 11i
1926: into R12.
1927: */
1928: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1929: c_task_id IN pa_resource_assignments.task_id%TYPE,
1930: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1931: c_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE,
1932: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)
1933: IS

Line 1930: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

1926: into R12.
1927: */
1928: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1929: c_task_id IN pa_resource_assignments.task_id%TYPE,
1930: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1931: c_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE,
1932: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)
1933: IS
1934: SELECT rac.total_display_quantity,

Line 1931: c_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE,

1927: */
1928: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1929: c_task_id IN pa_resource_assignments.task_id%TYPE,
1930: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1931: c_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE,
1932: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)
1933: IS
1934: SELECT rac.total_display_quantity,
1935: rac.total_txn_raw_cost,

Line 1947: pa_resource_assignments pra

1943: rac.txn_burden_cost_rate_override,
1944: rac.txn_bill_rate_override,
1945: pra.rate_based_flag
1946: FROM pa_resource_asgn_curr rac,
1947: pa_resource_assignments pra
1948: WHERE rac.budget_version_id = c_budget_version_id
1949: AND rac.budget_version_id = pra.budget_version_id
1950: AND rac.resource_assignment_id = pra.resource_assignment_id
1951: AND pra.task_id = c_task_id

Line 1960: l_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

1956: TYPE l_cached_ra_id_info IS TABLE OF NUMBER INDEX BY VARCHAR2(32);
1957:
1958: l_cached_ra_id_tbl l_cached_ra_id_info;
1959: l_cached_ra_index VARCHAR2(32);
1960: l_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
1961: l_start_ra_index NUMBER :=1;
1962: l_end_ra_index NUMBER :=1;
1963: l_sp_fix_prd_st_dt DATE;
1964: l_sp_fix_prd_en_dt DATE;

Line 1966: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;

1962: l_end_ra_index NUMBER :=1;
1963: l_sp_fix_prd_st_dt DATE;
1964: l_sp_fix_prd_en_dt DATE;
1965:
1966: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1967: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1969:
1970: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1967: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

1963: l_sp_fix_prd_st_dt DATE;
1964: l_sp_fix_prd_en_dt DATE;
1965:
1966: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1967: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1969:
1970: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1971: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;

1964: l_sp_fix_prd_en_dt DATE;
1965:
1966: l_res_class_code pa_resource_assignments.resource_class_code%TYPE;
1967: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1969:
1970: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1971: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1972: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 1976: l_cbs_elem_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106

1972: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1973: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1974:
1975: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
1976: l_cbs_elem_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106
1977:
1978: l_min_ra_plan_start_date DATE;
1979: l_max_ra_plan_end_date DATE;
1980:

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

3005: l_cached_ra_index := 'T' || l_inf_tbl_data_curr_rec.task_id || 'R' || l_inf_tbl_data_curr_rec.resource_list_member_id;
3006:
3007: -- checking if the RA is an existing one or a new one
3008: IF NOT l_cached_ra_id_tbl.EXISTS(l_cached_ra_index) THEN
3009: -- deriving planning dates and spread curve information from pa_resource_assignments for existing RAs
3010: -- or from pa_resource_list_members for new RAs.
3011: BEGIN
3012: SELECT resource_assignment_id,
3013: planning_start_date,

Line 3030: FROM pa_resource_assignments

3026: l_rbs_elem_id,
3027: l_cbs_elem_id, -- cbs enhancement changes bug#16445106
3028: l_res_class_code,
3029: l_rate_based_flag
3030: FROM pa_resource_assignments
3031: WHERE project_id = p_version_info_rec.x_project_id
3032: AND budget_version_id = p_version_info_rec.x_budget_version_id
3033: AND task_id = l_inf_tbl_data_curr_rec.task_id
3034: AND resource_list_member_id = l_inf_tbl_data_curr_rec.resource_list_member_id

Line 6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106

6161: (p_project_id IN pa_projects_all.project_id%TYPE,
6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6163: p_task_id IN pa_tasks.task_id%TYPE,
6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106
6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6167: p_line_start_date IN DATE,
6168: p_line_end_date IN DATE,
6169: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

Line 6405: pa_resource_assignments pra

6401: l_fcst_revenue_tbl,
6402: l_etc_revenue_tbl,
6403: l_txn_currency_code_tbl
6404: FROM pa_budget_lines pbl,
6405: pa_resource_assignments pra
6406: WHERE pra.budget_version_id=p_budget_version_id
6407: AND pra.project_id=p_project_id
6408: AND pra.task_id=p_task_id
6409: AND pra.resource_list_member_id=p_resource_list_member_id

Line 6459: pa_resource_assignments pra

6455: l_txn_currency_code_tbl,
6456: l_start_date_tbl,
6457: l_end_date_tbl
6458: FROM pa_budget_lines pbl,
6459: pa_resource_assignments pra
6460: WHERE pra.budget_version_id=p_budget_version_id
6461: AND pra.project_id=p_project_id
6462: AND pra.task_id=p_task_id
6463: AND pra.resource_list_member_id=p_resource_list_member_id

Line 6906: l_skip_task_id pa_resource_assignments.task_id%TYPE;

6902: l_tmp_burd_cost NUMBER;
6903: l_tmp_revenue NUMBER;
6904: l_allow_qty_flag VARCHAR2(1);
6905: l_skip_ra_flag VARCHAR2(1);
6906: l_skip_task_id pa_resource_assignments.task_id%TYPE;
6907: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
6908: l_skip_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106
6909:
6910: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106

Line 6907: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

6903: l_tmp_revenue NUMBER;
6904: l_allow_qty_flag VARCHAR2(1);
6905: l_skip_ra_flag VARCHAR2(1);
6906: l_skip_task_id pa_resource_assignments.task_id%TYPE;
6907: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
6908: l_skip_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106
6909:
6910: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
6911:

Line 6908: l_skip_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106

6904: l_allow_qty_flag VARCHAR2(1);
6905: l_skip_ra_flag VARCHAR2(1);
6906: l_skip_task_id pa_resource_assignments.task_id%TYPE;
6907: l_skip_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
6908: l_skip_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;-- cbs enhancement changes bug#16445106
6909:
6910: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
6911:
6912:

Line 8328: l_new_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8325:
8326:
8327: -- for budget line context to spread the amounts
8328: l_new_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
8329: l_calc_calling_context VARCHAR2(30);
8330:
8331: -- variables used to call update_reporting_lines
8332: l_pji_res_ass_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8360: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;

8356: l_distinct_new_ra_tbl varchar_32_indexed_num_tbl_typ;
8357: l_distinct_new_ra_index VARCHAR2(32);
8358:
8359:
8360: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8361: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8362: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8363:
8364: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;

Line 8361: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;

8357: l_distinct_new_ra_index VARCHAR2(32);
8358:
8359:
8360: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8361: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8362: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8363:
8364: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
8365: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;

Line 8362: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

8358:
8359:
8360: l_new_res_asg_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
8361: l_new_res_asg_res_class_code pa_resource_assignments.resource_class_code%TYPE;
8362: l_new_res_asg_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8363:
8364: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
8365: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
8366: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;

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

8902: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8903: END IF;
8904: -- Calling add_planning_transaction for those records for which RA doesnot exists
8905:
8906: --Note down the current value of pa_resource_assignments_s.nextval
8907: BEGIN
8908: --log1('----- STAGE PBL15-------');
8909: SELECT pa_resource_assignments_s.nextval
8910: INTO l_curr_ra_id_seq

Line 8909: SELECT pa_resource_assignments_s.nextval

8905:
8906: --Note down the current value of pa_resource_assignments_s.nextval
8907: BEGIN
8908: --log1('----- STAGE PBL15-------');
8909: SELECT pa_resource_assignments_s.nextval
8910: INTO l_curr_ra_id_seq
8911: FROM DUAL
8912: WHERE 1 = 1;
8913: --log1('----- STAGE PBL16-------');

Line 8972: FROM pa_resource_assignments pra

8968: INTO l_new_ra_id,
8969: l_new_res_asg_rbs_elem_id,
8970: l_new_res_asg_res_class_code,
8971: l_new_res_asg_rate_based_flag
8972: FROM pa_resource_assignments pra
8973: WHERE pra.budget_version_id = p_budget_version_id
8974: AND pra.project_id = p_version_info_rec.x_project_id
8975: AND pra.task_id = l_task_id_tbl(i)
8976: AND pra.resource_list_member_id = l_rlm_id_tbl(i)

Line 12109: FROM pa_resource_assignments pra,

12105: pftc.projfunc_cost_exchange_rate projfunc_cost_exchange_rate,
12106: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate,
12107: (select COST_CODE from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code, -- cbs enhancement changes bug#16445106
12108: (select COST_CODE_NAME from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code_name -- cbs enhancement changes bug#16445106
12109: FROM pa_resource_assignments pra,
12110: pa_resource_asgn_curr prac,
12111: pa_fp_txn_currencies pftc,
12112: pa_proj_elements pe,
12113: pa_proj_element_versions pev,