[Home] [Help]
TYPE BODY: APPS.HZ_RELATIONSHIP_OBJ
Source
1 TYPE BODY hz_relationship_obj AS
2
3 STATIC FUNCTION create_object(
4 p_relationship_id IN NUMBER := NULL,
5 p_related_object_id IN NUMBER := NULL,
6 p_related_object_type IN VARCHAR2 := NULL,
7 p_related_object_osr IN VARCHAR2 := NULL,
8 p_related_object_os IN VARCHAR2 := NULL,
9 p_relationship_code IN VARCHAR2 := NULL,
10 p_relationship_type IN VARCHAR2 := NULL,
11 p_comments IN VARCHAR2 := NULL,
12 p_start_date IN DATE := NULL,
13 p_end_date IN DATE := NULL,
14 p_status IN VARCHAR2 := NULL,
15 p_attribute_category IN VARCHAR2 := NULL,
16 p_attribute1 IN VARCHAR2 := NULL,
17 p_attribute2 IN VARCHAR2 := NULL,
18 p_attribute3 IN VARCHAR2 := NULL,
19 p_attribute4 IN VARCHAR2 := NULL,
20 p_attribute5 IN VARCHAR2 := NULL,
21 p_attribute6 IN VARCHAR2 := NULL,
22 p_attribute7 IN VARCHAR2 := NULL,
23 p_attribute8 IN VARCHAR2 := NULL,
24 p_attribute9 IN VARCHAR2 := NULL,
25 p_attribute10 IN VARCHAR2 := NULL,
26 p_attribute11 IN VARCHAR2 := NULL,
27 p_attribute12 IN VARCHAR2 := NULL,
28 p_attribute13 IN VARCHAR2 := NULL,
29 p_attribute14 IN VARCHAR2 := NULL,
30 p_attribute15 IN VARCHAR2 := NULL,
31 p_attribute16 IN VARCHAR2 := NULL,
32 p_attribute17 IN VARCHAR2 := NULL,
33 p_attribute18 IN VARCHAR2 := NULL,
34 p_attribute19 IN VARCHAR2 := NULL,
35 p_attribute20 IN VARCHAR2 := NULL,
36 p_additional_information1 IN VARCHAR2 := NULL,
37 p_additional_information2 IN VARCHAR2 := NULL,
38 p_additional_information3 IN VARCHAR2 := NULL,
39 p_additional_information4 IN VARCHAR2 := NULL,
40 p_additional_information5 IN VARCHAR2 := NULL,
41 p_additional_information6 IN VARCHAR2 := NULL,
42 p_additional_information7 IN VARCHAR2 := NULL,
43 p_additional_information8 IN VARCHAR2 := NULL,
44 p_additional_information9 IN VARCHAR2 := NULL,
45 p_additional_information10 IN VARCHAR2 := NULL,
46 p_additional_information11 IN VARCHAR2 := NULL,
47 p_additional_information12 IN VARCHAR2 := NULL,
48 p_additional_information13 IN VARCHAR2 := NULL,
49 p_additional_information14 IN VARCHAR2 := NULL,
50 p_additional_information15 IN VARCHAR2 := NULL,
51 p_additional_information16 IN VARCHAR2 := NULL,
52 p_additional_information17 IN VARCHAR2 := NULL,
53 p_additional_information18 IN VARCHAR2 := NULL,
54 p_additional_information19 IN VARCHAR2 := NULL,
55 p_additional_information20 IN VARCHAR2 := NULL,
56 p_additional_information21 IN VARCHAR2 := NULL,
57 p_additional_information22 IN VARCHAR2 := NULL,
58 p_additional_information23 IN VARCHAR2 := NULL,
59 p_additional_information24 IN VARCHAR2 := NULL,
60 p_additional_information25 IN VARCHAR2 := NULL,
61 p_additional_information26 IN VARCHAR2 := NULL,
62 p_additional_information27 IN VARCHAR2 := NULL,
63 p_additional_information28 IN VARCHAR2 := NULL,
64 p_additional_information29 IN VARCHAR2 := NULL,
65 p_additional_information30 IN VARCHAR2 := NULL,
66 p_percentage_ownership IN NUMBER := NULL,
67 p_actual_content_source IN VARCHAR2 := NULL
68 ) RETURN hz_relationship_obj AS
69 BEGIN
70 RETURN hz_relationship_obj(
71 action_type => NULL,
72 common_obj_id => NULL,
73 relationship_id => p_relationship_id,
74 parent_object_type => NULL,
75 parent_object_id => NULL,
76 related_object_id => p_related_object_id,
77 related_object_type => p_related_object_type,
78 related_object_osr => p_related_object_osr,
79 related_object_os => p_related_object_os,
80 relationship_code => p_relationship_code,
81 relationship_type => p_relationship_type,
82 comments => p_comments,
83 start_date => p_start_date,
84 end_date => p_end_date,
85 status => p_status,
86 attribute_category => p_attribute_category,
87 attribute1 => p_attribute1,
88 attribute2 => p_attribute2,
89 attribute3 => p_attribute3,
90 attribute4 => p_attribute4,
91 attribute5 => p_attribute5,
92 attribute6 => p_attribute6,
93 attribute7 => p_attribute7,
94 attribute8 => p_attribute8,
95 attribute9 => p_attribute9,
96 attribute10 => p_attribute10,
97 attribute11 => p_attribute11,
98 attribute12 => p_attribute12,
99 attribute13 => p_attribute13,
100 attribute14 => p_attribute14,
101 attribute15 => p_attribute15,
102 attribute16 => p_attribute16,
103 attribute17 => p_attribute17,
104 attribute18 => p_attribute18,
105 attribute19 => p_attribute19,
106 attribute20 => p_attribute20,
107 program_update_date => NULL,
108 created_by_module => NULL,
109 created_by_name => NULL,
110 creation_date => NULL,
111 last_update_date => NULL,
112 last_updated_by_name => NULL,
113 additional_information1 => p_additional_information1,
114 additional_information2 => p_additional_information2,
115 additional_information3 => p_additional_information3,
116 additional_information4 => p_additional_information4,
117 additional_information5 => p_additional_information5,
118 additional_information6 => p_additional_information6,
119 additional_information7 => p_additional_information7,
120 additional_information8 => p_additional_information8,
121 additional_information9 => p_additional_information9,
122 additional_information10 => p_additional_information10,
123 additional_information11 => p_additional_information11,
124 additional_information12 => p_additional_information12,
125 additional_information13 => p_additional_information13,
126 additional_information14 => p_additional_information14,
127 additional_information15 => p_additional_information15,
128 additional_information16 => p_additional_information16,
129 additional_information17 => p_additional_information17,
130 additional_information18 => p_additional_information18,
131 additional_information19 => p_additional_information19,
132 additional_information20 => p_additional_information20,
133 additional_information21 => p_additional_information21,
134 additional_information22 => p_additional_information22,
135 additional_information23 => p_additional_information23,
136 additional_information24 => p_additional_information24,
137 additional_information25 => p_additional_information25,
138 additional_information26 => p_additional_information26,
139 additional_information27 => p_additional_information27,
140 additional_information28 => p_additional_information28,
141 additional_information29 => p_additional_information29,
142 additional_information30 => p_additional_information30,
143 percentage_ownership => p_percentage_ownership,
144 actual_content_source => p_actual_content_source,
145 object_orig_sys_objs => HZ_ORIG_SYS_REF_OBJ_TBL()
146 );
147 END create_object;
148 END;