DBA Data[Home] [Help]

APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_ID_TO_VALUE

Line 47: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

43:
44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
45: THEN
46:
47: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
49: OE_MSG_PUB.Add;
50:
51: END IF;

Line 108: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);

104: l_attribute_display_value := NULL;
105: END;
106: elsif l_attribute_code = 'SALES_CREDIT_TYPE_ID' then
107: l_attribute_display_value :=
108: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
109: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
110: l_attribute_display_value :=
111: OE_ID_TO_VALUE.accounting_rule(attribute_value);
112: elsif l_attribute_code = 'AGREEMENT_ID' then

Line 111: OE_ID_TO_VALUE.accounting_rule(attribute_value);

107: l_attribute_display_value :=
108: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
109: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
110: l_attribute_display_value :=
111: OE_ID_TO_VALUE.accounting_rule(attribute_value);
112: elsif l_attribute_code = 'AGREEMENT_ID' then
113: l_attribute_display_value :=
114: OE_ID_TO_VALUE.agreement(attribute_value);
115: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then

Line 114: OE_ID_TO_VALUE.agreement(attribute_value);

110: l_attribute_display_value :=
111: OE_ID_TO_VALUE.accounting_rule(attribute_value);
112: elsif l_attribute_code = 'AGREEMENT_ID' then
113: l_attribute_display_value :=
114: OE_ID_TO_VALUE.agreement(attribute_value);
115: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
116: l_attribute_display_value :=
117: OE_ID_TO_VALUE.conversion_type(attribute_value);
118: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then

Line 117: OE_ID_TO_VALUE.conversion_type(attribute_value);

113: l_attribute_display_value :=
114: OE_ID_TO_VALUE.agreement(attribute_value);
115: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
116: l_attribute_display_value :=
117: OE_ID_TO_VALUE.conversion_type(attribute_value);
118: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
119: l_attribute_display_value :=
120: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
121: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then

Line 120: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);

116: l_attribute_display_value :=
117: OE_ID_TO_VALUE.conversion_type(attribute_value);
118: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
119: l_attribute_display_value :=
120: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
121: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then
122: IF attribute_value is not null then
123: BEGIN
124: SELECT LOCATION

Line 134: OE_ID_TO_VALUE.fob_point(attribute_value);

130: END;
131: END IF;
132: elsif l_attribute_code = 'FOB_POINT_CODE' then
133: l_attribute_display_value :=
134: OE_ID_TO_VALUE.fob_point(attribute_value);
135: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
136: l_attribute_display_value :=
137: OE_ID_TO_VALUE.freight_terms(attribute_value);
138: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then

Line 137: OE_ID_TO_VALUE.freight_terms(attribute_value);

133: l_attribute_display_value :=
134: OE_ID_TO_VALUE.fob_point(attribute_value);
135: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
136: l_attribute_display_value :=
137: OE_ID_TO_VALUE.freight_terms(attribute_value);
138: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
139: l_attribute_display_value :=
140: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
141: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then

Line 140: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);

136: l_attribute_display_value :=
137: OE_ID_TO_VALUE.freight_terms(attribute_value);
138: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
139: l_attribute_display_value :=
140: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
141: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then
142: IF attribute_value is not null then
143: BEGIN
144: SELECT LOCATION

Line 154: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);

150: END;
151: END IF;
152: elsif l_attribute_code = 'INVOICING_RULE_ID' then
153: l_attribute_display_value :=
154: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
155: elsif l_attribute_code = 'ORDER_TYPE_ID' then
156: l_attribute_display_value :=
157: OE_ID_TO_VALUE.Order_type(attribute_value);
158: elsif l_attribute_code = 'PAYMENT_TERM_ID' then

Line 157: OE_ID_TO_VALUE.Order_type(attribute_value);

153: l_attribute_display_value :=
154: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
155: elsif l_attribute_code = 'ORDER_TYPE_ID' then
156: l_attribute_display_value :=
157: OE_ID_TO_VALUE.Order_type(attribute_value);
158: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
159: l_attribute_display_value :=
160: OE_ID_TO_VALUE.Payment_Term(attribute_value);
161: --14200639 Start

Line 160: OE_ID_TO_VALUE.Payment_Term(attribute_value);

156: l_attribute_display_value :=
157: OE_ID_TO_VALUE.Order_type(attribute_value);
158: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
159: l_attribute_display_value :=
160: OE_ID_TO_VALUE.Payment_Term(attribute_value);
161: --14200639 Start
162: elsif l_attribute_code = 'PROJECT_ID' then
163: l_attribute_display_value :=
164: OE_ID_TO_VALUE.Project(attribute_value);

Line 164: OE_ID_TO_VALUE.Project(attribute_value);

160: OE_ID_TO_VALUE.Payment_Term(attribute_value);
161: --14200639 Start
162: elsif l_attribute_code = 'PROJECT_ID' then
163: l_attribute_display_value :=
164: OE_ID_TO_VALUE.Project(attribute_value);
165: --14200639 End
166: elsif l_attribute_code = 'PRICE_LIST_ID' then
167: l_attribute_display_value :=
168: OE_ID_TO_VALUE.Price_List(attribute_value);

Line 168: OE_ID_TO_VALUE.Price_List(attribute_value);

164: OE_ID_TO_VALUE.Project(attribute_value);
165: --14200639 End
166: elsif l_attribute_code = 'PRICE_LIST_ID' then
167: l_attribute_display_value :=
168: OE_ID_TO_VALUE.Price_List(attribute_value);
169: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
170: l_attribute_display_value :=
171: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
172: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then

Line 171: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);

167: l_attribute_display_value :=
168: OE_ID_TO_VALUE.Price_List(attribute_value);
169: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
170: l_attribute_display_value :=
171: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
172: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then
173: IF attribute_value is not null then
174: BEGIN
175: SELECT name

Line 184: OE_ID_TO_VALUE.Ship_to_contact(attribute_value);

180: END;
181: END IF;
182: elsif l_attribute_code = 'SHIP_TO_CONTACT_ID' then
183: l_attribute_display_value :=
184: OE_ID_TO_VALUE.Ship_to_contact(attribute_value);
185: elsif l_attribute_code = 'SHIP_TO_ORG_ID' then
186: IF attribute_value is not null then
187: BEGIN
188: SELECT LOCATION

Line 198: OE_ID_TO_VALUE.Sold_to_contact(attribute_value);

194: END;
195: END IF;
196: elsif l_attribute_code = 'SOLD_TO_CONTACT_ID' then
197: l_attribute_display_value :=
198: OE_ID_TO_VALUE.Sold_to_contact(attribute_value);
199: elsif l_attribute_code = 'SOLD_TO_ORG_ID' then
200: IF attribute_value is not null then
201: BEGIN
202: SELECT SUBSTR(HZP.PARTY_NAME,1,50) name

Line 211: OE_ID_TO_VALUE.tax_exempt(attribute_value);

207: END;
208: END IF;
209: elsif l_attribute_code = 'TAX_EXEMPT_FLAG' then
210: l_attribute_display_value :=
211: OE_ID_TO_VALUE.tax_exempt(attribute_value);
212: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
213: l_attribute_display_value :=
214: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
215: elsif l_attribute_code = 'RETURN_REASON_CODE' then

Line 214: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);

210: l_attribute_display_value :=
211: OE_ID_TO_VALUE.tax_exempt(attribute_value);
212: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
213: l_attribute_display_value :=
214: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
215: elsif l_attribute_code = 'RETURN_REASON_CODE' then
216: l_attribute_display_value :=
217: OE_ID_TO_VALUE.Return_Reason(attribute_value);
218: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then

Line 217: OE_ID_TO_VALUE.Return_Reason(attribute_value);

213: l_attribute_display_value :=
214: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
215: elsif l_attribute_code = 'RETURN_REASON_CODE' then
216: l_attribute_display_value :=
217: OE_ID_TO_VALUE.Return_Reason(attribute_value);
218: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
219: l_attribute_display_value :=
220: OE_ID_TO_VALUE.Ship_method(attribute_value);
221: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then

Line 220: OE_ID_TO_VALUE.Ship_method(attribute_value);

216: l_attribute_display_value :=
217: OE_ID_TO_VALUE.Return_Reason(attribute_value);
218: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
219: l_attribute_display_value :=
220: OE_ID_TO_VALUE.Ship_method(attribute_value);
221: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
222: l_attribute_display_value :=
223: OE_ID_TO_VALUE.source_type(attribute_value);
224: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then

Line 223: OE_ID_TO_VALUE.source_type(attribute_value);

219: l_attribute_display_value :=
220: OE_ID_TO_VALUE.Ship_method(attribute_value);
221: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
222: l_attribute_display_value :=
223: OE_ID_TO_VALUE.source_type(attribute_value);
224: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then
225: IF attribute_value in ('Y','N','P') THEN
226: BEGIN
227: SELECT meaning

Line 238: OE_ID_TO_VALUE.over_ship_reason(attribute_value);

234: l_attribute_display_value := NULL;
235: END IF;
236: elsif l_attribute_code = 'OVER_SHIP_REASON_CODE' then
237: l_attribute_display_value :=
238: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
239: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
240: l_attribute_display_value :=
241: -- OE_ID_TO_VALUE.Inventory_Item(attribute_value); Bug 8547934
242: Inventory_Item(attribute_value,p_org_id);

Line 241: -- OE_ID_TO_VALUE.Inventory_Item(attribute_value); Bug 8547934

237: l_attribute_display_value :=
238: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
239: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
240: l_attribute_display_value :=
241: -- OE_ID_TO_VALUE.Inventory_Item(attribute_value); Bug 8547934
242: Inventory_Item(attribute_value,p_org_id);
243: elsif l_attribute_code = 'DISCOUNT_ID' then
244: if attribute_value is not null then
245: BEGIN

Line 322: l_attribute_display_value := OE_ID_TO_VALUE.Billing_Option(attribute_value);

318: END IF;
319: -- sol_ord_er #16014165 start
320: ELSIF l_attribute_code = 'SERVICE_BILL_OPTION_CODE' THEN
321: IF attribute_value IS NOT NULL THEN
322: l_attribute_display_value := OE_ID_TO_VALUE.Billing_Option(attribute_value);
323: else
324: l_attribute_display_value := null;
325: end if;
326: ELSIF l_attribute_code = 'SERVICE_BILL_PROFILE_ID' THEN

Line 328: l_attribute_display_value := OE_ID_TO_VALUE.Billing_Profile(attribute_value);

324: l_attribute_display_value := null;
325: end if;
326: ELSIF l_attribute_code = 'SERVICE_BILL_PROFILE_ID' THEN
327: IF attribute_value IS NOT NULL THEN
328: l_attribute_display_value := OE_ID_TO_VALUE.Billing_Profile(attribute_value);
329: else
330: l_attribute_display_value := null;
331: end if;
332: ELSIF l_attribute_code = 'SERVICE_COV_TEMPLATE_ID' THEN

Line 334: l_attribute_display_value := OE_ID_TO_VALUE.Coverage_Template(attribute_value);

330: l_attribute_display_value := null;
331: end if;
332: ELSIF l_attribute_code = 'SERVICE_COV_TEMPLATE_ID' THEN
333: IF attribute_value IS NOT NULL THEN
334: l_attribute_display_value := OE_ID_TO_VALUE.Coverage_Template(attribute_value);
335: else
336: l_attribute_display_value := null;
337: end if;
338: ELSIF l_attribute_code = 'SERVICE_SUBS_TEMPLATE_ID' THEN

Line 340: l_attribute_display_value := OE_ID_TO_VALUE.Subscription_Template(attribute_value);

336: l_attribute_display_value := null;
337: end if;
338: ELSIF l_attribute_code = 'SERVICE_SUBS_TEMPLATE_ID' THEN
339: IF attribute_value IS NOT NULL THEN
340: l_attribute_display_value := OE_ID_TO_VALUE.Subscription_Template(attribute_value);
341: else
342: l_attribute_display_value := null;
343: end if;
344: -- sol_ord_er #16014165 end