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_UPGRADE_PKG dependencies on PA_PROJECTS_ALL

Line 1567: project level(pa_projects_all) for the plan type and plan version fp options if

1563: This process will create record in pa_proj_fp_options table for the project,
1564: plan type and plan version levels. It will create fp option only at the level
1565: for which this api is called.
1566: Bug#2731534: The api has been modified to default MC conversion attributes from
1567: project level(pa_projects_all) for the plan type and plan version fp options if
1568: Project currency <> Projfunc Currency for the project.
1569: ===============================================================================*/
1570: PROCEDURE Create_fp_options(
1571: p_project_id IN pa_proj_fp_options.project_id%TYPE

Line 1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:

Line 1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:

Line 1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:
1603: BEGIN

Line 1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:
1603: BEGIN
1604:

Line 3227: not find cost conversion attributes in pa_projects_all, then get

3223:
3224: Bug#2731534. Checking billing flag doesn't suffice the availablity
3225: of the conversion attributes for the project. It takes care of the
3226: revenue conversion attributes only. For cost attributes, if we do
3227: not find cost conversion attributes in pa_projects_all, then get
3228: them from the implementations table for the project's OU and if
3229: we do not find them there then raise exception for the project.
3230: ==================================================================*/
3231:

Line 3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

3244: l_return_status VARCHAR2(2000);
3245: l_debug_mode VARCHAR2(30);
3246:
3247:
3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

3245: l_debug_mode VARCHAR2(30);
3246:
3247:
3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

3246:
3247:
3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

3247:
3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3255:

Line 3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

3248: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3255:
3256: BEGIN

Line 3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

3249: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3255:
3256: BEGIN
3257:

Line 3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

3250: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3251: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3252: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3253: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3254: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3255:
3256: BEGIN
3257:
3258: x_msg_count := 0;

Line 3296: /* This api fetches the cost rate types from pa_projects_all table,

3292: x_validation_status := 'Y';
3293:
3294: -- Fetch the project currencies, MCB flag and cost rate types
3295:
3296: /* This api fetches the cost rate types from pa_projects_all table,
3297: if they aren't defined for project level then they are fetched from
3298: pa_implementations table */
3299:
3300: PA_FIN_PLAN_UTILS.Get_Project_Curr_Attributes