[Home] [Help]
36: \ | | /
37: The effect on the entity horizon is that \------------/
38: either the legislation code OR the | |
39: business group id may be specified. The ------------ |
40: columns on the table ff_user_entities should | Business | |
41: not BOTH be populated. | group | |
42: ------------ |
43: The allowed combinations for these 2 columns Y |
44: are shown in the table below. This is now the | |
879: hr_utility.raise_error;
880: end;
881: --
882: -- create user entity
883: select ff_user_entities_s.nextval
884: into p_user_entity_id
885: from sys.dual;
886:
887: BEGIN
949: raise;
950: END;
951: ELSE -- g_triggers_altered is FALSE so use existing trigger validation
952: --
953: select ff_user_entities_s.nextval
954: into p_user_entity_id
955: from sys.dual;
956: --
957: insert into ff_user_entities
1929: BEGIN
1930: --
1931: -- get the user entity id to be used:
1932: --
1933: select ff_user_entities_s.currval
1934: into l_user_entity_id
1935: from dual;
1936: --
1937: -- get the relevant information for the user entity we are using
2090: --
2091: if (p_user_entity_id is not NULL) then
2092: l_user_entity_id:=p_user_entity_id;
2093: else
2094: select ff_user_entities_s.currval
2095: into l_user_entity_id
2096: from dual;
2097: end if;
2098:
2533: --
2534: -- get the user entity id from its sequence
2535: --
2536: begin
2537: SELECT ff_user_entities_s.nextval
2538: INTO l_user_entities_seq
2539: FROM dual;
2540: end;
2541: --
3124: IF l_record_inserted THEN
3125: --
3126: -- Fetch the user_entity_id.
3127: --
3128: select ff_user_entities_s.currval
3129: into l_user_entity_id
3130: from dual;
3131: --
3132: -- insert the element type id for the where clause filler
3358: IF l_record_inserted THEN
3359: --
3360: -- Fetch the user_entity_id.
3361: --
3362: select ff_user_entities_s.currval
3363: into l_user_entity_id
3364: from dual;
3365: --
3366: -- insert the element type id for the where clause filler
3567: IF l_record_inserted THEN
3568: --
3569: -- Fetch the user_entity_id.
3570: --
3571: select ff_user_entities_s.currval
3572: into l_user_entity_id
3573: from dual;
3574: --
3575: -- insert the element type id for the where clause filler
4110: IF l_record_inserted THEN
4111: --
4112: -- Fetch the user_entity_id.
4113: --
4114: select ff_user_entities_s.currval
4115: into l_user_entity_id
4116: from dual;
4117: --
4118: -- insert the input value id for the where clause filler
4217: IF l_record_inserted THEN
4218: --
4219: -- Fetch the user_entity_id.
4220: --
4221: select ff_user_entities_s.currval
4222: into l_user_entity_id
4223: from dual;
4224: --
4225: -- insert the input value id for the where clause filler
4345: IF l_record_inserted THEN
4346: --
4347: -- Fetch the user_entity_id.
4348: --
4349: select ff_user_entities_s.currval
4350: into l_user_entity_id
4351: from dual;
4352: --
4353: -- insert the input value id for the where clause filler
4478: IF l_record_inserted THEN
4479: --
4480: -- Fetch the user_entity_id.
4481: --
4482: select ff_user_entities_s.currval
4483: into l_user_entity_id
4484: from dual;
4485: --
4486: -- insert the input value id for the where clause filler
4619: IF l_record_inserted THEN
4620: --
4621: -- Fetch the user_entity_id.
4622: --
4623: select ff_user_entities_s.currval
4624: into l_user_entity_id
4625: from dual;
4626: --
4627: -- insert the input value id for the where clause filler
4683: IF l_record_inserted THEN
4684: --
4685: -- Fetch the user_entity_id.
4686: --
4687: select ff_user_entities_s.currval
4688: into l_user_entity_id
4689: from dual;
4690: --
4691: -- insert the input value id for the where clause filler