PACKAGE: APPS.AMS_IBA_PL_PLACEMENTS_B_PKG

Source

1 PACKAGE AMS_IBA_PL_PLACEMENTS_B_PKG AS
2 /* $Header: amstplcs.pls 120.0 2005/06/01 02:56:49 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PL_PLACEMENTS_B_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_placement_id   IN OUT NOCOPY NUMBER,
18           p_site_id    NUMBER,
19           p_site_ref_code    VARCHAR2,
20           p_page_id    NUMBER,
21           p_page_ref_code    VARCHAR2,
22           p_location_code    VARCHAR2,
23           p_param1    VARCHAR2,
24           p_param2    VARCHAR2,
25           p_param3    VARCHAR2,
26           p_param4    VARCHAR2,
27           p_param5    VARCHAR2,
28           p_stylesheet_id    NUMBER,
29           p_posting_id    NUMBER,
30           p_status_code    VARCHAR2,
31           p_track_events_flag    VARCHAR2,
32           p_created_by    NUMBER,
33           p_creation_date    DATE,
34           p_last_updated_by    NUMBER,
35           p_last_update_date    DATE,
36           p_last_update_login    NUMBER,
37           px_object_version_number   IN OUT NOCOPY NUMBER,
38           p_name in VARCHAR2,
39           p_description in VARCHAR2);
40 
41 PROCEDURE Update_Row(
42           p_placement_id    NUMBER,
43           p_site_id    NUMBER,
44           p_site_ref_code    VARCHAR2,
45           p_page_id    NUMBER,
46           p_page_ref_code    VARCHAR2,
47           p_location_code    VARCHAR2,
48           p_param1    VARCHAR2,
49           p_param2    VARCHAR2,
50           p_param3    VARCHAR2,
51           p_param4    VARCHAR2,
52           p_param5    VARCHAR2,
53           p_stylesheet_id    NUMBER,
54           p_posting_id    NUMBER,
55           p_status_code    VARCHAR2,
56           p_track_events_flag    VARCHAR2,
57           p_created_by    NUMBER,
58           p_creation_date    DATE,
59           p_last_updated_by    NUMBER,
60           p_last_update_date    DATE,
61           p_last_update_login    NUMBER,
62           p_object_version_number    NUMBER,
63           p_name in VARCHAR2,
64           p_description in VARCHAR2);
65 
66 PROCEDURE Delete_Row(
67     p_PLACEMENT_ID  NUMBER);
68 
69 procedure ADD_LANGUAGE;
70 
71 PROCEDURE Lock_Row(
72           p_placement_id    NUMBER,
73           p_site_id    NUMBER,
74           p_site_ref_code    VARCHAR2,
75           p_page_id    NUMBER,
76           p_page_ref_code    VARCHAR2,
77           p_location_code    VARCHAR2,
78           p_param1    VARCHAR2,
79           p_param2    VARCHAR2,
80           p_param3    VARCHAR2,
81           p_param4    VARCHAR2,
82           p_param5    VARCHAR2,
83           p_stylesheet_id    NUMBER,
84           p_posting_id    NUMBER,
85           p_status_code    VARCHAR2,
86           p_track_events_flag    VARCHAR2,
87           p_created_by    NUMBER,
88           p_creation_date    DATE,
89           p_last_updated_by    NUMBER,
90           p_last_update_date    DATE,
91           p_last_update_login    NUMBER,
92           p_object_version_number    NUMBER);
93 
94 END AMS_IBA_PL_PLACEMENTS_B_PKG;