[Home] [Help]
67: ,email_address fnd_user.email_address%type
68: ,fax fnd_user.fax%type
69: ,description fnd_user.description%type
70: ,password_date fnd_user.password_date%type
71: ,language fnd_profile_option_values.profile_option_value%type
72: ,host_port varchar2(2000)
73: ,employee_id fnd_user.employee_id%type
74: ,customer_id fnd_user.customer_id%type
75: ,supplier_id fnd_user.supplier_id%type
457: --
458: -- profile_option_value - mandatory for creating a new profile option value
459: -- at the new responsibility level or at the new user level.
460: -- Length cannot exceed the length of
461: -- fnd_profile_option_values.profile_option_value, which is 240
462: -- characters.
463: -- Use the INTERNAL ID or VALUE for those HR profile options
464: -- which use SQL validations on the option values (ie. an LOV is -- used when entering a value). The following
465: -- profile options have SQL validations and thus supply the
578: -- profile_level_value_app_id = null
579: --
580: --------------------------------------------------------------------------------
581: --
582: -- RECORD STRUCTURE FOR FND_PROFILE_OPTION_VALUES
583: -- ==============================================
584: TYPE fnd_profile_opt_val_rec IS RECORD
585: (profile_option_name fnd_profile_options.profile_option_name%type
586: ,profile_option_value
583: -- ==============================================
584: TYPE fnd_profile_opt_val_rec IS RECORD
585: (profile_option_name fnd_profile_options.profile_option_name%type
586: ,profile_option_value
587: fnd_profile_option_values.profile_option_value%type
588: ,profile_level_name varchar2(2000)
589: ,profile_level_value varchar2(30)
590: ,profile_level_value_app_id
591: fnd_profile_option_values.level_value_application_id%type
587: fnd_profile_option_values.profile_option_value%type
588: ,profile_level_name varchar2(2000)
589: ,profile_level_value varchar2(30)
590: ,profile_level_value_app_id
591: fnd_profile_option_values.level_value_application_id%type
592: );
593:
594: TYPE fnd_profile_opt_val_tbl IS TABLE OF fnd_profile_opt_val_rec
595: INDEX BY BINARY_INTEGER;