5: -- declaration of record type
6: --------------------------------------
7:
8: TYPE dss_entity_profile_type IS RECORD (
9: entity_id hz_dss_entities.entity_id%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
6: --------------------------------------
7:
8: TYPE dss_entity_profile_type IS RECORD (
9: entity_id hz_dss_entities.entity_id%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
7:
8: TYPE dss_entity_profile_type IS RECORD (
9: entity_id hz_dss_entities.entity_id%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
8: TYPE dss_entity_profile_type IS RECORD (
9: entity_id hz_dss_entities.entity_id%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
9: entity_id hz_dss_entities.entity_id%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
10: object_id hz_dss_entities.object_id%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
11: instance_set_id hz_dss_entities.instance_set_id%TYPE,
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
19: group_assignment_level hz_dss_entities.group_assignment_level%TYPE
12: parent_entity_id hz_dss_entities.parent_entity_id%TYPE,
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
19: group_assignment_level hz_dss_entities.group_assignment_level%TYPE
20:
13: status hz_dss_entities.status%TYPE DEFAULT 'A',
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
19: group_assignment_level hz_dss_entities.group_assignment_level%TYPE
20:
21: );
14: parent_fk_column1 hz_dss_entities.parent_fk_column1%TYPE,
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
19: group_assignment_level hz_dss_entities.group_assignment_level%TYPE
20:
21: );
22:
15: parent_fk_column2 hz_dss_entities.parent_fk_column2%TYPE,
16: parent_fk_column3 hz_dss_entities.parent_fk_column3%TYPE,
17: parent_fk_column4 hz_dss_entities.parent_fk_column4%TYPE,
18: parent_fk_column5 hz_dss_entities.parent_fk_column5%TYPE,
19: group_assignment_level hz_dss_entities.group_assignment_level%TYPE
20:
21: );
22:
23: TYPE dss_scheme_function_type IS RECORD (