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_VIEW_PLANS_UTIL dependencies on PA_PROJ_PERIODS_DENORM

Line 683: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895

679: /* --------------------------------------------------------------------- */
680:
681: procedure assign_default_amount
682: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
683: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
684: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
685: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
686: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
687: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 684: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895

680:
681: procedure assign_default_amount
682: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
683: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
684: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
685: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
686: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
687: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
688: is

Line 697: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;

693: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
694: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
695: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
696:
697: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;
698: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;
699: l_msg_count NUMBER := 0;
700: BEGIN
701: select DECODE(fin_plan_preference_code,

Line 698: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;

694: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
695: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
696:
697: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;
698: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;
699: l_msg_count NUMBER := 0;
700: BEGIN
701: select DECODE(fin_plan_preference_code,
702: 'COST_ONLY', cost_amount_set_id,

Line 809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

805:
806: function get_period_n_value
807: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
808: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
810: p_project_currency_type IN VARCHAR2,
811: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
812: p_period_number IN NUMBER) return NUMBER
813: is

Line 811: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

807: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
808: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
810: p_project_currency_type IN VARCHAR2,
811: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
812: p_period_number IN NUMBER) return NUMBER
813: is
814: l_return_value NUMBER;
815:

Line 978: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

974: -- p_period_number=14 --> succeeding_periods_amount
975: function get_period_n_value
976: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
977: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
978: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
979: p_project_currency_type IN VARCHAR2,
980: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
981: p_period_number IN NUMBER) return NUMBER
982: is

Line 980: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

976: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
977: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
978: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
979: p_project_currency_type IN VARCHAR2,
980: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
981: p_period_number IN NUMBER) return NUMBER
982: is
983: l_return_value NUMBER;
984:

Line 1048: pa_proj_periods_denorm pppd

1044: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1045: null))
1046: into l_return_value
1047: from pa_proj_period_profiles pppp,
1048: pa_proj_periods_denorm pppd
1049: where pppp.period_profile_id = p_period_profile_id and
1050: pppp.period_profile_id=pppd.period_profile_id and
1051: pppd.budget_version_id = p_budget_version_id and
1052: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1115: pa_proj_periods_denorm pppd

1111: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1112: null))
1113: into l_return_value
1114: from pa_proj_period_profiles pppp,
1115: pa_proj_periods_denorm pppd
1116: where pppp.period_profile_id = p_period_profile_id and
1117: pppp.period_profile_id=pppd.period_profile_id and
1118: pppd.budget_version_id = p_budget_version_id and
1119: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1182: pa_proj_periods_denorm pppd

1178: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1179: null))
1180: into l_return_value
1181: from pa_proj_period_profiles pppp,
1182: pa_proj_periods_denorm pppd
1183: where pppp.period_profile_id = p_period_profile_id and
1184: pppp.period_profile_id=pppd.period_profile_id and
1185: pppd.budget_version_id = p_budget_version_id and
1186: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1249: pa_proj_periods_denorm pppd

1245: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1246: null))
1247: into l_return_value
1248: from pa_proj_period_profiles pppp,
1249: pa_proj_periods_denorm pppd
1250: where pppp.period_profile_id = p_period_profile_id and
1251: pppp.period_profile_id=pppd.period_profile_id and
1252: pppd.budget_version_id = p_budget_version_id and
1253: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1316: pa_proj_periods_denorm pppd

1312: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1313: null))
1314: into l_return_value
1315: from pa_proj_period_profiles pppp,
1316: pa_proj_periods_denorm pppd
1317: where pppp.period_profile_id = p_period_profile_id and
1318: pppp.period_profile_id=pppd.period_profile_id and
1319: pppd.budget_version_id = p_budget_version_id and
1320: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1383: pa_proj_periods_denorm pppd

1379: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1380: null))
1381: into l_return_value
1382: from pa_proj_period_profiles pppp,
1383: pa_proj_periods_denorm pppd
1384: where pppp.period_profile_id = p_period_profile_id and
1385: pppp.period_profile_id=pppd.period_profile_id and
1386: pppd.budget_version_id = p_budget_version_id and
1387: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1450: pa_proj_periods_denorm pppd

1446: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1447: null))
1448: into l_return_value
1449: from pa_proj_period_profiles pppp,
1450: pa_proj_periods_denorm pppd
1451: where pppp.period_profile_id = p_period_profile_id and
1452: pppp.period_profile_id=pppd.period_profile_id and
1453: pppd.budget_version_id = p_budget_version_id and
1454: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1517: pa_proj_periods_denorm pppd

1513: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1514: null))
1515: into l_return_value
1516: from pa_proj_period_profiles pppp,
1517: pa_proj_periods_denorm pppd
1518: where pppp.period_profile_id = p_period_profile_id and
1519: pppp.period_profile_id=pppd.period_profile_id and
1520: pppd.budget_version_id = p_budget_version_id and
1521: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1584: pa_proj_periods_denorm pppd

1580: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1581: null))
1582: into l_return_value
1583: from pa_proj_period_profiles pppp,
1584: pa_proj_periods_denorm pppd
1585: where pppp.period_profile_id = p_period_profile_id and
1586: pppp.period_profile_id=pppd.period_profile_id and
1587: pppd.budget_version_id = p_budget_version_id and
1588: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1651: pa_proj_periods_denorm pppd

1647: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1648: null))
1649: into l_return_value
1650: from pa_proj_period_profiles pppp,
1651: pa_proj_periods_denorm pppd
1652: where pppp.period_profile_id = p_period_profile_id and
1653: pppp.period_profile_id=pppd.period_profile_id and
1654: pppd.budget_version_id = p_budget_version_id and
1655: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1718: pa_proj_periods_denorm pppd

1714: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1715: null))
1716: into l_return_value
1717: from pa_proj_period_profiles pppp,
1718: pa_proj_periods_denorm pppd
1719: where pppp.period_profile_id = p_period_profile_id and
1720: pppp.period_profile_id=pppd.period_profile_id and
1721: pppd.budget_version_id = p_budget_version_id and
1722: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1785: pa_proj_periods_denorm pppd

1781: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1782: null))
1783: into l_return_value
1784: from pa_proj_period_profiles pppp,
1785: pa_proj_periods_denorm pppd
1786: where pppp.period_profile_id = p_period_profile_id and
1787: pppp.period_profile_id=pppd.period_profile_id and
1788: pppd.budget_version_id = p_budget_version_id and
1789: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1852: pa_proj_periods_denorm pppd

1848: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1849: null))
1850: into l_return_value
1851: from pa_proj_period_profiles pppp,
1852: pa_proj_periods_denorm pppd
1853: where pppp.period_profile_id = p_period_profile_id and
1854: pppp.period_profile_id=pppd.period_profile_id and
1855: pppd.budget_version_id = p_budget_version_id and
1856: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1865: pa_proj_periods_denorm pppd

1861: elsif p_period_number = 0 then
1862: select SUM(nvl(pppd.preceding_periods_amount,0))
1863: into l_return_value
1864: from pa_proj_period_profiles pppp,
1865: pa_proj_periods_denorm pppd
1866: where pppp.period_profile_id = p_period_profile_id and
1867: pppp.period_profile_id=pppd.period_profile_id and
1868: pppd.budget_version_id = p_budget_version_id and
1869: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1878: pa_proj_periods_denorm pppd

1874: elsif p_period_number = 14 then
1875: select SUM(nvl(pppd.succeeding_periods_amount,0))
1876: into l_return_value
1877: from pa_proj_period_profiles pppp,
1878: pa_proj_periods_denorm pppd
1879: where pppp.period_profile_id = p_period_profile_id and
1880: pppp.period_profile_id=pppd.period_profile_id and
1881: pppd.budget_version_id = p_budget_version_id and
1882: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1914: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

1910: * ORG FORECASTING VALUES
1911:
1912: function get_period_n_value
1913: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1914: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1915: p_project_currency_type IN VARCHAR2,
1916: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1917: p_period_number IN NUMBER) return NUMBER
1918: is

Line 1916: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

1912: function get_period_n_value
1913: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1914: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1915: p_project_currency_type IN VARCHAR2,
1916: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1917: p_period_number IN NUMBER) return NUMBER
1918: is
1919: l_return_value NUMBER;
1920:

Line 2140: pa_proj_periods_denorm pppd

2136: 120, -pppd.period_amount52,
2137: pppd.period_amount52),0))
2138: into l_return_value
2139: from pa_proj_period_profiles pppp,
2140: pa_proj_periods_denorm pppd
2141: where pppp.period_profile_id = p_period_profile_id and
2142: pppp.period_profile_id=pppd.period_profile_id and
2143: pppd.amount_type_id = p_amount_type_id and
2144: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2360: pa_proj_periods_denorm pppd

2356: 120, -pppd.period_amount52,
2357: pppd.period_amount52),0))
2358: into l_return_value
2359: from pa_proj_period_profiles pppp,
2360: pa_proj_periods_denorm pppd
2361: where pppp.period_profile_id = p_period_profile_id and
2362: pppp.period_profile_id=pppd.period_profile_id and
2363: pppd.amount_type_id = p_amount_type_id and
2364: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2580: pa_proj_periods_denorm pppd

2576: 120, -pppd.period_amount52,
2577: pppd.period_amount52),0))
2578: into l_return_value
2579: from pa_proj_period_profiles pppp,
2580: pa_proj_periods_denorm pppd
2581: where pppp.period_profile_id = p_period_profile_id and
2582: pppp.period_profile_id=pppd.period_profile_id and
2583: pppd.amount_type_id = p_amount_type_id and
2584: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2800: pa_proj_periods_denorm pppd

2796: 120, -pppd.period_amount52,
2797: pppd.period_amount52),0))
2798: into l_return_value
2799: from pa_proj_period_profiles pppp,
2800: pa_proj_periods_denorm pppd
2801: where pppp.period_profile_id = p_period_profile_id and
2802: pppp.period_profile_id=pppd.period_profile_id and
2803: pppd.amount_type_id = p_amount_type_id and
2804: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3020: pa_proj_periods_denorm pppd

3016: 120, -pppd.period_amount52,
3017: pppd.period_amount52),0))
3018: into l_return_value
3019: from pa_proj_period_profiles pppp,
3020: pa_proj_periods_denorm pppd
3021: where pppp.period_profile_id = p_period_profile_id and
3022: pppp.period_profile_id=pppd.period_profile_id and
3023: pppd.amount_type_id = p_amount_type_id and
3024: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3240: pa_proj_periods_denorm pppd

3236: 120, -pppd.period_amount52,
3237: pppd.period_amount52),0))
3238: into l_return_value
3239: from pa_proj_period_profiles pppp,
3240: pa_proj_periods_denorm pppd
3241: where pppp.period_profile_id = p_period_profile_id and
3242: pppp.period_profile_id=pppd.period_profile_id and
3243: pppd.amount_type_id = p_amount_type_id and
3244: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3460: pa_proj_periods_denorm pppd

3456: 120, -pppd.period_amount52,
3457: pppd.period_amount52),0))
3458: into l_return_value
3459: from pa_proj_period_profiles pppp,
3460: pa_proj_periods_denorm pppd
3461: where pppp.period_profile_id = p_period_profile_id and
3462: pppp.period_profile_id=pppd.period_profile_id and
3463: pppd.amount_type_id = p_amount_type_id and
3464: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3680: pa_proj_periods_denorm pppd

3676: 120, -pppd.period_amount52,
3677: pppd.period_amount52),0))
3678: into l_return_value
3679: from pa_proj_period_profiles pppp,
3680: pa_proj_periods_denorm pppd
3681: where pppp.period_profile_id = p_period_profile_id and
3682: pppp.period_profile_id=pppd.period_profile_id and
3683: pppd.amount_type_id = p_amount_type_id and
3684: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3900: pa_proj_periods_denorm pppd

3896: 120, -pppd.period_amount52,
3897: pppd.period_amount52),0))
3898: into l_return_value
3899: from pa_proj_period_profiles pppp,
3900: pa_proj_periods_denorm pppd
3901: where pppp.period_profile_id = p_period_profile_id and
3902: pppp.period_profile_id=pppd.period_profile_id and
3903: pppd.amount_type_id = p_amount_type_id and
3904: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4120: pa_proj_periods_denorm pppd

4116: 120, -pppd.period_amount52,
4117: pppd.period_amount52),0))
4118: into l_return_value
4119: from pa_proj_period_profiles pppp,
4120: pa_proj_periods_denorm pppd
4121: where pppp.period_profile_id = p_period_profile_id and
4122: pppp.period_profile_id=pppd.period_profile_id and
4123: pppd.amount_type_id = p_amount_type_id and
4124: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4340: pa_proj_periods_denorm pppd

4336: 120, -pppd.period_amount52,
4337: pppd.period_amount52),0))
4338: into l_return_value
4339: from pa_proj_period_profiles pppp,
4340: pa_proj_periods_denorm pppd
4341: where pppp.period_profile_id = p_period_profile_id and
4342: pppp.period_profile_id=pppd.period_profile_id and
4343: pppd.amount_type_id = p_amount_type_id and
4344: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4560: pa_proj_periods_denorm pppd

4556: 120, -pppd.period_amount52,
4557: pppd.period_amount52),0))
4558: into l_return_value
4559: from pa_proj_period_profiles pppp,
4560: pa_proj_periods_denorm pppd
4561: where pppp.period_profile_id = p_period_profile_id and
4562: pppp.period_profile_id=pppd.period_profile_id and
4563: pppd.amount_type_id = p_amount_type_id and
4564: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4780: pa_proj_periods_denorm pppd

4776: 120, -pppd.period_amount52,
4777: pppd.period_amount52),0))
4778: into l_return_value
4779: from pa_proj_period_profiles pppp,
4780: pa_proj_periods_denorm pppd
4781: where pppp.period_profile_id = p_period_profile_id and
4782: pppp.period_profile_id=pppd.period_profile_id and
4783: pppd.amount_type_id = p_amount_type_id and
4784: pppd.resource_assignment_id = p_resource_assignment_id and