1 package FND_PROFILE_HIERARCHY_PKG as
2 /* $Header: AFPOMPHS.pls 120.1 2005/07/02 04:13:13 appldev noship $ */
3
4 /*
5 * X_MODE values for carry_profile_values procedure
6 */
7 SUBTYPE SWITCH_MODE is INTEGER;
8
9 UPDATE_ONLY CONSTANT INTEGER := 1;
10 INSERT_ONLY CONSTANT INTEGER := 2;
11 INSERT_UPDATE CONSTANT INTEGER := 3;
12
13
14 /*
15 ** The procedure carries a profile value and other who attributes when
16 ** its hierarchy type is changed. The source and target hierarchy
17 ** types should be from the set (SECURITY, SERVER, SERVRESP).
18 ** Any other hierarchy switch is ignored. The following hierarchy
19 ** switches are possible:
20 **
21 ** 1. SECURITY TO SERVRESP
22 ** In this switch all the profile values at level 10003 are considered
23 ** for carring forward to level 10007.
24 ** 2. SERVER TO SERVRESP
25 ** In this switch all the profile values at level 10005 are considered
26 ** for carring forward to level 10007.
27 ** 3. SERVRESP TO SECURITY
28 ** In this switch all the profile values at level 10007 are considered
29 ** for carring forward to level 10003.
30 ** 4. SERVRESP TO SERVER
31 ** In this switch all the profile values at level 10007 are considered
32 ** for carring forward to level 10005.
33 **
34 ** what profile values are carried is controlled by the parameter X_MODE.
35 ** profile option value rows can be either updatable rows or insertable rows.
36 **
37 ** when a profile has rows existing at the target hierarchy level, they are called
38 ** updatable rows. For example, when a profile hierarchy switch is from
39 ** SECURITY to SERVRESP, all rows in FND_PROFILE_OPTION_VALUES for this profile
40 ** are considered updatable if there exist a valid LEVEL_VALUE2 value at level 10007.
41 **
42 ** Insertable rows are all rows at source hierarchy level minus rows considered as
43 ** updatable.
44 **
45 ** 1. UPDATE_ONLY
46 ** In this mode profile option value and who columns of updatable rows are updated
47 ** from the similar rows at the source hierarchy level.
48 ** 2. INSERT_ONLY
49 ** In this mode profile option value and who columns of insertable rows are inserted
50 ** at the target hierarchy level. Updatable rows are untouched.
51 ** 3. INSERT_UPDATE
52 ** This mode is combination of both (1) and (2).
53 */
54 procedure carry_profile_values(
55 X_PROFILE_OPTION_NAME in VARCHAR2,
56 X_APPLICATION_ID in NUMBER,
57 X_PROFILE_OPTION_ID in NUMBER,
58 X_TO_HIERARCHY_TYPE in VARCHAR2,
59 X_LAST_UPDATE_DATE in DATE,
60 X_LAST_UPDATED_BY in NUMBER,
61 X_CREATION_DATE in DATE,
62 X_CREATED_BY in NUMBER,
63 X_LAST_UPDATE_LOGIN in NUMBER,
64 X_MODE in NUMBER default INSERT_UPDATE
65 );
66
67 end FND_PROFILE_HIERARCHY_PKG;