1 PACKAGE pn_contact_assignments_pkg AUTHID CURRENT_USER AS
2 -- $Header: PNTCOASS.pls 120.1 2005/07/25 06:41:41 appldev ship $
3 ------------------------------------------------------------------------
4 -- PROCEDURE : Insert_Row
5 ------------------------------------------------------------------------
6 PROCEDURE Insert_Row
7 (
8 X_ROWID IN OUT NOCOPY VARCHAR2
9 ,X_CONTACT_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
10 ,X_LAST_UPDATE_DATE IN DATE
11 ,X_LAST_UPDATED_BY IN NUMBER
12 ,X_CREATION_DATE IN DATE
13 ,X_CREATED_BY IN NUMBER
14 ,X_LAST_UPDATE_LOGIN IN NUMBER
15 ,X_COMPANY_ID IN NUMBER
16 ,X_COMPANY_SITE_ID IN NUMBER
17 ,X_LEASE_ID IN NUMBER
18 ,X_LEASE_CHANGE_ID IN NUMBER
19 ,X_LOCATION_ID IN NUMBER
20 ,X_STATUS IN VARCHAR2
21 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
22 ,X_ATTRIBUTE1 IN VARCHAR2
23 ,X_ATTRIBUTE2 IN VARCHAR2
24 ,X_ATTRIBUTE3 IN VARCHAR2
25 ,X_ATTRIBUTE4 IN VARCHAR2
26 ,X_ATTRIBUTE5 IN VARCHAR2
27 ,X_ATTRIBUTE6 IN VARCHAR2
28 ,X_ATTRIBUTE7 IN VARCHAR2
29 ,X_ATTRIBUTE8 IN VARCHAR2
30 ,X_ATTRIBUTE9 IN VARCHAR2
31 ,X_ATTRIBUTE10 IN VARCHAR2
32 ,X_ATTRIBUTE11 IN VARCHAR2
33 ,X_ATTRIBUTE12 IN VARCHAR2
34 ,X_ATTRIBUTE13 IN VARCHAR2
35 ,X_ATTRIBUTE14 IN VARCHAR2
36 ,X_ATTRIBUTE15 IN VARCHAR2
37 ,x_org_id IN NUMBER
38 );
39
40 ------------------------------------------------------------------------
41 -- PROCEDURE : Lock_Row
42 ------------------------------------------------------------------------
43 PROCEDURE Lock_Row
44 (
45 X_CONTACT_ASSIGNMENT_ID IN NUMBER
46 ,X_COMPANY_ID IN NUMBER
47 ,X_COMPANY_SITE_ID IN NUMBER
48 ,X_LEASE_ID IN NUMBER
49 ,X_LEASE_CHANGE_ID IN NUMBER
50 ,X_LOCATION_ID IN NUMBER
51 ,X_STATUS IN VARCHAR2
52 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
53 ,X_ATTRIBUTE1 IN VARCHAR2
54 ,X_ATTRIBUTE2 IN VARCHAR2
55 ,X_ATTRIBUTE3 IN VARCHAR2
56 ,X_ATTRIBUTE4 IN VARCHAR2
57 ,X_ATTRIBUTE5 IN VARCHAR2
58 ,X_ATTRIBUTE6 IN VARCHAR2
59 ,X_ATTRIBUTE7 IN VARCHAR2
60 ,X_ATTRIBUTE8 IN VARCHAR2
61 ,X_ATTRIBUTE9 IN VARCHAR2
62 ,X_ATTRIBUTE10 IN VARCHAR2
63 ,X_ATTRIBUTE11 IN VARCHAR2
64 ,X_ATTRIBUTE12 IN VARCHAR2
65 ,X_ATTRIBUTE13 IN VARCHAR2
66 ,X_ATTRIBUTE14 IN VARCHAR2
67 ,X_ATTRIBUTE15 IN VARCHAR2
68 );
69
70
71 ------------------------------------------------------------------------
72 -- PROCEDURE : Update_Row
73 ------------------------------------------------------------------------
74 PROCEDURE Update_Row
75 (
76 X_CONTACT_ASSIGNMENT_ID IN NUMBER
77 ,X_LAST_UPDATE_DATE IN DATE
78 ,X_LAST_UPDATED_BY IN NUMBER
79 ,X_LAST_UPDATE_LOGIN IN NUMBER
80 ,X_COMPANY_ID IN NUMBER
81 ,X_COMPANY_SITE_ID IN NUMBER
82 ,X_LEASE_ID IN NUMBER
83 ,X_LEASE_CHANGE_ID IN NUMBER
84 ,X_LOCATION_ID IN NUMBER
85 ,X_STATUS IN VARCHAR2
86 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
87 ,X_ATTRIBUTE1 IN VARCHAR2
88 ,X_ATTRIBUTE2 IN VARCHAR2
89 ,X_ATTRIBUTE3 IN VARCHAR2
90 ,X_ATTRIBUTE4 IN VARCHAR2
91 ,X_ATTRIBUTE5 IN VARCHAR2
92 ,X_ATTRIBUTE6 IN VARCHAR2
93 ,X_ATTRIBUTE7 IN VARCHAR2
94 ,X_ATTRIBUTE8 IN VARCHAR2
95 ,X_ATTRIBUTE9 IN VARCHAR2
96 ,X_ATTRIBUTE10 IN VARCHAR2
97 ,X_ATTRIBUTE11 IN VARCHAR2
98 ,X_ATTRIBUTE12 IN VARCHAR2
99 ,X_ATTRIBUTE13 IN VARCHAR2
100 ,X_ATTRIBUTE14 IN VARCHAR2
101 ,X_ATTRIBUTE15 IN VARCHAR2
102 );
103
104 ------------------------------------------------------------------------
105 -- PROCEDURE : Delete_Row
106 ------------------------------------------------------------------------
107 PROCEDURE Delete_Row
108 (
109 X_CONTACT_ASSIGNMENT_ID IN NUMBER
110 );
111
112
113 END pn_contact_assignments_pkg;
[Home] [Help]