[Home] [Help]
PACKAGE: APPS.PER_CONTACT_RELATIONSHIP_SWI
Source
1 package per_contact_relationship_swi as
2 /* $Header: pectrswi.pkh 120.0.12000000.1 2007/02/08 12:04:53 ssutar noship $ */
3
4 procedure ins (
5 p_contact_relationship_id in number,
6 p_business_group_id in number,
7 p_person_id in number,
8 p_contact_person_id in number,
9 p_contact_type in varchar2,
10 p_comments in long default null,
11 p_primary_contact_flag in varchar2 default 'N',
12 p_request_id in number default null,
13 p_program_application_id in number default null,
14 p_program_id in number default null,
15 p_program_update_date in date default null,
16 p_date_start in date default null,
17 p_start_life_reason_id in number default null,
18 p_date_end in date default null,
19 p_end_life_reason_id in number default null,
20 p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N',
21 p_personal_flag in varchar2 default 'N',
22 p_sequence_number in number default null,
23 p_cont_attribute_category in varchar2 default null,
24 p_cont_attribute1 in varchar2 default null,
25 p_cont_attribute2 in varchar2 default null,
26 p_cont_attribute3 in varchar2 default null,
27 p_cont_attribute4 in varchar2 default null,
28 p_cont_attribute5 in varchar2 default null,
29 p_cont_attribute6 in varchar2 default null,
30 p_cont_attribute7 in varchar2 default null,
31 p_cont_attribute8 in varchar2 default null,
32 p_cont_attribute9 in varchar2 default null,
33 p_cont_attribute10 in varchar2 default null,
34 p_cont_attribute11 in varchar2 default null,
35 p_cont_attribute12 in varchar2 default null,
36 p_cont_attribute13 in varchar2 default null,
37 p_cont_attribute14 in varchar2 default null,
38 p_cont_attribute15 in varchar2 default null,
39 p_cont_attribute16 in varchar2 default null,
40 p_cont_attribute17 in varchar2 default null,
41 p_cont_attribute18 in varchar2 default null,
42 p_cont_attribute19 in varchar2 default null,
43 p_cont_attribute20 in varchar2 default null,
44 p_cont_information_category in varchar2 default null,
45 p_cont_information1 in varchar2 default null,
46 p_cont_information2 in varchar2 default null,
47 p_cont_information3 in varchar2 default null,
48 p_cont_information4 in varchar2 default null,
49 p_cont_information5 in varchar2 default null,
50 p_cont_information6 in varchar2 default null,
51 p_cont_information7 in varchar2 default null,
52 p_cont_information8 in varchar2 default null,
53 p_cont_information9 in varchar2 default null,
54 p_cont_information10 in varchar2 default null,
55 p_cont_information11 in varchar2 default null,
56 p_cont_information12 in varchar2 default null,
57 p_cont_information13 in varchar2 default null,
58 p_cont_information14 in varchar2 default null,
59 p_cont_information15 in varchar2 default null,
60 p_cont_information16 in varchar2 default null,
61 p_cont_information17 in varchar2 default null,
62 p_cont_information18 in varchar2 default null,
63 p_cont_information19 in varchar2 default null,
64 p_cont_information20 in varchar2 default null,
65 p_third_party_pay_flag in varchar2 default 'N',
66 p_bondholder_flag in varchar2 default 'N',
67 p_dependent_flag in varchar2 default 'N',
68 p_beneficiary_flag in varchar2 default 'N',
69 p_object_version_number out nocopy number,
70 p_effective_date in date default null,
71 p_validate in number default hr_api.g_false_num,
72 p_return_status out nocopy varchar2
73 );
74
75 ----------------------------------------------------------------------------
76 Procedure upd (
77 p_contact_relationship_id in number,
78 p_contact_type in varchar2 default hr_api.g_varchar2,
79 p_comments in long default hr_api.g_varchar2,
80 p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81 p_request_id in number default hr_api.g_number,
82 p_program_application_id in number default hr_api.g_number,
83 p_program_id in number default hr_api.g_number,
84 p_program_update_date in date default hr_api.g_date,
85 p_date_start in date default hr_api.g_date,
86 p_start_life_reason_id in number default hr_api.g_number,
87 p_date_end in date default hr_api.g_date,
88 p_end_life_reason_id in number default hr_api.g_number,
89 p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90 p_personal_flag in varchar2 default hr_api.g_varchar2,
91 p_sequence_number in number default hr_api.g_number,
92 p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93 p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94 p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95 p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96 p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97 p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98 p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99 p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100 p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101 p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102 p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103 p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104 p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105 p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106 p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107 p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108 p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109 p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110 p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111 p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112 p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113 p_cont_information_category in varchar2 default hr_api.g_varchar2,
114 p_cont_information1 in varchar2 default hr_api.g_varchar2,
115 p_cont_information2 in varchar2 default hr_api.g_varchar2,
116 p_cont_information3 in varchar2 default hr_api.g_varchar2,
117 p_cont_information4 in varchar2 default hr_api.g_varchar2,
118 p_cont_information5 in varchar2 default hr_api.g_varchar2,
119 p_cont_information6 in varchar2 default hr_api.g_varchar2,
120 p_cont_information7 in varchar2 default hr_api.g_varchar2,
121 p_cont_information8 in varchar2 default hr_api.g_varchar2,
122 p_cont_information9 in varchar2 default hr_api.g_varchar2,
123 p_cont_information10 in varchar2 default hr_api.g_varchar2,
124 p_cont_information11 in varchar2 default hr_api.g_varchar2,
125 p_cont_information12 in varchar2 default hr_api.g_varchar2,
126 p_cont_information13 in varchar2 default hr_api.g_varchar2,
127 p_cont_information14 in varchar2 default hr_api.g_varchar2,
128 p_cont_information15 in varchar2 default hr_api.g_varchar2,
129 p_cont_information16 in varchar2 default hr_api.g_varchar2,
130 p_cont_information17 in varchar2 default hr_api.g_varchar2,
131 p_cont_information18 in varchar2 default hr_api.g_varchar2,
132 p_cont_information19 in varchar2 default hr_api.g_varchar2,
133 p_cont_information20 in varchar2 default hr_api.g_varchar2,
134 p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135 p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136 p_dependent_flag in varchar2 default hr_api.g_varchar2,
137 p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138 p_object_version_number in out nocopy number,
139 p_effective_date in date,
140 p_validate in number default hr_api.g_false_num,
141 p_return_status out nocopy varchar2
142 );
143
144 ----------------------------------------------------------------------------
145 procedure del (
146 p_contact_relationship_id in number,
147 p_object_version_number in number,
148 p_validate in number default hr_api.g_false_num,
149 p_return_status out nocopy varchar2
150 );
151
152 end per_contact_relationship_swi;