1 package AK_AMPARAM_REGISTRY_GRP as
2 /* $Header: akdgaprs.pls 120.2 2005/09/15 22:26:30 tshort noship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_AMPARAM_REGISTRY_GRP';
8 --
9 -- Procedure specs
10 --
11 --=======================================================
12 -- Procedure CREATE_AMPARAM_REGISTRY
13 --
14 -- Usage Group API for creating a amparam_registry object
15 --
16 -- Desc Calls the private API to creates a amparam_registry object
17 -- using the given info
18 --
19 -- Results The API returns the standard p_return_status parameter
20 -- indicating one of the standard return statuses :
21 -- * Unexpected error
22 -- * Error
23 -- * Success
24 -- Parameters amparam_registry object columns
25 --
26 -- Version Initial version number = 1.0
27 -- History Current version number = 1.0
28 --=======================================================
29 procedure CREATE_AMPARAM_REGISTRY (
30 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_api_version_number IN NUMBER,
32 p_init_msg_tbl IN BOOLEAN := FALSE,
33 p_msg_count OUT NOCOPY NUMBER,
34 p_msg_data OUT NOCOPY VARCHAR2,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_applicationmodule_defn_name IN VARCHAR2,
37 p_param_name IN VARCHAR2,
38 p_param_value IN VARCHAR2,
39 p_application_id IN NUMBER
40 );
41
42
43 --========================================================
44 -- Procedure DOWNLOAD_AMPARAM_REGISTRY
45 --
46 -- Usage Group API for downloading amparam_registry objects
47 --
48 -- Desc This API first write out standard loader
49 -- file header for attributes to a flat file.
50 -- Then it calls the private API to extract the
51 -- amparam_registry records selected by application ID or by
52 -- key values from the database to the output file.
53 --
54 -- Results The API returns the standard p_return_status parameter
55 -- indicating one of the standard return statuses :
56 -- * Unexpected error
57 -- * Error
58 -- * Success
59 -- Parameters
60 -- p_nls_language : IN optional
61 -- NLS language for database. If none if given,
62 -- the current NLS language will be used.
63 --
64 -- One of the following three parameters must be given:
65 --
66 -- p_application_id : IN optional
67 -- If given, all query objects for this application ID
68 -- will be written to the output file.
69 -- p_application_short_name : IN optional
70 -- If given, all query objects for this application short
71 -- name will be written to the output file.
72 -- Application short name will be ignored if an
73 -- application ID is given.
74 -- p_amparamreg_pk_tbl : IN optional
75 -- If given, only amparam_registry objects whose key values are
76 -- included in this table will be written to the
77 -- output file.
78 --
79 --
80 -- Version Initial version number = 1.0
81 -- History Current version number = 1.0
82 --=======================================================
83 procedure DOWNLOAD_AMPARAM_REGISTRY (
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_api_version_number IN NUMBER,
86 p_init_msg_tbl IN BOOLEAN := FALSE,
87 p_msg_count OUT NOCOPY NUMBER,
88 p_msg_data OUT NOCOPY VARCHAR2,
89 p_return_status OUT NOCOPY VARCHAR2,
90 p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
92 p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_amparamreg_pk_tbl IN AK_AMPARAM_REGISTRY_PUB.AmParamReg_Pk_Tbl_Type :=
94 AK_AMPARAM_REGISTRY_PUB.G_MISS_AMPARAMREG_PK_TBL
95 );
96
97 end AK_AMPARAM_REGISTRY_GRP;