DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on EAM_FORECAST_CEBBA

Line 6: TYPE cebba_table_type IS table of EAM_FORECAST_CEBBA%ROWTYPE;

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: (

Line 11: FORECAST_ID eam_forecast_cebba.FORECAST_ID%type,

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,

Line 12: PERIOD_SET_NAME eam_forecast_cebba.period_set_name%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,

Line 13: PERIOD_NAME eam_forecast_cebba.period_name%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,

Line 14: ACCT_PERIOD_ID eam_forecast_cebba.acct_period_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,

Line 15: WIP_ENTITY_ID eam_forecast_cebba.wip_entity_id%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,

Line 16: ORGANIZATION_ID eam_forecast_cebba.organization_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,
20: txn_type eam_forecast_cebba.txn_type%type,

Line 17: OPERATIONS_DEPT_ID eam_forecast_cebba.operations_dept_id%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,

Line 18: OPERATION_SEQ_NUM eam_forecast_cebba.operation_seq_num%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,

Line 19: MAINT_COST_CATEGORY eam_forecast_cebba.maint_cost_category%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,

Line 20: txn_type eam_forecast_cebba.txn_type%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,

Line 21: OWNING_DEPT_ID eam_forecast_cebba.owning_dept_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,
25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%type,

Line 22: acct_VALUE eam_forecast_cebba.acct_value%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,

Line 23: PERIOD_START_DATE eam_forecast_cebba.period_start_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,

Line 24: LAST_UPDATE_DATE eam_forecast_cebba.last_update_date%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,

Line 25: LAST_UPDATED_BY eam_forecast_cebba.last_updated_by%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,

Line 26: CREATION_DATE eam_forecast_cebba.creation_date%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,

Line 27: CREATED_BY eam_forecast_cebba.created_by%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,

Line 28: LAST_UPDATE_LOGIN eam_forecast_cebba.last_update_login%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,

Line 29: REQUEST_ID eam_forecast_cebba.request_id%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,

Line 30: PROGRAM_APPLICATION_ID eam_forecast_cebba.program_application_id%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,

Line 31: PROGRAM_ID eam_forecast_cebba.program_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,

Line 32: PROGRAM_UPDATE_DATE eam_forecast_cebba.program_update_date%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

Line 33: CCID eam_forecast_cebba.ccid%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: );

Line 34: MFG_COST_ELEMENT_ID eam_forecast_cebba.mfg_cost_element_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: );
38:

Line 35: PERIOD_YEAR eam_forecast_cebba.period_year%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:
39:

Line 36: PERIOD_NUM eam_forecast_cebba.period_num%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:
40: Type eam_wo_relations_tbl_type is table of eam_forecast_rec_type