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 1683: OE_LINE_CL_DEP_ATTR.INTERMED_SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

1679: l_attr:=l_attr||' 4';
1680: -- Validate defaulted value if not null
1681: IF OE_VALIDATE.INTERMED_SHIP_TO_ORG(g_record.INTERMED_SHIP_TO_ORG_ID) THEN
1682: -- if valid, clear dependent attributes
1683: OE_LINE_CL_DEP_ATTR.INTERMED_SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
1684: ELSE
1685: g_record.INTERMED_SHIP_TO_ORG_ID := NULL;
1686: l_attr:=l_attr||' 6';
1687: END IF;

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

1942: l_attr:=l_attr||' 4';
1943: -- Validate defaulted value if not null
1944: IF OE_VALIDATE.ORDER_QUANTITY_UOM(g_record.ORDER_QUANTITY_UOM) THEN
1945: -- if valid, clear dependent attributes
1946: OE_LINE_CL_DEP_ATTR.ORDER_QUANTITY_UOM(p_initial_rec, p_in_old_rec, g_record);
1947: ELSE
1948: g_record.ORDER_QUANTITY_UOM := NULL;
1949: l_attr:=l_attr||' 6';
1950: END IF;

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

1984: l_attr:=l_attr||' 4';
1985: -- Validate defaulted value if not null
1986: IF OE_VALIDATE.ORDERED_QUANTITY(g_record.ORDERED_QUANTITY) THEN
1987: -- if valid, clear dependent attributes
1988: OE_LINE_CL_DEP_ATTR.ORDERED_QUANTITY(p_initial_rec, p_in_old_rec, g_record);
1989: ELSE
1990: g_record.ORDERED_QUANTITY := NULL;
1991: l_attr:=l_attr||' 6';
1992: END IF;

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

2042: END IF;
2043: IF g_record.IB_OWNER IS NOT NULL THEN
2044: l_attr:=l_attr||' 4';
2045: -- if valid, clear dependent attributes
2046: OE_LINE_CL_DEP_ATTR.IB_OWNER(p_initial_rec, p_in_old_rec, g_record);
2047: END IF;
2048: END IF;
2049: l_attr:= 'PACKING_INSTRUCTIONS';
2050:

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

2136: l_attr:=l_attr||' 4';
2137: -- Validate defaulted value if not null
2138: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN
2139: -- if valid, clear dependent attributes
2140: OE_LINE_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);
2141: ELSE
2142: g_record.PRICE_LIST_ID := NULL;
2143: l_attr:=l_attr||' 6';
2144: END IF;

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

2498: l_attr:=l_attr||' 4';
2499: -- Validate defaulted value if not null
2500: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
2501: -- if valid, clear dependent attributes
2502: OE_LINE_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
2503: ELSE
2504: g_record.BLANKET_NUMBER := NULL;
2505: l_attr:=l_attr||' 6';
2506: END IF;

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

2940: l_attr:=l_attr||' 4';
2941: -- Validate defaulted value if not null
2942: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
2943: -- if valid, clear dependent attributes
2944: OE_LINE_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
2945: ELSE
2946: g_record.SHIP_TO_CONTACT_ID := NULL;
2947: l_attr:=l_attr||' 6';
2948: END IF;