[Home] [Help]
2: /* $Header: EAMVFORS.pls 120.7 2006/09/20 10:48:15 csprague noship $ */
3: TYPE forecast_asset_cursor_type IS REF CURSOR;
4: TYPE forecast_wo_cursor_type IS REF CURSOR;
5: TYPE wdj_table_type IS table of EAM_FORECAST_WDJ%ROWTYPE;
6: TYPE cebba_table_type IS table of EAM_FORECAST_CEBBA%ROWTYPE;
7: TYPE wo_table_type IS table of NUMBER INDEX BY BINARY_INTEGER;
8:
9: type eam_forecast_rec_type is record
10: (
7: TYPE wo_table_type IS table of NUMBER INDEX BY BINARY_INTEGER;
8:
9: type eam_forecast_rec_type is record
10: (
11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
8:
9: type eam_forecast_rec_type is record
10: (
11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
9: type eam_forecast_rec_type is record
10: (
11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
10: (
11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
13: PERIOD_NAME eam_forecast_cebba.period_name%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
16: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
20: txn_type eam_forecast_cebba.txn_type%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
22: acct_VALUE eam_forecast_cebba.acct_value%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
23: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
26: CREATION_DATE eam_forecast_cebba.creation_date%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
27: CREATED_BY eam_forecast_cebba.created_by%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
36: PERIOD_NUM eam_forecast_cebba.period_num%type
29: REQUEST_ID eam_forecast_cebba.request_id%type,
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
36: PERIOD_NUM eam_forecast_cebba.period_num%type
37: );
30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
36: PERIOD_NUM eam_forecast_cebba.period_num%type
37: );
38:
31: PROGRAM_ID eam_forecast_cebba.program_id%type,
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
36: PERIOD_NUM eam_forecast_cebba.period_num%type
37: );
38:
39:
32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
33: CCID eam_forecast_cebba.ccid%type,
34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
35: PERIOD_YEAR eam_forecast_cebba.period_year%type,
36: PERIOD_NUM eam_forecast_cebba.period_num%type
37: );
38:
39:
40: Type eam_wo_relations_tbl_type is table of eam_forecast_rec_type