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 681: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895

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

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

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

Line 695: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;

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

Line 696: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;

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

Line 809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

805: -- p_period_number=14 --> succeeding_periods_amount
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 879: pa_proj_periods_denorm pppd

875: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
876: null))
877: into l_return_value
878: from pa_proj_period_profiles pppp,
879: pa_proj_periods_denorm pppd
880: where pppp.period_profile_id = p_period_profile_id and
881: pppp.period_profile_id=pppd.period_profile_id and
882: pppd.budget_version_id = p_budget_version_id and
883: pppd.resource_assignment_id = p_resource_assignment_id and

Line 946: pa_proj_periods_denorm pppd

942: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
943: null))
944: into l_return_value
945: from pa_proj_period_profiles pppp,
946: pa_proj_periods_denorm pppd
947: where pppp.period_profile_id = p_period_profile_id and
948: pppp.period_profile_id=pppd.period_profile_id and
949: pppd.budget_version_id = p_budget_version_id and
950: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1013: pa_proj_periods_denorm pppd

1009: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1010: null))
1011: into l_return_value
1012: from pa_proj_period_profiles pppp,
1013: pa_proj_periods_denorm pppd
1014: where pppp.period_profile_id = p_period_profile_id and
1015: pppp.period_profile_id=pppd.period_profile_id and
1016: pppd.budget_version_id = p_budget_version_id and
1017: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1080: pa_proj_periods_denorm pppd

1076: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1077: null))
1078: into l_return_value
1079: from pa_proj_period_profiles pppp,
1080: pa_proj_periods_denorm pppd
1081: where pppp.period_profile_id = p_period_profile_id and
1082: pppp.period_profile_id=pppd.period_profile_id and
1083: pppd.budget_version_id = p_budget_version_id and
1084: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1147: pa_proj_periods_denorm pppd

1143: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1144: null))
1145: into l_return_value
1146: from pa_proj_period_profiles pppp,
1147: pa_proj_periods_denorm pppd
1148: where pppp.period_profile_id = p_period_profile_id and
1149: pppp.period_profile_id=pppd.period_profile_id and
1150: pppd.budget_version_id = p_budget_version_id and
1151: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1214: pa_proj_periods_denorm pppd

1210: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1211: null))
1212: into l_return_value
1213: from pa_proj_period_profiles pppp,
1214: pa_proj_periods_denorm pppd
1215: where pppp.period_profile_id = p_period_profile_id and
1216: pppp.period_profile_id=pppd.period_profile_id and
1217: pppd.budget_version_id = p_budget_version_id and
1218: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1281: pa_proj_periods_denorm pppd

1277: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1278: null))
1279: into l_return_value
1280: from pa_proj_period_profiles pppp,
1281: pa_proj_periods_denorm pppd
1282: where pppp.period_profile_id = p_period_profile_id and
1283: pppp.period_profile_id=pppd.period_profile_id and
1284: pppd.budget_version_id = p_budget_version_id and
1285: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1348: pa_proj_periods_denorm pppd

1344: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1345: null))
1346: into l_return_value
1347: from pa_proj_period_profiles pppp,
1348: pa_proj_periods_denorm pppd
1349: where pppp.period_profile_id = p_period_profile_id and
1350: pppp.period_profile_id=pppd.period_profile_id and
1351: pppd.budget_version_id = p_budget_version_id and
1352: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1415: pa_proj_periods_denorm pppd

1411: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1412: null))
1413: into l_return_value
1414: from pa_proj_period_profiles pppp,
1415: pa_proj_periods_denorm pppd
1416: where pppp.period_profile_id = p_period_profile_id and
1417: pppp.period_profile_id=pppd.period_profile_id and
1418: pppd.budget_version_id = p_budget_version_id and
1419: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1482: pa_proj_periods_denorm pppd

1478: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1479: null))
1480: into l_return_value
1481: from pa_proj_period_profiles pppp,
1482: pa_proj_periods_denorm pppd
1483: where pppp.period_profile_id = p_period_profile_id and
1484: pppp.period_profile_id=pppd.period_profile_id and
1485: pppd.budget_version_id = p_budget_version_id and
1486: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1549: pa_proj_periods_denorm pppd

1545: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1546: null))
1547: into l_return_value
1548: from pa_proj_period_profiles pppp,
1549: pa_proj_periods_denorm pppd
1550: where pppp.period_profile_id = p_period_profile_id and
1551: pppp.period_profile_id=pppd.period_profile_id and
1552: pppd.budget_version_id = p_budget_version_id and
1553: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1616: pa_proj_periods_denorm pppd

1612: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1613: null))
1614: into l_return_value
1615: from pa_proj_period_profiles pppp,
1616: pa_proj_periods_denorm pppd
1617: where pppp.period_profile_id = p_period_profile_id and
1618: pppp.period_profile_id=pppd.period_profile_id and
1619: pppd.budget_version_id = p_budget_version_id and
1620: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1683: pa_proj_periods_denorm pppd

1679: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1680: null))
1681: into l_return_value
1682: from pa_proj_period_profiles pppp,
1683: pa_proj_periods_denorm pppd
1684: where pppp.period_profile_id = p_period_profile_id and
1685: pppp.period_profile_id=pppd.period_profile_id and
1686: pppd.budget_version_id = p_budget_version_id and
1687: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1696: pa_proj_periods_denorm pppd

1692: elsif p_period_number = 0 then
1693: select SUM(nvl(pppd.preceding_periods_amount,0))
1694: into l_return_value
1695: from pa_proj_period_profiles pppp,
1696: pa_proj_periods_denorm pppd
1697: where pppp.period_profile_id = p_period_profile_id and
1698: pppp.period_profile_id=pppd.period_profile_id and
1699: pppd.budget_version_id = p_budget_version_id and
1700: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1709: pa_proj_periods_denorm pppd

1705: elsif p_period_number = 14 then
1706: select SUM(nvl(pppd.succeeding_periods_amount,0))
1707: into l_return_value
1708: from pa_proj_period_profiles pppp,
1709: pa_proj_periods_denorm pppd
1710: where pppp.period_profile_id = p_period_profile_id and
1711: pppp.period_profile_id=pppd.period_profile_id and
1712: pppd.budget_version_id = p_budget_version_id and
1713: pppd.resource_assignment_id = p_resource_assignment_id and

Line 1744: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

1740: * ORG FORECASTING VALUES
1741:
1742: function get_period_n_value
1743: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1744: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1745: p_project_currency_type IN VARCHAR2,
1746: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1747: p_period_number IN NUMBER) return NUMBER
1748: is

Line 1746: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

1742: function get_period_n_value
1743: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1744: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1745: p_project_currency_type IN VARCHAR2,
1746: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1747: p_period_number IN NUMBER) return NUMBER
1748: is
1749: l_return_value NUMBER;
1750:

Line 1970: pa_proj_periods_denorm pppd

1966: 120, -pppd.period_amount52,
1967: pppd.period_amount52),0))
1968: into l_return_value
1969: from pa_proj_period_profiles pppp,
1970: pa_proj_periods_denorm pppd
1971: where pppp.period_profile_id = p_period_profile_id and
1972: pppp.period_profile_id=pppd.period_profile_id and
1973: pppd.amount_type_id = p_amount_type_id and
1974: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2190: pa_proj_periods_denorm pppd

2186: 120, -pppd.period_amount52,
2187: pppd.period_amount52),0))
2188: into l_return_value
2189: from pa_proj_period_profiles pppp,
2190: pa_proj_periods_denorm pppd
2191: where pppp.period_profile_id = p_period_profile_id and
2192: pppp.period_profile_id=pppd.period_profile_id and
2193: pppd.amount_type_id = p_amount_type_id and
2194: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2410: pa_proj_periods_denorm pppd

2406: 120, -pppd.period_amount52,
2407: pppd.period_amount52),0))
2408: into l_return_value
2409: from pa_proj_period_profiles pppp,
2410: pa_proj_periods_denorm pppd
2411: where pppp.period_profile_id = p_period_profile_id and
2412: pppp.period_profile_id=pppd.period_profile_id and
2413: pppd.amount_type_id = p_amount_type_id and
2414: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2630: pa_proj_periods_denorm pppd

2626: 120, -pppd.period_amount52,
2627: pppd.period_amount52),0))
2628: into l_return_value
2629: from pa_proj_period_profiles pppp,
2630: pa_proj_periods_denorm pppd
2631: where pppp.period_profile_id = p_period_profile_id and
2632: pppp.period_profile_id=pppd.period_profile_id and
2633: pppd.amount_type_id = p_amount_type_id and
2634: pppd.resource_assignment_id = p_resource_assignment_id and

Line 2850: pa_proj_periods_denorm pppd

2846: 120, -pppd.period_amount52,
2847: pppd.period_amount52),0))
2848: into l_return_value
2849: from pa_proj_period_profiles pppp,
2850: pa_proj_periods_denorm pppd
2851: where pppp.period_profile_id = p_period_profile_id and
2852: pppp.period_profile_id=pppd.period_profile_id and
2853: pppd.amount_type_id = p_amount_type_id and
2854: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3070: pa_proj_periods_denorm pppd

3066: 120, -pppd.period_amount52,
3067: pppd.period_amount52),0))
3068: into l_return_value
3069: from pa_proj_period_profiles pppp,
3070: pa_proj_periods_denorm pppd
3071: where pppp.period_profile_id = p_period_profile_id and
3072: pppp.period_profile_id=pppd.period_profile_id and
3073: pppd.amount_type_id = p_amount_type_id and
3074: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3290: pa_proj_periods_denorm pppd

3286: 120, -pppd.period_amount52,
3287: pppd.period_amount52),0))
3288: into l_return_value
3289: from pa_proj_period_profiles pppp,
3290: pa_proj_periods_denorm pppd
3291: where pppp.period_profile_id = p_period_profile_id and
3292: pppp.period_profile_id=pppd.period_profile_id and
3293: pppd.amount_type_id = p_amount_type_id and
3294: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3510: pa_proj_periods_denorm pppd

3506: 120, -pppd.period_amount52,
3507: pppd.period_amount52),0))
3508: into l_return_value
3509: from pa_proj_period_profiles pppp,
3510: pa_proj_periods_denorm pppd
3511: where pppp.period_profile_id = p_period_profile_id and
3512: pppp.period_profile_id=pppd.period_profile_id and
3513: pppd.amount_type_id = p_amount_type_id and
3514: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3730: pa_proj_periods_denorm pppd

3726: 120, -pppd.period_amount52,
3727: pppd.period_amount52),0))
3728: into l_return_value
3729: from pa_proj_period_profiles pppp,
3730: pa_proj_periods_denorm pppd
3731: where pppp.period_profile_id = p_period_profile_id and
3732: pppp.period_profile_id=pppd.period_profile_id and
3733: pppd.amount_type_id = p_amount_type_id and
3734: pppd.resource_assignment_id = p_resource_assignment_id and

Line 3950: pa_proj_periods_denorm pppd

3946: 120, -pppd.period_amount52,
3947: pppd.period_amount52),0))
3948: into l_return_value
3949: from pa_proj_period_profiles pppp,
3950: pa_proj_periods_denorm pppd
3951: where pppp.period_profile_id = p_period_profile_id and
3952: pppp.period_profile_id=pppd.period_profile_id and
3953: pppd.amount_type_id = p_amount_type_id and
3954: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4170: pa_proj_periods_denorm pppd

4166: 120, -pppd.period_amount52,
4167: pppd.period_amount52),0))
4168: into l_return_value
4169: from pa_proj_period_profiles pppp,
4170: pa_proj_periods_denorm pppd
4171: where pppp.period_profile_id = p_period_profile_id and
4172: pppp.period_profile_id=pppd.period_profile_id and
4173: pppd.amount_type_id = p_amount_type_id and
4174: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4390: pa_proj_periods_denorm pppd

4386: 120, -pppd.period_amount52,
4387: pppd.period_amount52),0))
4388: into l_return_value
4389: from pa_proj_period_profiles pppp,
4390: pa_proj_periods_denorm pppd
4391: where pppp.period_profile_id = p_period_profile_id and
4392: pppp.period_profile_id=pppd.period_profile_id and
4393: pppd.amount_type_id = p_amount_type_id and
4394: pppd.resource_assignment_id = p_resource_assignment_id and

Line 4610: pa_proj_periods_denorm pppd

4606: 120, -pppd.period_amount52,
4607: pppd.period_amount52),0))
4608: into l_return_value
4609: from pa_proj_period_profiles pppp,
4610: pa_proj_periods_denorm pppd
4611: where pppp.period_profile_id = p_period_profile_id and
4612: pppp.period_profile_id=pppd.period_profile_id and
4613: pppd.amount_type_id = p_amount_type_id and
4614: pppd.resource_assignment_id = p_resource_assignment_id and