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 521: ** SECURITY to SERVRESP, all rows in FND_PROFILE_OPTION_VALUES for this profile

517: ** profile option value rows can be either updatable rows or insertable rows.
518: **
519: ** when a profile has rows existing at the target hierarchy level, they are called
520: ** updatable rows. For example, when a profile hierarchy switch is from
521: ** SECURITY to SERVRESP, all rows in FND_PROFILE_OPTION_VALUES for this profile
522: ** are considered updatable if there exist a valid LEVEL_VALUE2 value at level 10007.
523: **
524: ** Insertable rows are all rows at source hierarchy level minus rows considered as
525: ** updatable.

Line 572: update fnd_profile_option_values

568: (g_prof_val_4_update.first is not null)
569: ) then
570:
571: FORALL rec in g_prof_val_4_update.first .. g_prof_val_4_update.last
572: update fnd_profile_option_values
573: set profile_option_value = g_prof_val_4_update(rec),
574: last_update_date = x_last_update_date,
575: last_update_login = x_last_update_login,
576: last_updated_by = x_last_updated_by

Line 604: insert into fnd_profile_option_values (

600: (g_prof_val_4_insert.first is not null)
601: )
602: then
603: FORALL rec in g_prof_val_4_insert.first .. g_prof_val_4_insert.last
604: insert into fnd_profile_option_values (
605: APPLICATION_ID,
606: PROFILE_OPTION_ID,
607: LEVEL_ID,
608: LEVEL_VALUE,