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.

[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_RESOURCE_ASGN_CURR

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

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

Line 1866: l_ratxn_total_quantity pa_resource_asgn_curr.total_quantity%TYPE;

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

Line 1867: l_ratxn_total_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;

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

Line 1868: l_ratxn_total_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;

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

Line 1869: l_ratxn_total_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;

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

Line 1870: l_ratxn_raw_cost_over_rate pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE;

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

Line 1871: l_ratxn_burden_cost_over_rate pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE;

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

Line 1872: l_ratxn_bill_over_rate pa_resource_asgn_curr.txn_bill_rate_override%TYPE;

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

Line 1873: l_ratxn_etc_quantity pa_resource_asgn_curr.total_quantity%TYPE;

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

Line 1874: l_ratxn_etc_raw_cost pa_resource_asgn_curr.total_txn_raw_cost%TYPE;

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

Line 1875: l_ratxn_etc_burdened_cost pa_resource_asgn_curr.total_txn_burdened_cost%TYPE;

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

Line 1876: l_ratxn_etc_revenue pa_resource_asgn_curr.total_txn_revenue%TYPE;

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

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

1921:
1922: l_last_pd_st_en_dt_rec l_last_pd_st_en_dt_csr%ROWTYPE;
1923:
1924: /* Bug 5144013: Made changes in the query of the cursor non_prd_lyt_null_val_cur to refer to the
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,

Line 1932: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)

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

Line 1946: FROM pa_resource_asgn_curr rac,

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

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

12063: ,x_return_status OUT NOCOPY VARCHAR2
12064: ,x_msg_count OUT NOCOPY NUMBER
12065: ,x_msg_data OUT NOCOPY VARCHAR2 )
12066: IS
12067: /* Bug 5144013: Changes are made in the cursor to make use of the new entity pa_resource_asgn_curr
12068: which is introduced in MRUP3 of 11i. The changes are done as part of merging the MRUP3 changes
12069: done in 11i into R12.
12070: */
12071: --This Cursor is used to get Resource Assignment information associated with the budget version.

Line 12110: pa_resource_asgn_curr prac,

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

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

12412:
12413: /* Bug 5144013: Commenting out the below code by which we are getting the agreement currency of the plan
12414: version if the plan version is a change order version and the approved_rev_plan_type_flag of the plan
12415: version is 'Y'. This is done as we can get the the currencies from the cursor res_ass_cur by making use
12416: of the new entity pa_resource_asgn_curr. This is done as part of merging the MRUP3 changes done in 11i
12417: into R12
12418: */
12419: /* --Bug 5144013.
12420: --Getting CI Id and Approved Revenue Flag of the budget version and storing them in local variables.