1 PACKAGE FND_OAM_DSCFG_MAPPED_KEYS_PKG AUTHID CURRENT_USER as
2 /* $Header: AFOAMDSCMKEYS.pls 120.0 2005/11/23 10:17 ilawler noship $ */
3
4 ---------------
5 -- Constants --
6 ---------------
7 -- Mapped Key Types are provided by the import procedure
8
9 ---------------------------------
10 -- Public Procedures/Functions --
11 ---------------------------------
12
13 -- This procedure adds a new mapped key for a given configuration instance. The configuration_instance_id is pulled from the
14 -- INSTANCES_PKG to force a call to CREATE/USE_CONFIG_INSTANCE. This is not autonomous so we can package
15 -- the corresponding directive and its properties in the same, atomic commit.
16 -- Invariants:
17 -- Should only be called after a configuration instance has been created or set.
18 -- Parameters:
19 -- p_mapped_key_type [OPTIONAL]Corresponds to API_PKG.G_KEYTYPE_* or a custom value for the import procedure,
20 -- gives meaning to which PK* fields are relevant.
21 -- p_number_pk* [OPTIONAL]NUMBER-type PK fields. 1-3 are NUMBER(15) with 4,5 as just NUMBER.
22 -- p_raw_pk* [OPTIONAL]RAW-type PK fields. Used for GUID-type PKs.
23 -- p_varchar2_pk* [OPTIONAL]VARCHAR2-type PK fields. 1-3 are VARCHAR2(120) with 4,5 as VARCHAR2(4000).
24 --
25 -- x_mapped_key_id_id: The corresponding ID of the newly created mapped key.
26 -- Return Statuses:
27 -- Throws NO_DATA_FOUND if the configuration instance isn't initialized.
28 PROCEDURE ADD_MAPPED_KEY(p_mapped_key_type IN VARCHAR2 DEFAULT NULL,
29 p_number_pk1 IN NUMBER DEFAULT NULL,
30 p_number_pk2 IN NUMBER DEFAULT NULL,
31 p_number_pk3 IN NUMBER DEFAULT NULL,
32 p_number_pk4 IN NUMBER DEFAULT NULL,
33 p_number_pk5 IN NUMBER DEFAULT NULL,
34 p_raw_pk1 IN RAW DEFAULT NULL,
35 p_raw_pk2 IN RAW DEFAULT NULL,
36 p_raw_pk3 IN RAW DEFAULT NULL,
37 p_varchar2_pk1 IN VARCHAR2 DEFAULT NULL,
38 p_varchar2_pk2 IN VARCHAR2 DEFAULT NULL,
39 p_varchar2_pk3 IN VARCHAR2 DEFAULT NULL,
40 p_varchar2_pk4 IN VARCHAR2 DEFAULT NULL,
41 p_varchar2_pk5 IN VARCHAR2 DEFAULT NULL,
42 x_mapped_key_id OUT NOCOPY NUMBER);
43
44 END FND_OAM_DSCFG_MAPPED_KEYS_PKG;