[Home] [Help]
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
891: insert into ff_user_entities
892: (user_entity_id,
907: p_db_item_name,
908: p_defined_balance_id,
909: p_creator_type,
910: p_description
911: from dual
912: where not exists (
913: select null
914: from ff_user_entities a
915: where a.user_entity_name = p_db_item_name
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
961: (user_entity_id,
962: business_group_id,
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
1941: --
1942: BEGIN
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:
2102: --
2103: -- get the relevant information for the user entity we are using
2538: --
2539: begin
2540: SELECT ff_user_entities_s.nextval
2541: INTO l_user_entities_seq
2542: FROM dual;
2543: end;
2544: --
2545: l_user_entity_name := p_user_entity_name;
2546: --
2653: p_created_by,
2654: p_last_login,
2655: p_created_by,
2656: sysdate
2657: from dual
2658: where not exists (
2659: select null
2660: from ff_user_entities a
2661: where a.user_entity_name = l_user_entity_name
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
3136: --
3137: insert_parameter_value (p_element_type_id, 1);
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
3370: --
3371: insert_parameter_value (p_element_type_id, 1);
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
3579: --
3580: insert_parameter_value (p_element_type_id, 1);
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
4122: --
4123: insert_parameter_value (p_input_value_id, 1);
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
4229: --
4230: insert_parameter_value (p_input_value_id, 1);
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
4357: --
4358: insert_parameter_value (p_input_value_id, 1);
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
4490: --
4491: insert_parameter_value (p_input_value_id, 1);
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
4631: --
4632: insert_parameter_value (p_input_value_id, 1);
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
4695: --
4696: insert_parameter_value (p_input_value_id, 1);
6125: DESCRIPTION
6126: This procedure is the main entry point for deleting descriptive
6127: flexfield database items. To delete all the descriptive flexfield
6128: database items for a given legislation code, pass the title parameter
6129: as '%'. To delete an individual descriptive flexfield pass the title
6130: of the flexfield.
6131: NOTES
6132: Since the legislation code for a descriptive flexfield could be null
6133: a nvl function is required as part of the SQL statement.
6561: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
6562: could be several database items.
6563: --
6564: NOTES
6565: Since there is no desciptive flex id to identify an individual row in
6566: the ff_user_entities table, the title of the descriptive flex is used
6567: instead, holding it in the user_entity_name column.
6568: --
6569: It is intended that this flexfield creation procedure be run from the
6683: Extra Position Info DDF and Extra Person Info DDF. The
6684: context passed for these 3 flexfields is the appropriate
6685: information type.
6686: NOTES
6687: Since there is no desciptive flex id to identify an individual row in
6688: the ff_user_entities table, the title of the descriptive flex is used
6689: instead, holding it in the user_entity_name column.
6690: --
6691: It is intended that this flexfield creation procedure be run from the
7025: 'end_user_column_name' from the foundation table
7026: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
7027: could be several database items.
7028: NOTES
7029: Since there is no desciptive flex id to identify an individual row in
7030: the ff_user_entities table, the title of the descriptive flex is used
7031: instead, holding it in the user_entity_name column.
7032:
7033: Added rtrim to title select below, due to Reserved word problem, ie
7093: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
7094: could be several database items.
7095: DB Item Format :
7096: NOTES
7097: Since there is no desciptive flex id to identify an individual row in
7098: the ff_user_entities table, the title of the descriptive flex is used
7099: instead, holding it in the user_entity_name column.
7100:
7101: Added rtrim to title select below, due to Reserved word problem, ie
7437: routes in this table by using the route name, which is hard coded below.
7438: The parameters passed in are the business group id and the name of the
7439: key flexfield. To create all the key flexfield database items for a
7440: particular business group pass the name parameter as '%'. To create an
7441: individual key flexfield the following key flexfields are supported:
7442: --
7443: JOB for 'p_keyflex_name' pass in : 'JOB'
7444: POSITION for 'p_keyflex_name' pass in : 'POS'
7445: GRADE for 'p_keyflex_name' pass in : 'GRD'
8082: end if;
8083:
8084: select null
8085: into l_exists
8086: from dual
8087: where exists
8088: (
8089: select /*+ INDEX(a FF_DATABASE_ITEMS_PK)
8090: INDEX(b FF_USER_ENTITIES_PK) */ null
8788: end if;
8789:
8790: select null
8791: into l_exists
8792: from dual
8793: where exists
8794: (
8795: select /*+ INDEX(a FF_DATABASE_ITEMS_PK)
8796: INDEX(b FF_USER_ENTITIES_PK) */ null