[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 | |
882: hr_utility.raise_error;
883: end;
884: --
885: -- create user entity
886: select ff_user_entities_s.nextval
887: into p_user_entity_id
888: from sys.dual;
889:
890: BEGIN
952: raise;
953: END;
954: ELSE -- g_triggers_altered is FALSE so use existing trigger validation
955: --
956: select ff_user_entities_s.nextval
957: into p_user_entity_id
958: from sys.dual;
959: --
960: insert into ff_user_entities
1932: BEGIN
1933: --
1934: -- get the user entity id to be used:
1935: --
1936: select ff_user_entities_s.currval
1937: into l_user_entity_id
1938: from dual;
1939: --
1940: -- get the relevant information for the user entity we are using
2093: --
2094: if (p_user_entity_id is not NULL) then
2095: l_user_entity_id:=p_user_entity_id;
2096: else
2097: select ff_user_entities_s.currval
2098: into l_user_entity_id
2099: from dual;
2100: end if;
2101:
2536: --
2537: -- get the user entity id from its sequence
2538: --
2539: begin
2540: SELECT ff_user_entities_s.nextval
2541: INTO l_user_entities_seq
2542: FROM dual;
2543: end;
2544: --
3127: IF l_record_inserted THEN
3128: --
3129: -- Fetch the user_entity_id.
3130: --
3131: select ff_user_entities_s.currval
3132: into l_user_entity_id
3133: from dual;
3134: --
3135: -- insert the element type id for the where clause filler
3361: IF l_record_inserted THEN
3362: --
3363: -- Fetch the user_entity_id.
3364: --
3365: select ff_user_entities_s.currval
3366: into l_user_entity_id
3367: from dual;
3368: --
3369: -- insert the element type id for the where clause filler
3570: IF l_record_inserted THEN
3571: --
3572: -- Fetch the user_entity_id.
3573: --
3574: select ff_user_entities_s.currval
3575: into l_user_entity_id
3576: from dual;
3577: --
3578: -- insert the element type id for the where clause filler
4113: IF l_record_inserted THEN
4114: --
4115: -- Fetch the user_entity_id.
4116: --
4117: select ff_user_entities_s.currval
4118: into l_user_entity_id
4119: from dual;
4120: --
4121: -- insert the input value id for the where clause filler
4220: IF l_record_inserted THEN
4221: --
4222: -- Fetch the user_entity_id.
4223: --
4224: select ff_user_entities_s.currval
4225: into l_user_entity_id
4226: from dual;
4227: --
4228: -- insert the input value id for the where clause filler
4348: IF l_record_inserted THEN
4349: --
4350: -- Fetch the user_entity_id.
4351: --
4352: select ff_user_entities_s.currval
4353: into l_user_entity_id
4354: from dual;
4355: --
4356: -- insert the input value id for the where clause filler
4481: IF l_record_inserted THEN
4482: --
4483: -- Fetch the user_entity_id.
4484: --
4485: select ff_user_entities_s.currval
4486: into l_user_entity_id
4487: from dual;
4488: --
4489: -- insert the input value id for the where clause filler
4622: IF l_record_inserted THEN
4623: --
4624: -- Fetch the user_entity_id.
4625: --
4626: select ff_user_entities_s.currval
4627: into l_user_entity_id
4628: from dual;
4629: --
4630: -- insert the input value id for the where clause filler
4686: IF l_record_inserted THEN
4687: --
4688: -- Fetch the user_entity_id.
4689: --
4690: select ff_user_entities_s.currval
4691: into l_user_entity_id
4692: from dual;
4693: --
4694: -- insert the input value id for the where clause filler