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_GEN_AMOUNT_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

1: PACKAGE PA_FP_GEN_AMOUNT_UTILS as
2: /* $Header: PAFPGAUS.pls 120.7 2007/02/06 09:56:53 dthakker ship $ */
3: TYPE FP_COLS IS RECORD (
4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,

Line 6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,

2: /* $Header: PAFPGAUS.pls 120.7 2007/02/06 09:56:53 dthakker ship $ */
3: TYPE FP_COLS IS RECORD (
4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,

Line 7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

3: TYPE FP_COLS IS RECORD (
4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,

Line 8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,

4: X_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,

Line 9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,

5: X_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,

Line 10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,

6: X_PROJ_FP_OPTIONS_ID PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE,
7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */

Line 11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,

7: X_FIN_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,

Line 12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,

8: X_AMOUNT_SET_ID PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE,
9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,

Line 13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,

9: X_FIN_PLAN_LEVEL_CODE PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE,
10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/

Line 14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */

10: X_TIME_PHASED_CODE PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,

Line 15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,

11: X_RESOURCE_LIST_ID PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE,
12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,

Line 16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,

12: X_RES_PLANNING_LEVEL PA_PROJ_FP_OPTIONS.COST_RES_PLANNING_LEVEL%TYPE,
13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/

Line 17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/

13: X_RBS_VERSION_ID PA_PROJ_FP_OPTIONS.RBS_VERSION_ID%TYPE,
14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,

Line 18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,

14: /* X_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE, */
15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,

Line 19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,

15: X_COST_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_EMP_RATE_SCH_ID%TYPE,
16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/

Line 20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/

16: X_REV_EMP_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_EMP_RATE_SCH_ID%TYPE,
17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,

Line 21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,

17: /* X_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,*/
18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,

Line 22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,

18: X_COST_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_JOB_RATE_SCH_ID%TYPE,
19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,

Line 23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/

19: X_REV_JOB_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_JOB_RATE_SCH_ID%TYPE,
20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,

Line 24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,

20: /* X_NON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,*/
21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,

Line 25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,

21: X_CNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_NON_LABOR_RES_RATE_SCH_ID%TYPE,
22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,

22: X_RNON_LABOR_RES_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_NON_LABOR_RES_RATE_SCH_ID%TYPE,
23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,

Line 27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,

23: /* X_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,*/
24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,

Line 28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,

24: X_COST_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_RES_CLASS_RATE_SCH_ID%TYPE,
25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,

Line 29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

25: X_REV_RES_CLASS_RATE_SCH_ID PA_PROJ_FP_OPTIONS.REV_RES_CLASS_RATE_SCH_ID%TYPE,
26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,

Line 30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,

26: X_BURDEN_RATE_SCH_ID PA_PROJ_FP_OPTIONS.COST_BURDEN_RATE_SCH_ID%TYPE,
27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

Line 31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,

27: X_CURRENT_PLANNING_PERIOD PA_PROJ_FP_OPTIONS.COST_CURRENT_PLANNING_PERIOD%TYPE,
28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,

28: X_PERIOD_MASK_ID PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID%TYPE,
29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),

Line 33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,

29: X_GEN_SRC_PLAN_TYPE_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

Line 34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

30: X_GEN_SRC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID%TYPE,
31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,

Line 35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

31: X_GEN_SRC_PLAN_VER_CODE PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE,
32: X_GEN_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE,
33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

Line 37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,

33: X_GEN_ETC_SRC_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE,
34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,

Line 38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,

34: X_GEN_INCL_CHANGE_DOC_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

Line 39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,

35: X_GEN_INCL_OPEN_COMM_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,

Line 40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,

36: X_GEN_INCL_BILL_EVENT_FLAG VARCHAR2(1),
37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,
44: X_SET_OF_BOOKS_ID PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,

Line 58: X_TRACK_WORKPLAN_COSTS_FLAG PA_PROJ_FP_OPTIONS.TRACK_WORKPLAN_COSTS_FLAG%TYPE,

54: X_PROJECT_STRUCTURE_VERSION_ID PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
55: X_PLAN_CLASS_CODE PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
56: X_VERSION_TYPE PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
57: X_PROJECT_VALUE PA_PROJECTS_ALL.PROJECT_VALUE%TYPE,
58: X_TRACK_WORKPLAN_COSTS_FLAG PA_PROJ_FP_OPTIONS.TRACK_WORKPLAN_COSTS_FLAG%TYPE,
59: X_REVENUE_DERIVATION_METHOD VARCHAR2(1), -- bug 5152892
60: X_GEN_SRC_WP_VERSION_ID NUMBER(15),
61: X_GEN_SRC_WP_VER_CODE VARCHAR2(30));
62:

Line 64: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE DEFAULT NULL,

60: X_GEN_SRC_WP_VERSION_ID NUMBER(15),
61: X_GEN_SRC_WP_VER_CODE VARCHAR2(30));
62:
63: PROCEDURE GET_PLAN_VERSION_DTLS
64: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE DEFAULT NULL,
65: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
66: X_FP_COLS_REC OUT NOCOPY FP_COLS,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
68: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,

79: p_project_id IN pa_projects_all.project_id%TYPE,
80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
81: p_version_type IN pa_budget_versions.version_type%TYPE,
82: p_status_code IN VARCHAR2 DEFAULT 'CURRENT_ORIGINAL',
83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,
84: x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2);

Line 84: x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE,

80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
81: p_version_type IN pa_budget_versions.version_type%TYPE,
82: p_status_code IN VARCHAR2 DEFAULT 'CURRENT_ORIGINAL',
83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,
84: x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2);
88:

Line 90: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE VALIDATE_PLAN_VERSION
90: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91: P_SRC_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
92: P_TRGT_BDGT_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,

143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,

Line 148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,

144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,

Line 149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,

145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,

Line 150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,

146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,

Line 151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,

147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,

Line 152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,

148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,
149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,

Line 153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,

149: x_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE,
150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);

Line 154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,

150: x_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE,
151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:

Line 155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,

151: x_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE,
152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE

Line 156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,

152: x_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE,
153: x_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE,
154: x_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE,
155: x_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE,
156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

Line 160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

156: x_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE,
157: x_fp_budget_version_type pa_budget_versions.version_type%TYPE);
158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
162: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
163: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
164: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

Line 196: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

192: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
193: RETURN NUMBER;
194: /* This function returns the RLM ID for the given
195: project id + res list id + resource class level resource combination. */
196: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
197: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
198: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
199: RETURN NUMBER;
200: