PACKAGE: APPS.AMS_IBA_PL_PARAMETERS_B_PKG

Source

1 PACKAGE AMS_IBA_PL_PARAMETERS_B_PKG AS
2 /* $Header: amstpars.pls 120.0 2005/05/31 14:52:36 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PL_PARAMETERS_B_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_parameter_id   IN OUT NOCOPY NUMBER,
18           p_site_id    NUMBER,
19           p_site_ref_code    VARCHAR2,
20           p_parameter_ref_code    VARCHAR2,
21           p_execution_order    NUMBER,
22           p_created_by    NUMBER,
23           p_creation_date    DATE,
24           p_last_updated_by    NUMBER,
25           p_last_update_date    DATE,
26           p_last_update_login    NUMBER,
27           px_object_version_number   IN OUT NOCOPY NUMBER,
28 	  p_name in VARCHAR2,
29 	  p_description in VARCHAR2);
30 
31 
32 PROCEDURE Update_Row(
33           p_parameter_id    NUMBER,
34           p_site_id    NUMBER,
35           p_site_ref_code    VARCHAR2,
36           p_parameter_ref_code    VARCHAR2,
37           p_execution_order    NUMBER,
38           p_created_by    NUMBER,
39           p_creation_date    DATE,
40           p_last_updated_by    NUMBER,
41           p_last_update_date    DATE,
42           p_last_update_login    NUMBER,
43           p_object_version_number    NUMBER,
44 	  p_name in VARCHAR2,
45 	  p_description in VARCHAR2);
46 
47 
48 PROCEDURE Delete_Row(
49     p_PARAMETER_ID  NUMBER);
50 
51 procedure ADD_LANGUAGE;
52 
53 PROCEDURE Lock_Row(
54           p_parameter_id    NUMBER,
55           p_site_id    NUMBER,
56           p_site_ref_code    VARCHAR2,
57           p_parameter_ref_code    VARCHAR2,
58           p_execution_order    NUMBER,
59           p_created_by    NUMBER,
60           p_creation_date    DATE,
61           p_last_updated_by    NUMBER,
62           p_last_update_date    DATE,
63           p_last_update_login    NUMBER,
64           p_object_version_number    NUMBER,
65 	  p_name in VARCHAR2,
66 	  p_description in VARCHAR2);
67 
68 PROCEDURE translate_row (
69    x_parameter_id 	IN NUMBER,
70    x_name 		IN VARCHAR2,
71    x_description 	IN VARCHAR2,
72    x_owner 		IN VARCHAR2,
73    x_custom_mode IN VARCHAR2
74   );
75 
76 PROCEDURE load_row (
77    x_parameter_id      	IN NUMBER,
78    x_site_id           	IN NUMBER,
79    x_site_ref_code     	IN VARCHAR2,
80    x_parameter_ref_code IN VARCHAR2,
81    x_execution_order   	IN NUMBER,
82    x_name              	IN VARCHAR2,
83    x_description       	IN VARCHAR2,
84    x_owner              IN VARCHAR2,
85    x_custom_mode IN VARCHAR2
86   );
87 
88 
89 END AMS_IBA_PL_PARAMETERS_B_PKG;