[Home] [Help]
PACKAGE: APPS.RRS_IMPORT_INTERFACE_PKG
Source
1 package RRS_IMPORT_INTERFACE_PKG AUTHID DEFINER as
2 /* $Header: RRSIMINS.pls 120.1 2010/10/27 20:45:40 sunarang noship $ */
3
4 Procedure main(
5 ERRBUF OUT NOCOPY VARCHAR2
6 ,RETCODE OUT NOCOPY VARCHAR2
7 ,p_batch_id IN number
8 ,p_purge_rows IN varchar2
9 ,p_gather_stats IN varchar2
10 );
11
12 Procedure check_prereqs(
13 p_batch_id IN number
14 ,x_return_status OUT NOCOPY varchar2
15 );
16
17 Procedure Check_site_status_code(
18 p_site_id_num IN varchar2
19 ,p_site_status_code IN varchar2
20 ,x_return_flag OUT NOCOPY varchar2
21 );
22
23 Procedure Check_site_id_num(
24 p_site_id_num IN varchar2
25 ,p_site_id IN varchar2
26 ,p_transaction_type IN varchar2
27 ,x_return_flag OUT NOCOPY varchar2
28 );
29
30 Procedure validate_new_rows(
31 p_batch_id IN number
32 ,p_purge_rows IN varchar2
33 ,x_return_flag OUT NOCOPY varchar2
34 );
35
36 Procedure Validate_update_rows(
37 p_batch_id IN number
38 ,p_purge_rows IN varchar2
39 ,x_return_flag OUT NOCOPY varchar2
40 );
41
42
43
44 Procedure Check_site_type_code(
45 p_site_id_num IN varchar2
46 ,p_site_type_code IN varchar2
47 ,x_return_flag OUT NOCOPY varchar2
48 );
49
50 Procedure Check_site_party_id(
51 p_site_id_num IN varchar2
52 ,p_site_party_id IN number
53 ,x_return_flag OUT NOCOPY varchar2
54 );
55
56 Procedure Check_le_party_id(
57 p_site_id_num IN varchar2
58 ,p_le_party_id IN number
59 ,x_return_flag OUT NOCOPY varchar2
60 );
61
62 Procedure Check_site_brand_code(
63 p_site_id_num IN varchar2
64 ,p_site_brand_code IN varchar2
65 ,x_return_flag OUT NOCOPY varchar2
66 );
67
68 Procedure Check_site_calendar_code(
69 p_site_id_num IN varchar2
70 ,p_site_calendar_code IN varchar2
71 ,x_return_flag OUT NOCOPY varchar2
72 );
73
74 Procedure Check_site_use_type_code(
75 p_site_id_num IN varchar2
76 ,p_site_use_type_code IN varchar2
77 ,x_return_flag OUT NOCOPY varchar2
78 );
79
80 Procedure Check_geo_source_code(
81 p_site_id_num IN varchar2
82 ,p_geo_source_code IN varchar2
83 ,x_return_flag OUT NOCOPY varchar2
84 );
85
86 Procedure Check_location_id(
87 p_site_id_num IN varchar2
88 ,p_location_id IN number
89 ,p_country_code IN varchar2
90 ,x_return_flag OUT NOCOPY varchar2
91 );
92
93 Procedure Check_address1(
94 p_site_id_num IN varchar2
95 ,p_location_status IN varchar2
96 ,p_location_id IN number
97 ,p_country_code IN varchar2
98 ,p_address1 IN varchar2
99 ,x_return_flag OUT NOCOPY varchar2
100 );
101
102 Procedure Check_location_country(
103 p_site_id_num IN varchar2
104 ,p_location_id IN number
105 ,p_country_code IN varchar2
106 ,x_return_flag OUT NOCOPY varchar2
107 );
108
109 Procedure Write_interface_errors(
110 p_processing_errors IN RRS_PROCESSING_ERRORS_TAB
111 );
112
113 Procedure prepare_error_mesg(
114 p_site_id IN varchar2
115 ,p_site_id_num IN varchar2
116 ,p_column_name IN varchar2
117 ,p_message_name IN varchar2
118 ,p_message_text IN varchar2
119 ,p_source_table_name IN varchar2
120 ,p_destination_table_name IN varchar2
121 ,p_process_status IN varchar2
122 ,p_transaction_type IN varchar2
123 ,p_batch_id IN number
124 ,p_processing_errors IN OUT NOCOPY RRS_PROCESSING_ERRORS_TAB
125 );
126
127 Procedure Create_sites(
128 p_batch_id IN number
129 ,p_transaction_type IN varchar2
130 ,p_purge_rows IN varchar2
131 ,x_num_rows OUT NOCOPY number
132 ,x_return_status OUT NOCOPY varchar2
133 );
134
135
136 Procedure Update_sites(
137 p_batch_id IN number
138 ,p_transaction_type IN varchar2
139 ,p_purge_rows IN varchar2
140 ,x_num_rows OUT NOCOPY number
141 ,x_return_status OUT NOCOPY varchar2
142 );
143
144 end RRS_IMPORT_INTERFACE_PKG;