APPS.FND_PROFILE_HIERARCHY_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 27: TYPE profile_value is TABLE OF FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE

23: /*
24: * Global types to hold the fetched values.
25: */
26:
27: TYPE profile_value is TABLE OF FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE profile_level is TABLE OF NUMBER
30: INDEX BY BINARY_INTEGER;
31:

Line 39: FROM fnd_profile_option_values

35: ** Using the same cursor raises in a nested for loop, cursor_already_open.
36: */
37: CURSOR pov(appl_id number, prof_id number, lev_id number) IS
38: SELECT profile_option_value, level_value, level_value_application_id, level_value2
39: FROM fnd_profile_option_values
40: WHERE application_id = appl_id
41: AND profile_option_id = prof_id
42: AND level_id = lev_id;
43:

Line 371: from fnd_profile_option_values

367: )
368: is
369: cursor pov_to(appl_id number, prof_id number, lev_id number) is
370: select profile_option_value, level_value, level_value_application_id, level_value2
371: from fnd_profile_option_values
372: where application_id = appl_id
373: and profile_option_id = prof_id
374: and level_id = lev_id;
375:

Line 432: from fnd_profile_option_values

428: )
429: is
430: cursor pov_4_update(appl_id number, prof_id number, lev_id number) is
431: select profile_option_value, level_value, level_value_application_id, level_value2
432: from fnd_profile_option_values
433: where application_id = appl_id
434: and profile_option_id = prof_id
435: and level_id = lev_id
436: for update;

Line 529: ** SECURITY to SERVRESP, all rows in FND_PROFILE_OPTION_VALUES for this profile

525: ** profile option value rows can be either updatable rows or insertable rows.
526: **
527: ** when a profile has rows existing at the target hierarchy level, they are called
528: ** updatable rows. For example, when a profile hierarchy switch is from
529: ** SECURITY to SERVRESP, all rows in FND_PROFILE_OPTION_VALUES for this profile
530: ** are considered updatable if there exist a valid LEVEL_VALUE2 value at level 10007.
531: **
532: ** Insertable rows are all rows at source hierarchy level minus rows considered as
533: ** updatable.

Line 580: update fnd_profile_option_values

576: (g_prof_val_4_update.first is not null)
577: ) then
578:
579: FORALL rec in g_prof_val_4_update.first .. g_prof_val_4_update.last
580: update fnd_profile_option_values
581: set profile_option_value = g_prof_val_4_update(rec),
582: last_update_date = x_last_update_date,
583: last_update_login = x_last_update_login,
584: last_updated_by = x_last_updated_by

Line 612: insert into fnd_profile_option_values (

608: (g_prof_val_4_insert.first is not null)
609: )
610: then
611: FORALL rec in g_prof_val_4_insert.first .. g_prof_val_4_insert.last
612: insert into fnd_profile_option_values (
613: APPLICATION_ID,
614: PROFILE_OPTION_ID,
615: LEVEL_ID,
616: LEVEL_VALUE,