6: TYPE wop_table_type IS TABLE OF EAM_FORECAST_WO%ROWTYPE ; --USAF Bug 13693293
7: TYPE wor_table_type IS TABLE OF EAM_FORECAST_WOR%ROWTYPE ; --USAF Bug 13693293
8: TYPE wro_table_type IS TABLE OF EAM_FORECAST_WRO%ROWTYPE ; --USAF Bug 13693293
9: TYPE wedi_table_type IS TABLE OF EAM_FORECAST_WEDI%ROWTYPE ; --USAF Bug 13693293
10: TYPE cebba_table_type IS table of EAM_FORECAST_CEBBA%ROWTYPE;
11: TYPE wo_table_type IS table of NUMBER INDEX BY BINARY_INTEGER;
12:
13: type eam_forecast_rec_type is record
14: (
11: TYPE wo_table_type IS table of NUMBER INDEX BY BINARY_INTEGER;
12:
13: type eam_forecast_rec_type is record
14: (
15: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
12:
13: type eam_forecast_rec_type is record
14: (
15: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
13: type eam_forecast_rec_type is record
14: (
15: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
14: (
15: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
15: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
16: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
17: PERIOD_NAME eam_forecast_cebba.period_name%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
18: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_id%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
19: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
20: ORGANIZATION_ID eam_forecast_cebba.organization_id%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
21: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
22: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
23: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
24: txn_type eam_forecast_cebba.txn_type%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
25: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
26: acct_VALUE eam_forecast_cebba.acct_value%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
27: PERIOD_START_DATE eam_forecast_cebba.period_start_date%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
28: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
29: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
30: CREATION_DATE eam_forecast_cebba.creation_date%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
31: CREATED_BY eam_forecast_cebba.created_by%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
32: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%type,
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
40: PERIOD_NUM eam_forecast_cebba.period_num%type
33: REQUEST_ID eam_forecast_cebba.request_id%type,
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
40: PERIOD_NUM eam_forecast_cebba.period_num%type
41: );
34: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%type,
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
40: PERIOD_NUM eam_forecast_cebba.period_num%type
41: );
42:
35: PROGRAM_ID eam_forecast_cebba.program_id%type,
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
40: PERIOD_NUM eam_forecast_cebba.period_num%type
41: );
42:
43:
36: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%type,
37: CCID eam_forecast_cebba.ccid%type,
38: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_id%type,
39: PERIOD_YEAR eam_forecast_cebba.period_year%type,
40: PERIOD_NUM eam_forecast_cebba.period_num%type
41: );
42:
43:
44: Type eam_wo_relations_tbl_type is table of eam_forecast_rec_type