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_ASGN_CURR

Line 1861: pa_resource_asgn_curr columns. This is done as part of merging MRUP3 changes done

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:
1860: /* Bug 5144013: The following variable declarations are made to refer the new entity
1861: pa_resource_asgn_curr columns. This is done as part of merging MRUP3 changes done
1862: in 11i into R12.
1863: */
1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;

Line 1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;

1860: /* Bug 5144013: The following variable declarations are made to refer the new entity
1861: pa_resource_asgn_curr columns. This is done as part of merging MRUP3 changes done
1862: in 11i into R12.
1863: */
1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;

Line 1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;

1861: pa_resource_asgn_curr columns. This is done as part of merging MRUP3 changes done
1862: in 11i into R12.
1863: */
1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;

Line 1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;

1862: in 11i into R12.
1863: */
1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;

Line 1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;

1863: */
1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
1871: l_ratxn_etc_quantity pa_resource_asgn_curr.total_quantity%TYPE;

Line 1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;

1864: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;
1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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;

Line 1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;

1865: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;
1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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;

Line 1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;

1866: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;
1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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;

Line 1871: l_ratxn_etc_quantity pa_resource_asgn_curr.total_quantity%TYPE;

1867: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;
1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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.

Line 1872: l_ratxn_etc_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;

1868: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;
1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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:

Line 1873: l_ratxn_etc_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;

1869: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;
1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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:

Line 1874: l_ratxn_etc_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;

1870: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;
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

Line 1921: new entity pa_resource_asgn_curr. This is done as part of merging MRUP3 changes done in 11i

1917:
1918: l_last_pd_st_en_dt_rec l_last_pd_st_en_dt_csr%ROWTYPE;
1919:
1920: /* Bug 5144013: Made changes in the query of the cursor non_prd_lyt_null_val_cur to refer to the
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,

Line 1927: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)

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,
1931: rac.total_txn_burdened_cost,

Line 1941: FROM pa_resource_asgn_curr rac,

1937: rac.txn_raw_cost_rate_override,
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

Line 11836: /* Bug 5144013: Changes are made in the cursor to make use of the new entity pa_resource_asgn_curr

11832: ,x_return_status OUT NOCOPY VARCHAR2
11833: ,x_msg_count OUT NOCOPY NUMBER
11834: ,x_msg_data OUT NOCOPY VARCHAR2 )
11835: IS
11836: /* Bug 5144013: Changes are made in the cursor to make use of the new entity pa_resource_asgn_curr
11837: which is introduced in MRUP3 of 11i. The changes are done as part of merging the MRUP3 changes
11838: done in 11i into R12.
11839: */
11840: --This Cursor is used to get Resource Assignment information associated with the budget version.

Line 11877: pa_resource_asgn_curr prac,

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,
11881: pa_resource_list_members prlm,

Line 12176: of the new entity pa_resource_asgn_curr. This is done as part of merging the MRUP3 changes done in 11i

12172:
12173: /* Bug 5144013: Commenting out the below code by which we are getting the agreement currency of the plan
12174: version if the plan version is a change order version and the approved_rev_plan_type_flag of the plan
12175: version is 'Y'. This is done as we can get the the currencies from the cursor res_ass_cur by making use
12176: of the new entity pa_resource_asgn_curr. This is done as part of merging the MRUP3 changes done in 11i
12177: into R12
12178: */
12179: /* --Bug 5144013.
12180: --Getting CI Id and Approved Revenue Flag of the budget version and storing them in local variables.