PACKAGE: APPS.AMS_IBA_PL_PG_PARAMS_PKG

Source

1 PACKAGE AMS_IBA_PL_PG_PARAMS_PKG AS
2 /* $Header: amstpgps.pls 120.0 2005/05/31 16:27:40 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PL_PG_PARAMS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_page_parameter_id   IN OUT NOCOPY NUMBER,
18           p_page_id    NUMBER,
19           p_site_ref_code    VARCHAR2,
20           p_page_ref_code    VARCHAR2,
21           p_parameter_id    NUMBER,
22           p_parameter_ref_code    VARCHAR2,
23           p_execution_order    NUMBER,
24           p_created_by    NUMBER,
25           p_creation_date    DATE,
26           p_last_updated_by    NUMBER,
27           p_last_update_date    DATE,
28           p_last_update_login    NUMBER,
29           px_object_version_number   IN OUT NOCOPY NUMBER);
30 
31 PROCEDURE Update_Row(
32           p_page_parameter_id    NUMBER,
33           p_page_id    NUMBER,
34           p_site_ref_code    VARCHAR2,
35           p_page_ref_code    VARCHAR2,
36           p_parameter_id    NUMBER,
37           p_parameter_ref_code    VARCHAR2,
38           p_execution_order    NUMBER,
39           p_created_by    NUMBER,
40           p_creation_date    DATE,
41           p_last_updated_by    NUMBER,
42           p_last_update_date    DATE,
43           p_last_update_login    NUMBER,
44           p_object_version_number    NUMBER);
45 
46 PROCEDURE Delete_Row(
47     p_PAGE_PARAMETER_ID  NUMBER);
48 PROCEDURE Lock_Row(
49           p_page_parameter_id    NUMBER,
50           p_page_id    NUMBER,
51           p_site_ref_code    VARCHAR2,
52           p_page_ref_code    VARCHAR2,
53           p_parameter_id    NUMBER,
54           p_parameter_ref_code    VARCHAR2,
55           p_execution_order    NUMBER,
56           p_created_by    NUMBER,
57           p_creation_date    DATE,
58           p_last_updated_by    NUMBER,
59           p_last_update_date    DATE,
60           p_last_update_login    NUMBER,
61           p_object_version_number    NUMBER);
62 
63 
64 PROCEDURE load_row (
65    x_page_parameter_id  IN NUMBER,
66    x_page_id            IN NUMBER,
67    x_site_ref_code      IN VARCHAR2,
68    x_page_ref_code      IN VARCHAR2,
69    x_parameter_id       IN NUMBER,
70    x_parameter_ref_code IN VARCHAR2,
71    x_execution_order    IN NUMBER,
72    x_owner              IN VARCHAR2,
73    X_CUSTOM_MODE		IN VARCHAR2
74   );
75 
76 END AMS_IBA_PL_PG_PARAMS_PKG;