[Home] [Help]
PACKAGE: APPS.AMS_IBA_PL_SITES_B_PKG
Source
1 PACKAGE AMS_IBA_PL_SITES_B_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstsits.pls 115.12 2003/03/12 00:28:52 ryedator ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_IBA_PL_SITES_B_PKG
7 -- Purpose
8 -- Table api to insert/update/delete iMarketing sites.
9 -- History
10 -- 17-APR-2001 sodixit Created.
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 -- ===============================================================
18 -- Start of Comments
19 -- Procedure name
20 -- Insert_Row
21 -- Purpose
22 -- Table api to insert iMarketing Sites.
23 -- History
24 -- 17-APR-2001 sodixit Created.
25 -- NOTE
26 --
27 -- End of Comments
28 -- ===============================================================
29
30 PROCEDURE Insert_Row(
31 px_site_id IN OUT NOCOPY NUMBER,
32 p_site_ref_code VARCHAR2,
33 p_site_category_type VARCHAR2,
34 p_site_category_object_id NUMBER,
35 p_status_code VARCHAR2,
36 p_created_by NUMBER,
37 p_creation_date DATE,
38 p_last_updated_by NUMBER,
39 p_last_update_date DATE,
40 p_last_update_login NUMBER,
41 px_object_version_number IN OUT NOCOPY NUMBER,
42 p_name in VARCHAR2,
43 p_description in VARCHAR2);
44
45 -- ===============================================================
46 -- Start of Comments
47 -- Procedure name
48 -- Update_Row
49 -- Purpose
50 -- Table api to update iMarketing Sites.
51 -- History
52 -- 17-APR-2001 sodixit Created.
53 -- NOTE
54 --
55 -- End of Comments
56 -- ===============================================================
57
58 PROCEDURE Update_Row(
59 p_site_id NUMBER,
60 p_site_ref_code VARCHAR2,
61 p_site_category_type VARCHAR2,
62 p_site_category_object_id NUMBER,
63 p_status_code VARCHAR2,
64 p_created_by NUMBER,
65 p_creation_date DATE,
66 p_last_updated_by NUMBER,
67 p_last_update_date DATE,
68 p_last_update_login NUMBER,
69 p_object_version_number NUMBER,
70 p_name in VARCHAR2,
71 p_description in VARCHAR2);
72
73 -- ===============================================================
74 -- Start of Comments
75 -- Procedure name
76 -- Delete_Row
77 -- Purpose
78 -- Table api to delete iMarketing Sites.
79 -- History
80 -- 17-APR-2001 sodixit Created.
81 -- NOTE
82 --
83 -- End of Comments
84 -- ===============================================================
85
86 PROCEDURE Delete_Row(
87 p_site_id NUMBER,
88 p_object_version_number NUMBER);
89
90 procedure ADD_LANGUAGE;
91
92 -- ===============================================================
93 -- Start of Comments
94 -- Procedure name
95 -- Lock_Row
96 -- Purpose
97 -- Table api to lock iMarketing Sites.
98 -- History
99 -- 17-APR-2001 sodixit Created.
100 -- NOTE
101 --
102 -- End of Comments
103 -- ===============================================================
104
105 PROCEDURE Lock_Row(
106 p_site_id NUMBER,
107 p_site_ref_code VARCHAR2,
108 p_site_category_type VARCHAR2,
109 p_site_category_object_id NUMBER,
110 p_status_code VARCHAR2,
111 p_created_by NUMBER,
112 p_creation_date DATE,
113 p_last_updated_by NUMBER,
114 p_last_update_date DATE,
115 p_last_update_login NUMBER,
116 p_object_version_number NUMBER,
117 p_name in VARCHAR2,
118 p_description in VARCHAR2);
119
120 PROCEDURE translate_row (
121 x_site_id IN NUMBER,
122 x_name IN VARCHAR2,
123 x_description IN VARCHAR2,
124 x_owner IN VARCHAR2,
125 x_custom_mode IN VARCHAR2
126 );
127
128 PROCEDURE load_row (
129 x_site_id IN NUMBER,
130 x_site_ref_code IN VARCHAR2,
131 x_site_ctgy_type IN VARCHAR2,
132 x_site_ctgy_obj_id IN NUMBER,
133 x_status_code IN VARCHAR2,
134 x_name IN VARCHAR2,
135 x_description IN VARCHAR2,
136 x_owner IN VARCHAR2,
137 x_custom_mode IN VARCHAR2
138 );
139
140 END AMS_IBA_PL_SITES_B_PKG;