1 PACKAGE Gmf_Glsynch AUTHID CURRENT_USER AS
2 /* $Header: gmfsyncs.pls 115.3 2002/11/11 00:46:15 rseshadr ship $ */
3
4 PROCEDURE Write_Exception(
5 pi_table_code in varchar2,
6 pi_key_name in varchar2,
7 pi_message_code in varchar2,
8 pi_col1 in varchar2,
9 pi_col2 in varchar2,
10 pi_col3 in varchar2,
11 pi_col4 in varchar2,
12 pi_col5 in varchar2,
13 pi_key_value in varchar2) ;
14
15 PROCEDURE Delete_Exception(
16 pi_table_code in varchar2,
17 pi_key_value in varchar2) ;
18
19 PROCEDURE Check_Required(
20 pi_table_name in varchar2,
21 pi_key_name in varchar2,
22 pi_key_value in varchar2,
23 pi_field_name in varchar2,
24 pi_field_value in varchar2) ;
25
26 PROCEDURE Check_Length(
27 pi_table_name in varchar2,
28 pi_key_name in varchar2,
29 pi_key_value in varchar2,
30 pi_field_name in varchar2,
31 pi_field_value in varchar2,
32 pi_field_length in number) ;
33
34 PROCEDURE Check_Case(
35 pi_table_name in varchar2,
36 pi_key_name in varchar2,
37 pi_key_value in varchar2,
38 pi_field_name in varchar2,
39 pi_field_value in varchar2) ;
40
41
42 PROCEDURE Check_Multiple_Delim(
43 pi_table_name in varchar2,
44 pi_key_name in varchar2,
45 pi_key_value in varchar2,
46 pi_field_name in varchar2,
47 pi_field_value in varchar2,
48 pi_delim in varchar2) ;
49
50 PROCEDURE Validate_Currency(
51 pi_table_name in varchar2,
52 pi_key_name in varchar2,
53 pi_key_value in varchar2,
54 pi_field_name in varchar2,
55 pi_field_value in varchar2) ;
56
57 PROCEDURE Validate_Rate_Type(
58 pi_table_name in varchar2,
59 pi_key_name in varchar2,
60 pi_key_value in varchar2,
61 pi_field_name in varchar2,
62 pi_field_value in varchar2) ;
63
64 PROCEDURE Validate_Terms_Code(
65 pi_table_name in varchar2,
66 pi_key_name in varchar2,
67 pi_key_value in varchar2,
68 pi_field_name in varchar2,
69 pi_field_value in out NOCOPY varchar2) ;
70
71 PROCEDURE Validate_Shipper_Code(
72 pi_table_name in varchar2,
73 pi_key_name in varchar2,
74 pi_key_value in varchar2,
75 pi_field_name in varchar2,
76 pi_field_value in out NOCOPY varchar2) ;
77
78 PROCEDURE Validate_FOB_Code(
79 pi_table_name in varchar2,
80 pi_key_name in varchar2,
81 pi_key_value in varchar2,
82 pi_field_name in varchar2,
83 pi_field_value in out NOCOPY varchar2) ;
84
85 PROCEDURE Validate_Frtbill_Mthd(
86 pi_table_name in varchar2,
87 pi_key_name in varchar2,
88 pi_key_value in varchar2,
89 pi_field_name in varchar2,
90 pi_field_value in out NOCOPY varchar2) ;
91
92 PROCEDURE Validate_Vendgl_Class(
93 pi_table_name in varchar2,
94 pi_key_name in varchar2,
95 pi_key_value in varchar2,
96 pi_field_name in varchar2,
97 pi_field_value in varchar2) ;
98
99 PROCEDURE Validate_Slsrep_Code(
100 pi_table_name in varchar2,
101 pi_key_name in varchar2,
102 pi_key_value in varchar2,
103 pi_field_name in varchar2,
104 pi_field_value in varchar2) ;
105
106 PROCEDURE Validate_Cust_Class(
107 pi_table_name in varchar2,
108 pi_key_name in varchar2,
109 pi_key_value in varchar2,
110 pi_field_name in varchar2,
111 pi_field_value in varchar2) ;
112
113 PROCEDURE Validate_Custprice_Class(
114 pi_table_name in varchar2,
115 pi_key_name in varchar2,
116 pi_key_value in varchar2,
117 pi_field_name in varchar2,
118 pi_field_value in varchar2) ;
119
120 PROCEDURE Validate_Custgl_class(
121 pi_table_name in varchar2,
122 pi_key_name in varchar2,
123 pi_key_value in varchar2,
124 pi_field_name in varchar2,
125 pi_field_value in varchar2) ;
126
127 PROCEDURE Validate_Taxloc_Code(
128 pi_table_name in varchar2,
129 pi_key_name in varchar2,
130 pi_key_value in varchar2,
131 pi_field_name in varchar2,
132 pi_field_value in varchar2) ;
133
134 PROCEDURE Validate_Taxcalc_Code(
135 pi_table_name in varchar2,
136 pi_key_name in varchar2,
137 pi_key_value in varchar2,
138 pi_field_name in varchar2,
139 pi_field_value in varchar2) ;
140
141 PROCEDURE Validate_Whse_Code(
142 pi_table_name in varchar2,
143 pi_key_name in varchar2,
144 pi_key_value in varchar2,
145 pi_field_name in varchar2,
146 pi_field_value in varchar2) ;
147
148 PROCEDURE Save_Addr(
149 pi_addr_id in out NOCOPY number,
150 pi_addr1 in varchar2,
151 pi_addr2 in varchar2,
152 pi_addr3 in varchar2,
153 pi_addr4 in varchar2,
154 pi_ora_addr4 in varchar2,
155 pi_province in varchar2,
156 pi_county in varchar2,
157 pi_state_code in varchar2,
158 pi_country_code in varchar2,
159 pi_postal_code in varchar2,
160 pi_pseudo_key in varchar2,
161 pi_date_modified in date,
162 pi_modified_by in varchar2,
163 pi_date_added in varchar2,
164 pi_added_by in varchar2);
165
166 FUNCTION Validate_Terms_Code(pi_field_value in varchar2) return boolean;
167 FUNCTION Validate_Shipper_Code(pi_field_value in varchar2) return boolean;
168 FUNCTION Validate_FOB_Code(pi_field_value in varchar2) return boolean;
169 FUNCTION Validate_Slsrep_Code(pi_field_value in varchar2) return boolean;
170
171 END; -- Gmf_Glsynch package