1 PACKAGE XLE_Association_PKG AS
2 /* $Header: xleassts.pls 120.1 2005/05/03 12:36:46 ttran ship $ */
3
4 PROCEDURE Insert_Row(
5 x_association_id IN OUT NOCOPY NUMBER,
6 p_association_type_id IN NUMBER DEFAULT NULL,
7 p_subject_id IN NUMBER DEFAULT NULL,
8 p_subject_parent_id IN NUMBER DEFAULT NULL,
9 p_object_id IN NUMBER DEFAULT NULL,
10 p_effective_from IN DATE DEFAULT NULL,
11 p_effective_to IN DATE DEFAULT NULL,
12 p_assoc_information_context IN VARCHAR2 DEFAULT NULL,
13 p_assoc_information1 IN VARCHAR2 DEFAULT NULL,
14 p_assoc_information2 IN VARCHAR2 DEFAULT NULL,
15 p_assoc_information3 IN VARCHAR2 DEFAULT NULL,
16 p_assoc_information4 IN VARCHAR2 DEFAULT NULL,
17 p_assoc_information5 IN VARCHAR2 DEFAULT NULL,
18 p_assoc_information6 IN VARCHAR2 DEFAULT NULL,
19 p_assoc_information7 IN VARCHAR2 DEFAULT NULL,
20 p_assoc_information8 IN VARCHAR2 DEFAULT NULL,
21 p_assoc_information9 IN VARCHAR2 DEFAULT NULL,
22 p_assoc_information10 IN VARCHAR2 DEFAULT NULL,
23 p_assoc_information11 IN VARCHAR2 DEFAULT NULL,
24 p_assoc_information12 IN VARCHAR2 DEFAULT NULL,
25 p_assoc_information13 IN VARCHAR2 DEFAULT NULL,
26 p_assoc_information14 IN VARCHAR2 DEFAULT NULL,
27 p_assoc_information15 IN VARCHAR2 DEFAULT NULL,
28 p_assoc_information16 IN VARCHAR2 DEFAULT NULL,
29 p_assoc_information17 IN VARCHAR2 DEFAULT NULL,
30 p_assoc_information18 IN VARCHAR2 DEFAULT NULL,
31 p_assoc_information19 IN VARCHAR2 DEFAULT NULL,
32 p_assoc_information20 IN VARCHAR2 DEFAULT NULL,
33 p_object_version_number IN NUMBER DEFAULT NULL,
34 p_last_update_date IN DATE DEFAULT NULL,
35 p_last_updated_by IN NUMBER DEFAULT NULL,
36 p_creation_date IN DATE DEFAULT NULL,
37 p_created_by IN NUMBER DEFAULT NULL,
38 p_last_update_login IN NUMBER DEFAULT NULL
39 );
40
41 PROCEDURE Update_Row(
42 p_association_id IN NUMBER,
43 p_association_type_id IN NUMBER DEFAULT NULL,
44 p_subject_id IN NUMBER DEFAULT NULL,
45 p_subject_parent_id IN NUMBER DEFAULT NULL,
46 p_object_id IN NUMBER DEFAULT NULL,
47 p_effective_from IN DATE DEFAULT NULL,
48 p_effective_to IN DATE DEFAULT NULL,
49 p_assoc_information_context IN VARCHAR2 DEFAULT NULL,
50 p_assoc_information1 IN VARCHAR2 DEFAULT NULL,
51 p_assoc_information2 IN VARCHAR2 DEFAULT NULL,
52 p_assoc_information3 IN VARCHAR2 DEFAULT NULL,
53 p_assoc_information4 IN VARCHAR2 DEFAULT NULL,
54 p_assoc_information5 IN VARCHAR2 DEFAULT NULL,
55 p_assoc_information6 IN VARCHAR2 DEFAULT NULL,
56 p_assoc_information7 IN VARCHAR2 DEFAULT NULL,
57 p_assoc_information8 IN VARCHAR2 DEFAULT NULL,
58 p_assoc_information9 IN VARCHAR2 DEFAULT NULL,
59 p_assoc_information10 IN VARCHAR2 DEFAULT NULL,
60 p_assoc_information11 IN VARCHAR2 DEFAULT NULL,
61 p_assoc_information12 IN VARCHAR2 DEFAULT NULL,
62 p_assoc_information13 IN VARCHAR2 DEFAULT NULL,
63 p_assoc_information14 IN VARCHAR2 DEFAULT NULL,
64 p_assoc_information15 IN VARCHAR2 DEFAULT NULL,
65 p_assoc_information16 IN VARCHAR2 DEFAULT NULL,
66 p_assoc_information17 IN VARCHAR2 DEFAULT NULL,
67 p_assoc_information18 IN VARCHAR2 DEFAULT NULL,
68 p_assoc_information19 IN VARCHAR2 DEFAULT NULL,
69 p_assoc_information20 IN VARCHAR2 DEFAULT NULL,
70 p_object_version_number IN NUMBER DEFAULT NULL,
71 p_last_update_date IN DATE DEFAULT NULL,
72 p_last_updated_by IN NUMBER DEFAULT NULL,
73 p_last_update_login IN NUMBER DEFAULT NULL
74 );
75
76
77 PROCEDURE Delete_Row(
78 p_association_id IN NUMBER
79 );
80
81 PROCEDURE Lock_Row(
82 p_association_id IN NUMBER,
83 p_object_version_number IN NUMBER
84 );
85
86
87 END XLE_Association_PKG;
88