1 Package PQP_Address_Synchronization AUTHID CURRENT_USER AS
2 /* $Header: pqaddsyn.pkh 120.0 2005/05/29 01:41:52 appldev noship $ */
3
4 -- =============================================================================
5 -- ~ Addr_DDF_Ins:
6 -- =============================================================================
7 PROCEDURE Addr_DDF_Ins
8 (p_address_id IN Number
9 ,p_business_group_id IN Number
10 ,p_person_id IN Number
11 ,p_party_id IN Number
12 ,p_date_from IN Date
13 ,p_primary_flag IN Varchar2
14 ,p_style IN Varchar2
15 ,p_address_line1 IN Varchar2
16 ,p_address_line2 IN Varchar2
17 ,p_address_line3 IN Varchar2
18 ,p_address_type IN Varchar2
19 ,p_country IN Varchar2
20 ,p_date_to IN Date
21 ,p_postal_code IN Varchar2
22 ,p_region_1 IN Varchar2
23 ,p_region_2 IN Varchar2
24 ,p_region_3 IN Varchar2
25 ,p_telephone_number_1 IN Varchar2
26 ,p_telephone_number_2 IN Varchar2
27 ,p_telephone_number_3 IN Varchar2
28 ,p_town_or_city IN Varchar2
29 ,p_add_information13 IN Varchar2
30 ,p_add_information14 IN Varchar2
31 ,p_add_information15 IN Varchar2
32 ,p_add_information16 IN Varchar2
33 ,p_add_information17 IN Varchar2
34 ,p_add_information18 IN Varchar2
35 ,p_add_information19 IN Varchar2
36 ,p_add_information20 IN Varchar2
37 ,p_object_version_number IN Number
38 ,p_effective_date IN Date
39 ,p_validate_county IN Boolean
40 );
41 -- =============================================================================
42 -- ~ Addr_DDF_Upd:
43 -- =============================================================================
44 PROCEDURE Addr_DDF_Upd
45 (p_address_id IN Number
46 ,p_business_group_id IN Number
47 ,p_person_id IN Number
48 ,p_date_from IN Date
49 ,p_address_line1 IN Varchar2
50 ,p_address_line2 IN Varchar2
51 ,p_address_line3 IN Varchar2
52 ,p_address_type IN Varchar2
53 ,p_country IN Varchar2
54 ,p_date_to IN Date
55 ,p_postal_code IN Varchar2
56 ,p_region_1 IN Varchar2
57 ,p_region_2 IN Varchar2
58 ,p_region_3 IN Varchar2
59 ,p_telephone_number_1 IN Varchar2
60 ,p_telephone_number_2 IN Varchar2
61 ,p_telephone_number_3 IN Varchar2
62 ,p_town_or_city IN Varchar2
63 ,p_add_information13 IN Varchar2
64 ,p_add_information14 IN Varchar2
65 ,p_add_information15 IN Varchar2
66 ,p_add_information16 IN Varchar2
67 ,p_add_information17 IN Varchar2
68 ,p_add_information18 IN Varchar2
69 ,p_add_information19 IN Varchar2
70 ,p_add_information20 IN Varchar2
71 ,p_object_version_number IN Number
72 ,p_effective_date IN Date
73 ,p_prflagval_override IN Boolean
74 ,p_validate_county IN Boolean
75 -- Old
76 ,p_business_group_id_o IN Number
77 ,p_person_id_o IN Number
78 ,p_date_from_o IN Date
79 ,p_primary_flag_o IN Varchar2
80 ,p_style_o IN Varchar2
81 ,p_address_line1_o IN Varchar2
82 ,p_address_line2_o IN Varchar2
83 ,p_address_line3_o IN Varchar2
84 ,p_address_type_o IN Varchar2
85 ,p_country_o IN Varchar2
86 ,p_date_to_o IN Date
87 ,p_postal_code_o IN Varchar2
88 ,p_region_1_o IN Varchar2
89 ,p_region_2_o IN Varchar2
90 ,p_region_3_o IN Varchar2
91 ,p_telephone_number_1_o IN Varchar2
92 ,p_telephone_number_2_o IN Varchar2
93 ,p_telephone_number_3_o IN Varchar2
94 ,p_town_or_city_o IN Varchar2
95 ,p_add_information13_o IN Varchar2
96 ,p_add_information14_o IN Varchar2
97 ,p_add_information15_o IN Varchar2
98 ,p_add_information16_o IN Varchar2
99 ,p_add_information17_o IN Varchar2
100 ,p_add_information18_o IN Varchar2
101 ,p_add_information19_o IN Varchar2
102 ,p_add_information20_o IN Varchar2
103 ,p_object_version_number_o IN Number
104 ,p_party_id_o IN Number
105 );
106 -- =============================================================================
107 -- ~ Addr_DDF_Del:
108 -- =============================================================================
109 PROCEDURE Addr_DDF_Del
110 (p_address_id IN Number
111 ,p_business_group_id_o IN Number
112 ,p_date_from_o IN Date
113 ,p_address_line1_o IN Varchar2
114 ,p_address_line2_o IN Varchar2
115 ,p_address_line3_o IN Varchar2
116 ,p_address_type_o IN Varchar2
117 ,p_country_o IN Varchar2
118 ,p_date_to_o IN Date
119 ,p_postal_code_o IN Varchar2
120 ,p_region_1_o IN Varchar2
121 ,p_region_2_o IN Varchar2
122 ,p_region_3_o IN Varchar2
123 ,p_telephone_number_1_o IN Varchar2
124 ,p_telephone_number_2_o IN Varchar2
125 ,p_telephone_number_3_o IN Varchar2
126 ,p_town_or_city_o IN Varchar2
127 ,p_add_information13_o IN Varchar2
128 ,p_add_information14_o IN Varchar2
129 ,p_add_information15_o IN Varchar2
130 ,p_add_information16_o IN Varchar2
131 ,p_add_information17_o IN Varchar2
132 ,p_add_information18_o IN Varchar2
133 ,p_add_information19_o IN Varchar2
134 ,p_add_information20_o IN Varchar2
135 ,p_object_version_number_o IN Number
136 );
137
138 END PQP_Address_Synchronization;
[Home] [Help]