PACKAGE: APPS.AS_LEAD_OBSTACLES_PKG

Source

1 PACKAGE AS_LEAD_OBSTACLES_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtobss.pls 115.5 2002/12/13 12:14:39 nkamble ship $ */
3 -- Start of Comments
4 -- Package name     : AS_LEAD_OBSTACLES_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_LEAD_OBSTACLE_ID   IN OUT NOCOPY NUMBER,
12           p_LAST_UPDATE_DATE    DATE,
13           p_LAST_UPDATED_BY    NUMBER,
14           p_CREATION_DATE    DATE,
15           p_CREATED_BY    NUMBER,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_REQUEST_ID    NUMBER,
18           p_PROGRAM_APPLICATION_ID    NUMBER,
19           p_PROGRAM_ID    NUMBER,
20           p_PROGRAM_UPDATE_DATE    DATE,
21           p_LEAD_ID    NUMBER,
22           p_OBSTACLE_CODE    VARCHAR2,
23           p_OBSTACLE    VARCHAR2,
24           p_OBSTACLE_STATUS    VARCHAR2,
25           p_COMMENTS    VARCHAR2,
26           p_ATTRIBUTE_CATEGORY    VARCHAR2,
27           p_ATTRIBUTE1    VARCHAR2,
28           p_ATTRIBUTE2    VARCHAR2,
29           p_ATTRIBUTE3    VARCHAR2,
30           p_ATTRIBUTE4    VARCHAR2,
31           p_ATTRIBUTE5    VARCHAR2,
32           p_ATTRIBUTE6    VARCHAR2,
33           p_ATTRIBUTE7    VARCHAR2,
34           p_ATTRIBUTE8    VARCHAR2,
35           p_ATTRIBUTE9    VARCHAR2,
36           p_ATTRIBUTE10    VARCHAR2,
37           p_ATTRIBUTE11    VARCHAR2,
38           p_ATTRIBUTE12    VARCHAR2,
39           p_ATTRIBUTE13    VARCHAR2,
40           p_ATTRIBUTE14    VARCHAR2,
41           p_ATTRIBUTE15    VARCHAR2);
42 
43 
44 PROCEDURE Update_Row(
45           p_LEAD_OBSTACLE_ID    NUMBER,
46           p_LAST_UPDATE_DATE    DATE,
47           p_LAST_UPDATED_BY    NUMBER,
48           p_CREATION_DATE    DATE,
49           p_CREATED_BY    NUMBER,
50           p_LAST_UPDATE_LOGIN    NUMBER,
51           p_REQUEST_ID    NUMBER,
52           p_PROGRAM_APPLICATION_ID    NUMBER,
53           p_PROGRAM_ID    NUMBER,
54           p_PROGRAM_UPDATE_DATE    DATE,
55           p_LEAD_ID    NUMBER,
56           p_OBSTACLE_CODE    VARCHAR2,
57           p_OBSTACLE    VARCHAR2,
58           p_OBSTACLE_STATUS    VARCHAR2,
59           p_COMMENTS    VARCHAR2,
60           p_ATTRIBUTE_CATEGORY    VARCHAR2,
61           p_ATTRIBUTE1    VARCHAR2,
62           p_ATTRIBUTE2    VARCHAR2,
63           p_ATTRIBUTE3    VARCHAR2,
64           p_ATTRIBUTE4    VARCHAR2,
65           p_ATTRIBUTE5    VARCHAR2,
66           p_ATTRIBUTE6    VARCHAR2,
67           p_ATTRIBUTE7    VARCHAR2,
68           p_ATTRIBUTE8    VARCHAR2,
69           p_ATTRIBUTE9    VARCHAR2,
70           p_ATTRIBUTE10    VARCHAR2,
71           p_ATTRIBUTE11    VARCHAR2,
72           p_ATTRIBUTE12    VARCHAR2,
73           p_ATTRIBUTE13    VARCHAR2,
74           p_ATTRIBUTE14    VARCHAR2,
75           p_ATTRIBUTE15    VARCHAR2);
76 
77 
78 PROCEDURE Lock_Row(
79           p_LEAD_OBSTACLE_ID    NUMBER,
80           p_LAST_UPDATE_DATE    DATE,
81           p_LAST_UPDATED_BY    NUMBER,
82           p_CREATION_DATE    DATE,
83           p_CREATED_BY    NUMBER,
84           p_LAST_UPDATE_LOGIN    NUMBER,
85           p_REQUEST_ID    NUMBER,
86           p_PROGRAM_APPLICATION_ID    NUMBER,
87           p_PROGRAM_ID    NUMBER,
88           p_PROGRAM_UPDATE_DATE    DATE,
89           p_LEAD_ID    NUMBER,
90           p_OBSTACLE_CODE    VARCHAR2,
91           p_OBSTACLE    VARCHAR2,
92           p_OBSTACLE_STATUS    VARCHAR2,
93           p_COMMENTS    VARCHAR2,
94           p_ATTRIBUTE_CATEGORY    VARCHAR2,
95           p_ATTRIBUTE1    VARCHAR2,
96           p_ATTRIBUTE2    VARCHAR2,
97           p_ATTRIBUTE3    VARCHAR2,
98           p_ATTRIBUTE4    VARCHAR2,
99           p_ATTRIBUTE5    VARCHAR2,
100           p_ATTRIBUTE6    VARCHAR2,
101           p_ATTRIBUTE7    VARCHAR2,
102           p_ATTRIBUTE8    VARCHAR2,
103           p_ATTRIBUTE9    VARCHAR2,
104           p_ATTRIBUTE10    VARCHAR2,
105           p_ATTRIBUTE11    VARCHAR2,
106           p_ATTRIBUTE12    VARCHAR2,
107           p_ATTRIBUTE13    VARCHAR2,
108           p_ATTRIBUTE14    VARCHAR2,
109           p_ATTRIBUTE15    VARCHAR2);
110 
111 
112 PROCEDURE Delete_Row(
114 End AS_LEAD_OBSTACLES_PKG;
113     p_LEAD_OBSTACLE_ID  NUMBER);