DBA Data[Home] [Help]

APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_ID_TO_VALUE

Line 41: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);

37: l_attribute_display_value := NULL;
38: END;
39: elsif l_attribute_code = 'SALES_CREDIT_TYPE_ID' then
40: l_attribute_display_value :=
41: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
42: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then

Line 44: OE_ID_TO_VALUE.accounting_rule(attribute_value);

40: l_attribute_display_value :=
41: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
42: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then
46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then

Line 47: OE_ID_TO_VALUE.agreement(attribute_value);

43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then
46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then

Line 50: OE_ID_TO_VALUE.conversion_type(attribute_value);

46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
52: l_attribute_display_value :=
53: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
54: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then

Line 53: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);

49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
52: l_attribute_display_value :=
53: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
54: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then
55: IF attribute_value is not null then
56: BEGIN
57: SELECT LOCATION

Line 67: OE_ID_TO_VALUE.fob_point(attribute_value);

63: END;
64: END IF;
65: elsif l_attribute_code = 'FOB_POINT_CODE' then
66: l_attribute_display_value :=
67: OE_ID_TO_VALUE.fob_point(attribute_value);
68: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then

Line 70: OE_ID_TO_VALUE.freight_terms(attribute_value);

66: l_attribute_display_value :=
67: OE_ID_TO_VALUE.fob_point(attribute_value);
68: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
72: l_attribute_display_value :=
73: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
74: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then

Line 73: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);

69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
72: l_attribute_display_value :=
73: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
74: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then
75: IF attribute_value is not null then
76: BEGIN
77: SELECT LOCATION

Line 87: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);

83: END;
84: END IF;
85: elsif l_attribute_code = 'INVOICING_RULE_ID' then
86: l_attribute_display_value :=
87: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
88: elsif l_attribute_code = 'ORDER_TYPE_ID' then
89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then

Line 90: OE_ID_TO_VALUE.Order_type(attribute_value);

86: l_attribute_display_value :=
87: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
88: elsif l_attribute_code = 'ORDER_TYPE_ID' then
89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then

Line 93: OE_ID_TO_VALUE.Payment_Term(attribute_value);

89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then
95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then

Line 96: OE_ID_TO_VALUE.Price_List(attribute_value);

92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then
95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
98: l_attribute_display_value :=
99: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
100: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then

Line 99: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);

95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
98: l_attribute_display_value :=
99: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
100: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then
101: IF attribute_value is not null then
102: BEGIN
103: SELECT name

Line 112: OE_ID_TO_VALUE.Ship_to_contact(attribute_value);

108: END;
109: END IF;
110: elsif l_attribute_code = 'SHIP_TO_CONTACT_ID' then
111: l_attribute_display_value :=
112: OE_ID_TO_VALUE.Ship_to_contact(attribute_value);
113: elsif l_attribute_code = 'SHIP_TO_ORG_ID' then
114: IF attribute_value is not null then
115: BEGIN
116: SELECT LOCATION

Line 126: OE_ID_TO_VALUE.Sold_to_contact(attribute_value);

122: END;
123: END IF;
124: elsif l_attribute_code = 'SOLD_TO_CONTACT_ID' then
125: l_attribute_display_value :=
126: OE_ID_TO_VALUE.Sold_to_contact(attribute_value);
127: elsif l_attribute_code = 'SOLD_TO_ORG_ID' then
128: IF attribute_value is not null then
129: BEGIN
130: SELECT SUBSTR(HZP.PARTY_NAME,1,50) name

Line 139: OE_ID_TO_VALUE.tax_exempt(attribute_value);

135: END;
136: END IF;
137: elsif l_attribute_code = 'TAX_EXEMPT_FLAG' then
138: l_attribute_display_value :=
139: OE_ID_TO_VALUE.tax_exempt(attribute_value);
140: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then

Line 142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);

138: l_attribute_display_value :=
139: OE_ID_TO_VALUE.tax_exempt(attribute_value);
140: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then
144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then

Line 145: OE_ID_TO_VALUE.Return_Reason(attribute_value);

141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then
144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then

Line 148: OE_ID_TO_VALUE.Ship_method(attribute_value);

144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
150: l_attribute_display_value :=
151: OE_ID_TO_VALUE.source_type(attribute_value);
152: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then

Line 151: OE_ID_TO_VALUE.source_type(attribute_value);

147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
150: l_attribute_display_value :=
151: OE_ID_TO_VALUE.source_type(attribute_value);
152: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then
153: IF attribute_value in ('Y','N','P') THEN
154: BEGIN
155: SELECT meaning

Line 166: OE_ID_TO_VALUE.over_ship_reason(attribute_value);

162: l_attribute_display_value := NULL;
163: END IF;
164: elsif l_attribute_code = 'OVER_SHIP_REASON_CODE' then
165: l_attribute_display_value :=
166: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
167: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
168: l_attribute_display_value :=
169: OE_ID_TO_VALUE.Inventory_Item(attribute_value);
170: elsif l_attribute_code = 'DISCOUNT_ID' then

Line 169: OE_ID_TO_VALUE.Inventory_Item(attribute_value);

165: l_attribute_display_value :=
166: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
167: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
168: l_attribute_display_value :=
169: OE_ID_TO_VALUE.Inventory_Item(attribute_value);
170: elsif l_attribute_code = 'DISCOUNT_ID' then
171: if attribute_value is not null then
172: BEGIN
173: SELECT name