APPS.OE_BULK_ACK_PVT dependencies on OE_BULK_CACHE

Line 24: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

20: END IF;
21:
22: IF p_site_use_code = 'SHIP_TO' THEN
23:
24: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
25: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS_ID;
26:
27: ELSIF p_site_use_code = 'BILL_TO' THEN
28:

Line 25: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS_ID;

21:
22: IF p_site_use_code = 'SHIP_TO' THEN
23:
24: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
25: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS_ID;
26:
27: ELSIF p_site_use_code = 'BILL_TO' THEN
28:
29: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 29: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

25: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS_ID;
26:
27: ELSIF p_site_use_code = 'BILL_TO' THEN
28:
29: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
30: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS_ID;
31:
32: ELSIF p_site_use_code = 'SHIP_FROM' THEN
33:

Line 30: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS_ID;

26:
27: ELSIF p_site_use_code = 'BILL_TO' THEN
28:
29: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
30: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS_ID;
31:
32: ELSIF p_site_use_code = 'SHIP_FROM' THEN
33:
34: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 34: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

30: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS_ID;
31:
32: ELSIF p_site_use_code = 'SHIP_FROM' THEN
33:
34: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
35: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS_ID;
36:
37: ELSIF p_site_use_code = 'SOLD_TO' THEN
38:

Line 35: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS_ID;

31:
32: ELSIF p_site_use_code = 'SHIP_FROM' THEN
33:
34: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
35: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS_ID;
36:
37: ELSIF p_site_use_code = 'SOLD_TO' THEN
38:
39: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 39: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

35: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS_ID;
36:
37: ELSIF p_site_use_code = 'SOLD_TO' THEN
38:
39: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
40: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS_ID;
41:
42: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
43:

Line 40: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS_ID;

36:
37: ELSIF p_site_use_code = 'SOLD_TO' THEN
38:
39: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
40: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS_ID;
41:
42: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
43:
44: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 44: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

40: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS_ID;
41:
42: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
43:
44: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
45: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS_ID;
46:
47: END IF;
48:

Line 45: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS_ID;

41:
42: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
43:
44: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
45: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS_ID;
46:
47: END IF;
48:
49: END Get_Address_ID;

Line 64: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

60: END IF;
61:
62: IF p_site_use_code = 'SHIP_TO' THEN
63:
64: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
65: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS1;
66:
67: ELSIF p_site_use_code = 'BILL_TO' THEN
68:

Line 65: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS1;

61:
62: IF p_site_use_code = 'SHIP_TO' THEN
63:
64: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
65: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS1;
66:
67: ELSIF p_site_use_code = 'BILL_TO' THEN
68:
69: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 69: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

65: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS1;
66:
67: ELSIF p_site_use_code = 'BILL_TO' THEN
68:
69: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
70: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS1;
71:
72: ELSIF p_site_use_code = 'SHIP_FROM' THEN
73:

Line 70: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS1;

66:
67: ELSIF p_site_use_code = 'BILL_TO' THEN
68:
69: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
70: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS1;
71:
72: ELSIF p_site_use_code = 'SHIP_FROM' THEN
73:
74: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 74: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

70: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS1;
71:
72: ELSIF p_site_use_code = 'SHIP_FROM' THEN
73:
74: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
75: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS1;
76:
77: ELSIF p_site_use_code = 'SOLD_TO' THEN
78:

Line 75: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS1;

71:
72: ELSIF p_site_use_code = 'SHIP_FROM' THEN
73:
74: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
75: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS1;
76:
77: ELSIF p_site_use_code = 'SOLD_TO' THEN
78:
79: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 79: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

75: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS1;
76:
77: ELSIF p_site_use_code = 'SOLD_TO' THEN
78:
79: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
80: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS1;
81:
82: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
83:

Line 80: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS1;

76:
77: ELSIF p_site_use_code = 'SOLD_TO' THEN
78:
79: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
80: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS1;
81:
82: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
83:
84: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 84: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

80: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS1;
81:
82: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
83:
84: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
85: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS1;
86:
87: END IF;
88:

Line 85: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS1;

81:
82: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
83:
84: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
85: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS1;
86:
87: END IF;
88:
89: END Get_ADDRESS1;

Line 104: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

100: END IF;
101:
102: IF p_site_use_code = 'SHIP_TO' THEN
103:
104: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
105: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS2;
106:
107: ELSIF p_site_use_code = 'BILL_TO' THEN
108:

Line 105: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS2;

101:
102: IF p_site_use_code = 'SHIP_TO' THEN
103:
104: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
105: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS2;
106:
107: ELSIF p_site_use_code = 'BILL_TO' THEN
108:
109: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 109: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

105: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS2;
106:
107: ELSIF p_site_use_code = 'BILL_TO' THEN
108:
109: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
110: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS2;
111:
112: ELSIF p_site_use_code = 'SHIP_FROM' THEN
113:

Line 110: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS2;

106:
107: ELSIF p_site_use_code = 'BILL_TO' THEN
108:
109: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
110: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS2;
111:
112: ELSIF p_site_use_code = 'SHIP_FROM' THEN
113:
114: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 114: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

110: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS2;
111:
112: ELSIF p_site_use_code = 'SHIP_FROM' THEN
113:
114: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
115: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS2;
116:
117: ELSIF p_site_use_code = 'SOLD_TO' THEN
118:

Line 115: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS2;

111:
112: ELSIF p_site_use_code = 'SHIP_FROM' THEN
113:
114: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
115: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS2;
116:
117: ELSIF p_site_use_code = 'SOLD_TO' THEN
118:
119: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 119: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

115: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS2;
116:
117: ELSIF p_site_use_code = 'SOLD_TO' THEN
118:
119: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
120: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS2;
121:
122: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
123:

Line 120: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS2;

116:
117: ELSIF p_site_use_code = 'SOLD_TO' THEN
118:
119: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
120: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS2;
121:
122: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
123:
124: l_c_index := OE_BULK_CACHE.Load_Sold_To_SITE(p_key,'N','Y');

Line 124: l_c_index := OE_BULK_CACHE.Load_Sold_To_SITE(p_key,'N','Y');

120: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS2;
121:
122: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
123:
124: l_c_index := OE_BULK_CACHE.Load_Sold_To_SITE(p_key,'N','Y');
125: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS2;
126:
127: END IF;
128:

Line 125: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS2;

121:
122: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
123:
124: l_c_index := OE_BULK_CACHE.Load_Sold_To_SITE(p_key,'N','Y');
125: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS2;
126:
127: END IF;
128:
129: END Get_ADDRESS2;

Line 144: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

140: END IF;
141:
142: IF p_site_use_code = 'SHIP_TO' THEN
143:
144: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
145: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS3;
146:
147: ELSIF p_site_use_code = 'BILL_TO' THEN
148:

Line 145: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS3;

141:
142: IF p_site_use_code = 'SHIP_TO' THEN
143:
144: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
145: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS3;
146:
147: ELSIF p_site_use_code = 'BILL_TO' THEN
148:
149: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 149: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

145: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS3;
146:
147: ELSIF p_site_use_code = 'BILL_TO' THEN
148:
149: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
150: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS3;
151:
152: ELSIF p_site_use_code = 'SHIP_FROM' THEN
153:

Line 150: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS3;

146:
147: ELSIF p_site_use_code = 'BILL_TO' THEN
148:
149: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
150: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS3;
151:
152: ELSIF p_site_use_code = 'SHIP_FROM' THEN
153:
154: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 154: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

150: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS3;
151:
152: ELSIF p_site_use_code = 'SHIP_FROM' THEN
153:
154: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
155: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS3;
156:
157: ELSIF p_site_use_code = 'SOLD_TO' THEN
158:

Line 155: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS3;

151:
152: ELSIF p_site_use_code = 'SHIP_FROM' THEN
153:
154: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
155: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS3;
156:
157: ELSIF p_site_use_code = 'SOLD_TO' THEN
158:
159: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 159: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

155: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS3;
156:
157: ELSIF p_site_use_code = 'SOLD_TO' THEN
158:
159: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
160: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS3;
161:
162: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
163:

Line 160: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS3;

156:
157: ELSIF p_site_use_code = 'SOLD_TO' THEN
158:
159: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
160: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS3;
161:
162: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
163:
164: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 164: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

160: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS3;
161:
162: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
163:
164: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
165: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS3;
166:
167: END IF;
168:

Line 165: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS3;

161:
162: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
163:
164: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
165: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS3;
166:
167: END IF;
168:
169: END Get_ADDRESS3;

Line 184: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

180: END IF;
181:
182: IF p_site_use_code = 'SHIP_TO' THEN
183:
184: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
185: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS4;
186:
187: ELSIF p_site_use_code = 'BILL_TO' THEN
188:

Line 185: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS4;

181:
182: IF p_site_use_code = 'SHIP_TO' THEN
183:
184: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
185: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS4;
186:
187: ELSIF p_site_use_code = 'BILL_TO' THEN
188:
189: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 189: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

185: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ADDRESS4;
186:
187: ELSIF p_site_use_code = 'BILL_TO' THEN
188:
189: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
190: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS4;
191:
192: ELSIF p_site_use_code = 'SHIP_FROM' THEN
193:

Line 190: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS4;

186:
187: ELSIF p_site_use_code = 'BILL_TO' THEN
188:
189: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
190: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS4;
191:
192: ELSIF p_site_use_code = 'SHIP_FROM' THEN
193:
194: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 194: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

190: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ADDRESS4;
191:
192: ELSIF p_site_use_code = 'SHIP_FROM' THEN
193:
194: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
195: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS4;
196:
197: ELSIF p_site_use_code = 'SOLD_TO' THEN
198:

Line 195: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS4;

191:
192: ELSIF p_site_use_code = 'SHIP_FROM' THEN
193:
194: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
195: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS4;
196:
197: ELSIF p_site_use_code = 'SOLD_TO' THEN
198:
199: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 199: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

195: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ADDRESS4;
196:
197: ELSIF p_site_use_code = 'SOLD_TO' THEN
198:
199: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
200: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS4;
201:
202: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
203:

Line 200: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS4;

196:
197: ELSIF p_site_use_code = 'SOLD_TO' THEN
198:
199: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
200: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS4;
201:
202: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
203:
204: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 204: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

200: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ADDRESS4;
201:
202: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
203:
204: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
205: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS4;
206:
207: END IF;
208:

Line 205: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS4;

201:
202: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
203:
204: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
205: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ADDRESS4;
206:
207: END IF;
208:
209: END Get_ADDRESS4;

Line 224: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

220: END IF;
221:
222: IF p_site_use_code = 'SHIP_TO' THEN
223:
224: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
225: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).STATE;
226:
227: ELSIF p_site_use_code = 'BILL_TO' THEN
228:

Line 225: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).STATE;

221:
222: IF p_site_use_code = 'SHIP_TO' THEN
223:
224: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
225: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).STATE;
226:
227: ELSIF p_site_use_code = 'BILL_TO' THEN
228:
229: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 229: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

225: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).STATE;
226:
227: ELSIF p_site_use_code = 'BILL_TO' THEN
228:
229: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
230: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).STATE;
231:
232: ELSIF p_site_use_code = 'SHIP_FROM' THEN
233:

Line 230: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).STATE;

226:
227: ELSIF p_site_use_code = 'BILL_TO' THEN
228:
229: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
230: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).STATE;
231:
232: ELSIF p_site_use_code = 'SHIP_FROM' THEN
233:
234: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 234: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

230: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).STATE;
231:
232: ELSIF p_site_use_code = 'SHIP_FROM' THEN
233:
234: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
235: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).STATE;
236:
237: ELSIF p_site_use_code = 'SOLD_TO' THEN
238:

Line 235: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).STATE;

231:
232: ELSIF p_site_use_code = 'SHIP_FROM' THEN
233:
234: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
235: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).STATE;
236:
237: ELSIF p_site_use_code = 'SOLD_TO' THEN
238:
239: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 239: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

235: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).STATE;
236:
237: ELSIF p_site_use_code = 'SOLD_TO' THEN
238:
239: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
240: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).STATE;
241:
242: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
243:

Line 240: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).STATE;

236:
237: ELSIF p_site_use_code = 'SOLD_TO' THEN
238:
239: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
240: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).STATE;
241:
242: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
243:
244: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 244: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

240: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).STATE;
241:
242: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
243:
244: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
245: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).STATE;
246:
247: END IF;
248:

Line 245: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).STATE;

241:
242: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
243:
244: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
245: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).STATE;
246:
247: END IF;
248:
249: END Get_STATE;

Line 264: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

260: END IF;
261:
262: IF p_site_use_code = 'SHIP_TO' THEN
263:
264: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
265: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).CITY;
266:
267: ELSIF p_site_use_code = 'BILL_TO' THEN
268:

Line 265: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).CITY;

261:
262: IF p_site_use_code = 'SHIP_TO' THEN
263:
264: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
265: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).CITY;
266:
267: ELSIF p_site_use_code = 'BILL_TO' THEN
268:
269: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 269: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

265: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).CITY;
266:
267: ELSIF p_site_use_code = 'BILL_TO' THEN
268:
269: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
270: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).CITY;
271:
272: ELSIF p_site_use_code = 'SHIP_FROM' THEN
273:

Line 270: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).CITY;

266:
267: ELSIF p_site_use_code = 'BILL_TO' THEN
268:
269: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
270: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).CITY;
271:
272: ELSIF p_site_use_code = 'SHIP_FROM' THEN
273:
274: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 274: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

270: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).CITY;
271:
272: ELSIF p_site_use_code = 'SHIP_FROM' THEN
273:
274: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
275: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).CITY;
276:
277: ELSIF p_site_use_code = 'SOLD_TO' THEN
278:

Line 275: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).CITY;

271:
272: ELSIF p_site_use_code = 'SHIP_FROM' THEN
273:
274: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
275: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).CITY;
276:
277: ELSIF p_site_use_code = 'SOLD_TO' THEN
278:
279: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 279: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

275: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).CITY;
276:
277: ELSIF p_site_use_code = 'SOLD_TO' THEN
278:
279: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
280: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).CITY;
281:
282: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
283:

Line 280: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).CITY;

276:
277: ELSIF p_site_use_code = 'SOLD_TO' THEN
278:
279: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
280: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).CITY;
281:
282: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
283:
284: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 284: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

280: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).CITY;
281:
282: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
283:
284: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
285: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).CITY;
286:
287: END IF;
288:

Line 285: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).CITY;

281:
282: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
283:
284: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
285: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).CITY;
286:
287: END IF;
288:
289: END Get_CITY;

Line 304: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

300: END IF;
301:
302: IF p_site_use_code = 'SHIP_TO' THEN
303:
304: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
305: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ZIP;
306:
307: ELSIF p_site_use_code = 'BILL_TO' THEN
308:

Line 305: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ZIP;

301:
302: IF p_site_use_code = 'SHIP_TO' THEN
303:
304: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
305: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ZIP;
306:
307: ELSIF p_site_use_code = 'BILL_TO' THEN
308:
309: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 309: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

305: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ZIP;
306:
307: ELSIF p_site_use_code = 'BILL_TO' THEN
308:
309: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
310: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ZIP;
311:
312: ELSIF p_site_use_code = 'SHIP_FROM' THEN
313:

Line 310: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ZIP;

306:
307: ELSIF p_site_use_code = 'BILL_TO' THEN
308:
309: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
310: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ZIP;
311:
312: ELSIF p_site_use_code = 'SHIP_FROM' THEN
313:
314: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 314: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

310: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).ZIP;
311:
312: ELSIF p_site_use_code = 'SHIP_FROM' THEN
313:
314: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
315: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ZIP;
316:
317: ELSIF p_site_use_code = 'SOLD_TO' THEN
318:

Line 315: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ZIP;

311:
312: ELSIF p_site_use_code = 'SHIP_FROM' THEN
313:
314: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
315: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ZIP;
316:
317: ELSIF p_site_use_code = 'SOLD_TO' THEN
318:
319: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 319: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

315: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).ZIP;
316:
317: ELSIF p_site_use_code = 'SOLD_TO' THEN
318:
319: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
320: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ZIP;
321:
322: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
323:

Line 320: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ZIP;

316:
317: ELSIF p_site_use_code = 'SOLD_TO' THEN
318:
319: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
320: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ZIP;
321:
322: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
323:
324: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 324: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

320: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).ZIP;
321:
322: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
323:
324: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
325: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ZIP;
326:
327: END IF;
328:

Line 325: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ZIP;

321:
322: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
323:
324: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
325: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).ZIP;
326:
327: END IF;
328:
329: END Get_ZIP;

Line 344: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

340: END IF;
341:
342: IF p_site_use_code = 'SHIP_TO' THEN
343:
344: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
345: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTRY;
346:
347: ELSIF p_site_use_code = 'BILL_TO' THEN
348:

Line 345: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTRY;

341:
342: IF p_site_use_code = 'SHIP_TO' THEN
343:
344: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
345: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTRY;
346:
347: ELSIF p_site_use_code = 'BILL_TO' THEN
348:
349: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 349: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

345: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTRY;
346:
347: ELSIF p_site_use_code = 'BILL_TO' THEN
348:
349: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
350: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTRY;
351:
352: ELSIF p_site_use_code = 'SHIP_FROM' THEN
353:

Line 350: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTRY;

346:
347: ELSIF p_site_use_code = 'BILL_TO' THEN
348:
349: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
350: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTRY;
351:
352: ELSIF p_site_use_code = 'SHIP_FROM' THEN
353:
354: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 354: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

350: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTRY;
351:
352: ELSIF p_site_use_code = 'SHIP_FROM' THEN
353:
354: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
355: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTRY;
356:
357: ELSIF p_site_use_code = 'SOLD_TO' THEN
358:

Line 355: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTRY;

351:
352: ELSIF p_site_use_code = 'SHIP_FROM' THEN
353:
354: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
355: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTRY;
356:
357: ELSIF p_site_use_code = 'SOLD_TO' THEN
358:
359: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 359: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

355: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTRY;
356:
357: ELSIF p_site_use_code = 'SOLD_TO' THEN
358:
359: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
360: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTRY;
361:
362: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
363:

Line 360: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTRY;

356:
357: ELSIF p_site_use_code = 'SOLD_TO' THEN
358:
359: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
360: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTRY;
361:
362: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
363:
364: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 364: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

360: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTRY;
361:
362: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
363:
364: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
365: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTRY;
366:
367: END IF;
368:

Line 365: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTRY;

361:
362: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
363:
364: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
365: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTRY;
366:
367: END IF;
368:
369: END Get_COUNTRY;

Line 384: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

380: END IF;
381:
382: IF p_site_use_code = 'SHIP_TO' THEN
383:
384: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
385: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTY;
386:
387: ELSIF p_site_use_code = 'BILL_TO' THEN
388:

Line 385: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTY;

381:
382: IF p_site_use_code = 'SHIP_TO' THEN
383:
384: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
385: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTY;
386:
387: ELSIF p_site_use_code = 'BILL_TO' THEN
388:
389: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 389: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

385: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).COUNTY;
386:
387: ELSIF p_site_use_code = 'BILL_TO' THEN
388:
389: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
390: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTY;
391:
392: ELSIF p_site_use_code = 'SHIP_FROM' THEN
393:

Line 390: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTY;

386:
387: ELSIF p_site_use_code = 'BILL_TO' THEN
388:
389: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
390: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTY;
391:
392: ELSIF p_site_use_code = 'SHIP_FROM' THEN
393:
394: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 394: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

390: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).COUNTY;
391:
392: ELSIF p_site_use_code = 'SHIP_FROM' THEN
393:
394: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
395: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTY;
396:
397: ELSIF p_site_use_code = 'SOLD_TO' THEN
398:

Line 395: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTY;

391:
392: ELSIF p_site_use_code = 'SHIP_FROM' THEN
393:
394: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
395: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTY;
396:
397: ELSIF p_site_use_code = 'SOLD_TO' THEN
398:
399: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 399: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

395: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).COUNTY;
396:
397: ELSIF p_site_use_code = 'SOLD_TO' THEN
398:
399: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
400: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTY;
401:
402: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
403:

Line 400: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTY;

396:
397: ELSIF p_site_use_code = 'SOLD_TO' THEN
398:
399: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
400: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTY;
401:
402: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
403:
404: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 404: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

400: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).COUNTY;
401:
402: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
403:
404: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
405: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTY;
406:
407: END IF;
408:

Line 405: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTY;

401:
402: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
403:
404: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
405: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).COUNTY;
406:
407: END IF;
408:
409: END Get_COUNTY;

Line 424: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

420: END IF;
421:
422: IF p_site_use_code = 'SHIP_TO' THEN
423:
424: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
425: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).PROVINCE;
426:
427: ELSIF p_site_use_code = 'BILL_TO' THEN
428:

Line 425: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).PROVINCE;

421:
422: IF p_site_use_code = 'SHIP_TO' THEN
423:
424: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
425: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).PROVINCE;
426:
427: ELSIF p_site_use_code = 'BILL_TO' THEN
428:
429: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 429: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

425: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).PROVINCE;
426:
427: ELSIF p_site_use_code = 'BILL_TO' THEN
428:
429: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
430: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).PROVINCE;
431:
432: ELSIF p_site_use_code = 'SHIP_FROM' THEN
433:

Line 430: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).PROVINCE;

426:
427: ELSIF p_site_use_code = 'BILL_TO' THEN
428:
429: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
430: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).PROVINCE;
431:
432: ELSIF p_site_use_code = 'SHIP_FROM' THEN
433:
434: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 434: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

430: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).PROVINCE;
431:
432: ELSIF p_site_use_code = 'SHIP_FROM' THEN
433:
434: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
435: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).PROVINCE;
436:
437: ELSIF p_site_use_code = 'SOLD_TO' THEN
438:

Line 435: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).PROVINCE;

431:
432: ELSIF p_site_use_code = 'SHIP_FROM' THEN
433:
434: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
435: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).PROVINCE;
436:
437: ELSIF p_site_use_code = 'SOLD_TO' THEN
438:
439: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 439: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

435: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).PROVINCE;
436:
437: ELSIF p_site_use_code = 'SOLD_TO' THEN
438:
439: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
440: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).PROVINCE;
441:
442: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
443:

Line 440: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).PROVINCE;

436:
437: ELSIF p_site_use_code = 'SOLD_TO' THEN
438:
439: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
440: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).PROVINCE;
441:
442: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
443:
444: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 444: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

440: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).PROVINCE;
441:
442: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
443:
444: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
445: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).PROVINCE;
446:
447: END IF;
448:

Line 445: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).PROVINCE;

441:
442: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
443:
444: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
445: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).PROVINCE;
446:
447: END IF;
448:
449: END Get_PROVINCE;

Line 464: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

460: END IF;
461:
462: IF p_site_use_code = 'SHIP_TO' THEN
463:
464: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
465: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).LOCATION;
466:
467: ELSIF p_site_use_code = 'BILL_TO' THEN
468:

Line 465: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).LOCATION;

461:
462: IF p_site_use_code = 'SHIP_TO' THEN
463:
464: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
465: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).LOCATION;
466:
467: ELSIF p_site_use_code = 'BILL_TO' THEN
468:
469: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 469: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

465: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).LOCATION;
466:
467: ELSIF p_site_use_code = 'BILL_TO' THEN
468:
469: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
470: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).LOCATION;
471:
472: ELSIF p_site_use_code = 'SHIP_FROM' THEN
473:

Line 470: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).LOCATION;

466:
467: ELSIF p_site_use_code = 'BILL_TO' THEN
468:
469: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
470: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).LOCATION;
471:
472: ELSIF p_site_use_code = 'SHIP_FROM' THEN
473:
474: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 474: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

470: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).LOCATION;
471:
472: ELSIF p_site_use_code = 'SHIP_FROM' THEN
473:
474: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
475: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).LOCATION;
476:
477: ELSIF p_site_use_code = 'SOLD_TO' THEN
478:

Line 475: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).LOCATION;

471:
472: ELSIF p_site_use_code = 'SHIP_FROM' THEN
473:
474: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
475: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).LOCATION;
476:
477: ELSIF p_site_use_code = 'SOLD_TO' THEN
478:
479: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 479: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

475: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).LOCATION;
476:
477: ELSIF p_site_use_code = 'SOLD_TO' THEN
478:
479: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
480: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).LOCATION;
481:
482: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
483:

Line 480: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).LOCATION;

476:
477: ELSIF p_site_use_code = 'SOLD_TO' THEN
478:
479: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
480: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).LOCATION;
481:
482: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
483:
484: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 484: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

480: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).LOCATION;
481:
482: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
483:
484: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
485: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).LOCATION;
486: END IF;
487:
488: END Get_LOCATION;

Line 485: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).LOCATION;

481:
482: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
483:
484: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
485: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).LOCATION;
486: END IF;
487:
488: END Get_LOCATION;
489:

Line 503: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');

499: END IF;
500:
501: IF p_site_use_code = 'SHIP_TO' THEN
502:
503: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
504: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).EDI_LOCATION_CODE;
505:
506: ELSIF p_site_use_code = 'BILL_TO' THEN
507:

Line 504: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).EDI_LOCATION_CODE;

500:
501: IF p_site_use_code = 'SHIP_TO' THEN
502:
503: l_c_index := OE_BULK_CACHE.Load_Ship_To(p_key,'N','Y');
504: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).EDI_LOCATION_CODE;
505:
506: ELSIF p_site_use_code = 'BILL_TO' THEN
507:
508: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

Line 508: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');

504: RETURN OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).EDI_LOCATION_CODE;
505:
506: ELSIF p_site_use_code = 'BILL_TO' THEN
507:
508: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
509: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).EDI_LOCATION_CODE;
510:
511: ELSIF p_site_use_code = 'SHIP_FROM' THEN
512:

Line 509: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).EDI_LOCATION_CODE;

505:
506: ELSIF p_site_use_code = 'BILL_TO' THEN
507:
508: l_c_index := OE_BULK_CACHE.Load_Invoice_To(p_key,'N','Y');
509: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).EDI_LOCATION_CODE;
510:
511: ELSIF p_site_use_code = 'SHIP_FROM' THEN
512:
513: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

Line 513: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);

509: RETURN OE_BULK_CACHE.G_INVOICE_TO_TBL(l_c_index).EDI_LOCATION_CODE;
510:
511: ELSIF p_site_use_code = 'SHIP_FROM' THEN
512:
513: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
514: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).EDI_LOCATION_CODE;
515:
516: ELSIF p_site_use_code = 'SOLD_TO' THEN
517:

Line 514: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).EDI_LOCATION_CODE;

510:
511: ELSIF p_site_use_code = 'SHIP_FROM' THEN
512:
513: l_c_index := OE_BULK_CACHE.Load_Ship_From(p_key);
514: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).EDI_LOCATION_CODE;
515:
516: ELSIF p_site_use_code = 'SOLD_TO' THEN
517:
518: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

Line 518: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');

514: RETURN OE_BULK_CACHE.G_SHIP_FROM_TBL(l_c_index).EDI_LOCATION_CODE;
515:
516: ELSIF p_site_use_code = 'SOLD_TO' THEN
517:
518: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
519: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).EDI_LOCATION_CODE;
520:
521: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
522:

Line 519: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).EDI_LOCATION_CODE;

515:
516: ELSIF p_site_use_code = 'SOLD_TO' THEN
517:
518: l_c_index := OE_BULK_CACHE.Load_Sold_To(p_key,'N','Y');
519: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).EDI_LOCATION_CODE;
520:
521: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
522:
523: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

Line 523: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');

519: RETURN OE_BULK_CACHE.G_SOLD_TO_TBL(l_c_index).EDI_LOCATION_CODE;
520:
521: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
522:
523: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
524: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).EDI_LOCATION_CODE;
525: END IF;
526:
527: END Get_EDI_LOCATION;

Line 524: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).EDI_LOCATION_CODE;

520:
521: ELSIF p_site_use_code = 'SOLD_TO_SITE' THEN
522:
523: l_c_index := OE_BULK_CACHE.Load_Sold_To_Site(p_key,'N','Y');
524: RETURN OE_BULK_CACHE.G_SOLD_TO_SITE_TBL(l_c_index).EDI_LOCATION_CODE;
525: END IF;
526:
527: END Get_EDI_LOCATION;
528: