PACKAGE: APPS.AMS_IBA_PL_PAGES_B_PKG

Source

1 PACKAGE AMS_IBA_PL_PAGES_B_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstpags.pls 115.10 2003/03/12 00:26:03 ryedator ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PL_PAGES_B_PKG
7 -- Purpose
8 -- 		insert/update/delete placement pages
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_page_id   IN OUT NOCOPY NUMBER,
18           p_site_id    NUMBER,
19           p_site_ref_code    VARCHAR2,
20           p_page_ref_code    VARCHAR2,
21           p_status_code    VARCHAR2,
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 PROCEDURE Update_Row(
32           p_page_id    NUMBER,
33           p_site_id    NUMBER,
34           p_site_ref_code    VARCHAR2,
35           p_page_ref_code    VARCHAR2,
36           p_status_code    VARCHAR2,
37           p_created_by    NUMBER,
38           p_creation_date    DATE,
39           p_last_updated_by    NUMBER,
40           p_last_update_date    DATE,
41           p_last_update_login    NUMBER,
42           p_object_version_number    NUMBER,
43 		p_name in VARCHAR2,
44 		p_description in VARCHAR2);
45 
46 
47 PROCEDURE Delete_Row(
48     p_PAGE_ID  NUMBER);
49 
50 procedure ADD_LANGUAGE;
51 
52 PROCEDURE Lock_Row(
53           p_page_id    NUMBER,
54           p_site_id    NUMBER,
55           p_site_ref_code    VARCHAR2,
56           p_page_ref_code    VARCHAR2,
57           p_status_code    VARCHAR2,
58           p_created_by    NUMBER,
59           p_creation_date    DATE,
60           p_last_updated_by    NUMBER,
61           p_last_update_date    DATE,
62           p_last_update_login    NUMBER,
63           p_object_version_number    NUMBER,
64 		p_name in VARCHAR2,
65 		p_description in VARCHAR2);
66 
67 PROCEDURE translate_row (
68    x_page_id 	IN NUMBER,
69    x_name 	IN VARCHAR2,
70    x_description IN VARCHAR2,
71    x_owner 	IN VARCHAR2,
72    x_custom_mode IN VARCHAR2
73   );
74 
75 PROCEDURE load_row (
76    x_page_id        IN NUMBER,
77    x_site_id        IN NUMBER,
78    x_site_ref_code  IN VARCHAR2,
79    x_page_ref_code  IN VARCHAR2,
80    x_status_code    IN VARCHAR2,
81    x_name           IN VARCHAR2,
82    x_description    IN VARCHAR2,
83    x_owner          IN VARCHAR2,
84    x_custom_mode    IN VARCHAR2
85   );
86 
87 
88 END AMS_IBA_PL_PAGES_B_PKG;