DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_HDLR dependencies on OE_LINE_CL_DEP_ATTR

Line 79: OE_LINE_CL_DEP_ATTR.LINE_TYPE(p_initial_rec, p_in_old_rec, g_record);

75: l_attr:=l_attr||' 4';
76: -- Validate defaulted value if not null
77: IF OE_VALIDATE.LINE_TYPE(g_record.LINE_TYPE_ID) THEN
78: -- if valid, clear dependent attributes
79: OE_LINE_CL_DEP_ATTR.LINE_TYPE(p_initial_rec, p_in_old_rec, g_record);
80: ELSE
81: g_record.LINE_TYPE_ID := NULL;
82: l_attr:=l_attr||' 6';
83: END IF;

Line 109: OE_LINE_CL_DEP_ATTR.AGREEMENT(p_initial_rec, p_in_old_rec, g_record);

105: l_attr:=l_attr||' 4';
106: -- Validate defaulted value if not null
107: IF OE_VALIDATE.AGREEMENT(g_record.AGREEMENT_ID) THEN
108: -- if valid, clear dependent attributes
109: OE_LINE_CL_DEP_ATTR.AGREEMENT(p_initial_rec, p_in_old_rec, g_record);
110: ELSE
111: g_record.AGREEMENT_ID := NULL;
112: l_attr:=l_attr||' 6';
113: END IF;

Line 143: OE_LINE_CL_DEP_ATTR.SOLD_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

139: l_attr:=l_attr||' 4';
140: -- Validate defaulted value if not null
141: IF OE_VALIDATE.SOLD_TO_ORG(g_record.SOLD_TO_ORG_ID) THEN
142: -- if valid, clear dependent attributes
143: OE_LINE_CL_DEP_ATTR.SOLD_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
144: ELSE
145: g_record.SOLD_TO_ORG_ID := NULL;
146: l_attr:=l_attr||' 6';
147: END IF;

Line 173: OE_LINE_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

169: l_attr:=l_attr||' 4';
170: -- Validate defaulted value if not null
171: IF OE_VALIDATE.SHIP_TO_ORG(g_record.SHIP_TO_ORG_ID) THEN
172: -- if valid, clear dependent attributes
173: OE_LINE_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
174: ELSE
175: g_record.SHIP_TO_ORG_ID := NULL;
176: l_attr:=l_attr||' 6';
177: END IF;

Line 203: OE_LINE_CL_DEP_ATTR.INVOICE_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

199: l_attr:=l_attr||' 4';
200: -- Validate defaulted value if not null
201: IF OE_VALIDATE.INVOICE_TO_ORG(g_record.INVOICE_TO_ORG_ID) THEN
202: -- if valid, clear dependent attributes
203: OE_LINE_CL_DEP_ATTR.INVOICE_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
204: ELSE
205: g_record.INVOICE_TO_ORG_ID := NULL;
206: l_attr:=l_attr||' 6';
207: END IF;

Line 233: OE_LINE_CL_DEP_ATTR.DELIVER_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

229: l_attr:=l_attr||' 4';
230: -- Validate defaulted value if not null
231: IF OE_VALIDATE.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN
232: -- if valid, clear dependent attributes
233: OE_LINE_CL_DEP_ATTR.DELIVER_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
234: ELSE
235: g_record.DELIVER_TO_ORG_ID := NULL;
236: l_attr:=l_attr||' 6';
237: END IF;

Line 263: OE_LINE_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);

259: l_attr:=l_attr||' 4';
260: -- Validate defaulted value if not null
261: IF OE_VALIDATE.REQUEST_DATE(g_record.REQUEST_DATE) THEN
262: -- if valid, clear dependent attributes
263: OE_LINE_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);
264: ELSE
265: g_record.REQUEST_DATE := NULL;
266: l_attr:=l_attr||' 6';
267: END IF;

Line 314: OE_LINE_CL_DEP_ATTR.PROMISE_DATE(p_initial_rec, p_in_old_rec, g_record);

310: l_attr:=l_attr||' 4';
311: -- Validate defaulted value if not null
312: IF OE_VALIDATE.PROMISE_DATE(g_record.PROMISE_DATE) THEN
313: -- if valid, clear dependent attributes
314: OE_LINE_CL_DEP_ATTR.PROMISE_DATE(p_initial_rec, p_in_old_rec, g_record);
315: ELSE
316: g_record.PROMISE_DATE := NULL;
317: l_attr:=l_attr||' 6';
318: END IF;

Line 344: OE_LINE_CL_DEP_ATTR.TAX_DATE(p_initial_rec, p_in_old_rec, g_record);

340: l_attr:=l_attr||' 4';
341: -- Validate defaulted value if not null
342: IF OE_VALIDATE.TAX_DATE(g_record.TAX_DATE) THEN
343: -- if valid, clear dependent attributes
344: OE_LINE_CL_DEP_ATTR.TAX_DATE(p_initial_rec, p_in_old_rec, g_record);
345: ELSE
346: g_record.TAX_DATE := NULL;
347: l_attr:=l_attr||' 6';
348: END IF;

Line 374: OE_LINE_CL_DEP_ATTR.TAX(p_initial_rec, p_in_old_rec, g_record);

370: l_attr:=l_attr||' 4';
371: -- Validate defaulted value if not null
372: IF OE_VALIDATE.TAX(g_record.TAX_CODE) THEN
373: -- if valid, clear dependent attributes
374: OE_LINE_CL_DEP_ATTR.TAX(p_initial_rec, p_in_old_rec, g_record);
375: ELSE
376: g_record.TAX_CODE := NULL;
377: l_attr:=l_attr||' 6';
378: END IF;

Line 404: OE_LINE_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);

400: l_attr:=l_attr||' 4';
401: -- Validate defaulted value if not null
402: IF OE_VALIDATE.TAX_EXEMPT(g_record.TAX_EXEMPT_FLAG) THEN
403: -- if valid, clear dependent attributes
404: OE_LINE_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);
405: ELSE
406: g_record.TAX_EXEMPT_FLAG := NULL;
407: l_attr:=l_attr||' 6';
408: END IF;

Line 434: OE_LINE_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);

430: l_attr:=l_attr||' 4';
431: -- Validate defaulted value if not null
432: IF OE_VALIDATE.SHIP_FROM_ORG(g_record.SHIP_FROM_ORG_ID) THEN
433: -- if valid, clear dependent attributes
434: OE_LINE_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);
435: ELSE
436: g_record.SHIP_FROM_ORG_ID := NULL;
437: l_attr:=l_attr||' 6';
438: END IF;

Line 501: OE_LINE_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(p_initial_rec, p_in_old_rec, g_record);

497: l_attr:=l_attr||' 4';
498: -- Validate defaulted value if not null
499: IF OE_VALIDATE.ACCOUNTING_RULE_DURATION(g_record.ACCOUNTING_RULE_DURATION) THEN
500: -- if valid, clear dependent attributes
501: OE_LINE_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(p_initial_rec, p_in_old_rec, g_record);
502: ELSE
503: g_record.ACCOUNTING_RULE_DURATION := NULL;
504: l_attr:=l_attr||' 6';
505: END IF;

Line 693: OE_LINE_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

689: l_attr:=l_attr||' 4';
690: -- Validate defaulted value if not null
691: IF OE_VALIDATE.INVOICE_TO_CONTACT(g_record.INVOICE_TO_CONTACT_ID) THEN
692: -- if valid, clear dependent attributes
693: OE_LINE_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
694: ELSE
695: g_record.INVOICE_TO_CONTACT_ID := NULL;
696: l_attr:=l_attr||' 6';
697: END IF;

Line 853: OE_LINE_CL_DEP_ATTR.IB_CURRENT_LOCATION(p_initial_rec, p_in_old_rec, g_record);

849: END IF;
850: IF g_record.IB_CURRENT_LOCATION IS NOT NULL THEN
851: l_attr:=l_attr||' 4';
852: -- if valid, clear dependent attributes
853: OE_LINE_CL_DEP_ATTR.IB_CURRENT_LOCATION(p_initial_rec, p_in_old_rec, g_record);
854: END IF;
855: END IF;
856: l_attr:= 'CUST_MODEL_SERIAL_NUMBER';
857:

Line 997: OE_LINE_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

993: l_attr:=l_attr||' 4';
994: -- Validate defaulted value if not null
995: IF OE_VALIDATE.DELIVER_TO_CONTACT(g_record.DELIVER_TO_CONTACT_ID) THEN
996: -- if valid, clear dependent attributes
997: OE_LINE_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
998: ELSE
999: g_record.DELIVER_TO_CONTACT_ID := NULL;
1000: l_attr:=l_attr||' 6';
1001: END IF;

Line 1130: OE_LINE_CL_DEP_ATTR.END_CUSTOMER(p_initial_rec, p_in_old_rec, g_record);

1126: END IF;
1127: IF g_record.END_CUSTOMER_ID IS NOT NULL THEN
1128: l_attr:=l_attr||' 4';
1129: -- if valid, clear dependent attributes
1130: OE_LINE_CL_DEP_ATTR.END_CUSTOMER(p_initial_rec, p_in_old_rec, g_record);
1131: END IF;
1132: END IF;
1133: l_attr:= 'END_CUSTOMER_CONTACT_ID';
1134:

Line 1154: OE_LINE_CL_DEP_ATTR.END_CUSTOMER_CONTACT(p_initial_rec, p_in_old_rec, g_record);

1150: END IF;
1151: IF g_record.END_CUSTOMER_CONTACT_ID IS NOT NULL THEN
1152: l_attr:=l_attr||' 4';
1153: -- if valid, clear dependent attributes
1154: OE_LINE_CL_DEP_ATTR.END_CUSTOMER_CONTACT(p_initial_rec, p_in_old_rec, g_record);
1155: END IF;
1156: END IF;
1157: l_attr:= 'END_CUSTOMER_SITE_USE_ID';
1158:

Line 1178: OE_LINE_CL_DEP_ATTR.END_CUSTOMER_SITE_USE(p_initial_rec, p_in_old_rec, g_record);

1174: END IF;
1175: IF g_record.END_CUSTOMER_SITE_USE_ID IS NOT NULL THEN
1176: l_attr:=l_attr||' 4';
1177: -- if valid, clear dependent attributes
1178: OE_LINE_CL_DEP_ATTR.END_CUSTOMER_SITE_USE(p_initial_rec, p_in_old_rec, g_record);
1179: END IF;
1180: END IF;
1181: l_attr:= 'END_ITEM_UNIT_NUMBER';
1182:

Line 1661: OE_LINE_CL_DEP_ATTR.IB_INSTALLED_AT_LOCATION(p_initial_rec, p_in_old_rec, g_record);

1657: END IF;
1658: IF g_record.IB_INSTALLED_AT_LOCATION IS NOT NULL THEN
1659: l_attr:=l_attr||' 4';
1660: -- if valid, clear dependent attributes
1661: OE_LINE_CL_DEP_ATTR.IB_INSTALLED_AT_LOCATION(p_initial_rec, p_in_old_rec, g_record);
1662: END IF;
1663: END IF;
1664: l_attr:= 'INTERMED_SHIP_TO_CONTACT_ID';
1665:

Line 1932: OE_LINE_CL_DEP_ATTR.ORDER_QUANTITY_UOM(p_initial_rec, p_in_old_rec, g_record);

1928: l_attr:=l_attr||' 4';
1929: -- Validate defaulted value if not null
1930: IF OE_VALIDATE.ORDER_QUANTITY_UOM(g_record.ORDER_QUANTITY_UOM) THEN
1931: -- if valid, clear dependent attributes
1932: OE_LINE_CL_DEP_ATTR.ORDER_QUANTITY_UOM(p_initial_rec, p_in_old_rec, g_record);
1933: ELSE
1934: g_record.ORDER_QUANTITY_UOM := NULL;
1935: l_attr:=l_attr||' 6';
1936: END IF;

Line 1974: OE_LINE_CL_DEP_ATTR.ORDERED_QUANTITY(p_initial_rec, p_in_old_rec, g_record);

1970: l_attr:=l_attr||' 4';
1971: -- Validate defaulted value if not null
1972: IF OE_VALIDATE.ORDERED_QUANTITY(g_record.ORDERED_QUANTITY) THEN
1973: -- if valid, clear dependent attributes
1974: OE_LINE_CL_DEP_ATTR.ORDERED_QUANTITY(p_initial_rec, p_in_old_rec, g_record);
1975: ELSE
1976: g_record.ORDERED_QUANTITY := NULL;
1977: l_attr:=l_attr||' 6';
1978: END IF;

Line 2032: OE_LINE_CL_DEP_ATTR.IB_OWNER(p_initial_rec, p_in_old_rec, g_record);

2028: END IF;
2029: IF g_record.IB_OWNER IS NOT NULL THEN
2030: l_attr:=l_attr||' 4';
2031: -- if valid, clear dependent attributes
2032: OE_LINE_CL_DEP_ATTR.IB_OWNER(p_initial_rec, p_in_old_rec, g_record);
2033: END IF;
2034: END IF;
2035: l_attr:= 'PACKING_INSTRUCTIONS';
2036:

Line 2126: OE_LINE_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);

2122: l_attr:=l_attr||' 4';
2123: -- Validate defaulted value if not null
2124: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN
2125: -- if valid, clear dependent attributes
2126: OE_LINE_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);
2127: ELSE
2128: g_record.PRICE_LIST_ID := NULL;
2129: l_attr:=l_attr||' 6';
2130: END IF;

Line 2488: OE_LINE_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);

2484: l_attr:=l_attr||' 4';
2485: -- Validate defaulted value if not null
2486: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
2487: -- if valid, clear dependent attributes
2488: OE_LINE_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
2489: ELSE
2490: g_record.BLANKET_NUMBER := NULL;
2491: l_attr:=l_attr||' 6';
2492: END IF;

Line 2846: OE_LINE_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

2842: l_attr:=l_attr||' 4';
2843: -- Validate defaulted value if not null
2844: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
2845: -- if valid, clear dependent attributes
2846: OE_LINE_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
2847: ELSE
2848: g_record.SHIP_TO_CONTACT_ID := NULL;
2849: l_attr:=l_attr||' 6';
2850: END IF;