DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_HDLR dependencies on OE_HEADER_CL_DEP_ATTR

Line 83: OE_HEADER_CL_DEP_ATTR.SOLD_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

79: l_attr:=l_attr||' 4';
80: -- Validate defaulted value if not null
81: IF OE_VALIDATE.SOLD_TO_ORG(g_record.SOLD_TO_ORG_ID) THEN
82: -- if valid, clear dependent attributes
83: OE_HEADER_CL_DEP_ATTR.SOLD_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
84: ELSE
85: g_record.SOLD_TO_ORG_ID := NULL;
86: l_attr:=l_attr||' 6';
87: END IF;

Line 113: OE_HEADER_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);

109: l_attr:=l_attr||' 4';
110: -- Validate defaulted value if not null
111: IF OE_VALIDATE.SHIP_TO_ORG(g_record.SHIP_TO_ORG_ID) THEN
112: -- if valid, clear dependent attributes
113: OE_HEADER_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
114: ELSE
115: g_record.SHIP_TO_ORG_ID := NULL;
116: l_attr:=l_attr||' 6';
117: END IF;

Line 143: OE_HEADER_CL_DEP_ATTR.DELIVER_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.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN
142: -- if valid, clear dependent attributes
143: OE_HEADER_CL_DEP_ATTR.DELIVER_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
144: ELSE
145: g_record.DELIVER_TO_ORG_ID := NULL;
146: l_attr:=l_attr||' 6';
147: END IF;

Line 173: OE_HEADER_CL_DEP_ATTR.AGREEMENT(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.AGREEMENT(g_record.AGREEMENT_ID) THEN
172: -- if valid, clear dependent attributes
173: OE_HEADER_CL_DEP_ATTR.AGREEMENT(p_initial_rec, p_in_old_rec, g_record);
174: ELSE
175: g_record.AGREEMENT_ID := NULL;
176: l_attr:=l_attr||' 6';
177: END IF;

Line 203: OE_HEADER_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_HEADER_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 237: OE_HEADER_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);

233: l_attr:=l_attr||' 4';
234: -- Validate defaulted value if not null
235: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN
236: -- if valid, clear dependent attributes
237: OE_HEADER_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);
238: ELSE
239: g_record.PRICE_LIST_ID := NULL;
240: l_attr:=l_attr||' 6';
241: END IF;

Line 273: OE_HEADER_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);

269: l_attr:=l_attr||' 4';
270: -- Validate defaulted value if not null
271: IF OE_VALIDATE.REQUEST_DATE(g_record.REQUEST_DATE) THEN
272: -- if valid, clear dependent attributes
273: OE_HEADER_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);
274: ELSE
275: g_record.REQUEST_DATE := NULL;
276: l_attr:=l_attr||' 6';
277: END IF;

Line 344: OE_HEADER_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(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.ACCOUNTING_RULE_DURATION(g_record.ACCOUNTING_RULE_DURATION) THEN
343: -- if valid, clear dependent attributes
344: OE_HEADER_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(p_initial_rec, p_in_old_rec, g_record);
345: ELSE
346: g_record.ACCOUNTING_RULE_DURATION := NULL;
347: l_attr:=l_attr||' 6';
348: END IF;

Line 494: OE_HEADER_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

490: l_attr:=l_attr||' 4';
491: -- Validate defaulted value if not null
492: IF OE_VALIDATE.INVOICE_TO_CONTACT(g_record.INVOICE_TO_CONTACT_ID) THEN
493: -- if valid, clear dependent attributes
494: OE_HEADER_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
495: ELSE
496: g_record.INVOICE_TO_CONTACT_ID := NULL;
497: l_attr:=l_attr||' 6';
498: END IF;

Line 560: OE_HEADER_CL_DEP_ATTR.SOLD_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

556: l_attr:=l_attr||' 4';
557: -- Validate defaulted value if not null
558: IF OE_VALIDATE.SOLD_TO_CONTACT(g_record.SOLD_TO_CONTACT_ID) THEN
559: -- if valid, clear dependent attributes
560: OE_HEADER_CL_DEP_ATTR.SOLD_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
561: ELSE
562: g_record.SOLD_TO_CONTACT_ID := NULL;
563: l_attr:=l_attr||' 6';
564: END IF;

Line 743: OE_HEADER_CL_DEP_ATTR.IB_CURRENT_LOCATION(p_initial_rec, p_in_old_rec, g_record);

739: END IF;
740: IF g_record.IB_CURRENT_LOCATION IS NOT NULL THEN
741: l_attr:=l_attr||' 4';
742: -- if valid, clear dependent attributes
743: OE_HEADER_CL_DEP_ATTR.IB_CURRENT_LOCATION(p_initial_rec, p_in_old_rec, g_record);
744: END IF;
745: END IF;
746: l_attr:= 'SOLD_TO_SITE_USE_ID';
747:

Line 854: OE_HEADER_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

850: l_attr:=l_attr||' 4';
851: -- Validate defaulted value if not null
852: IF OE_VALIDATE.DELIVER_TO_CONTACT(g_record.DELIVER_TO_CONTACT_ID) THEN
853: -- if valid, clear dependent attributes
854: OE_HEADER_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
855: ELSE
856: g_record.DELIVER_TO_CONTACT_ID := NULL;
857: l_attr:=l_attr||' 6';
858: END IF;

Line 940: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER(p_initial_rec, p_in_old_rec, g_record);

936: END IF;
937: IF g_record.END_CUSTOMER_ID IS NOT NULL THEN
938: l_attr:=l_attr||' 4';
939: -- if valid, clear dependent attributes
940: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER(p_initial_rec, p_in_old_rec, g_record);
941: END IF;
942: END IF;
943: l_attr:= 'END_CUSTOMER_CONTACT_ID';
944:

Line 964: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER_CONTACT(p_initial_rec, p_in_old_rec, g_record);

960: END IF;
961: IF g_record.END_CUSTOMER_CONTACT_ID IS NOT NULL THEN
962: l_attr:=l_attr||' 4';
963: -- if valid, clear dependent attributes
964: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER_CONTACT(p_initial_rec, p_in_old_rec, g_record);
965: END IF;
966: END IF;
967: l_attr:= 'END_CUSTOMER_SITE_USE_ID';
968:

Line 988: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER_SITE_USE(p_initial_rec, p_in_old_rec, g_record);

984: END IF;
985: IF g_record.END_CUSTOMER_SITE_USE_ID IS NOT NULL THEN
986: l_attr:=l_attr||' 4';
987: -- if valid, clear dependent attributes
988: OE_HEADER_CL_DEP_ATTR.END_CUSTOMER_SITE_USE(p_initial_rec, p_in_old_rec, g_record);
989: END IF;
990: END IF;
991: l_attr:= 'EXPIRATION_DATE';
992:

Line 1014: OE_HEADER_CL_DEP_ATTR.EXPIRATION_DATE(p_initial_rec, p_in_old_rec, g_record);

1010: l_attr:=l_attr||' 4';
1011: -- Validate defaulted value if not null
1012: IF OE_VALIDATE.EXPIRATION_DATE(g_record.EXPIRATION_DATE) THEN
1013: -- if valid, clear dependent attributes
1014: OE_HEADER_CL_DEP_ATTR.EXPIRATION_DATE(p_initial_rec, p_in_old_rec, g_record);
1015: ELSE
1016: g_record.EXPIRATION_DATE := NULL;
1017: l_attr:=l_attr||' 6';
1018: END IF;

Line 1114: OE_HEADER_CL_DEP_ATTR.DEFAULT_FULFILLMENT_SET(p_initial_rec, p_in_old_rec, g_record);

1110: l_attr:=l_attr||' 4';
1111: -- Validate defaulted value if not null
1112: IF OE_VALIDATE.DEFAULT_FULFILLMENT_SET(g_record.DEFAULT_FULFILLMENT_SET) THEN
1113: -- if valid, clear dependent attributes
1114: OE_HEADER_CL_DEP_ATTR.DEFAULT_FULFILLMENT_SET(p_initial_rec, p_in_old_rec, g_record);
1115: ELSE
1116: g_record.DEFAULT_FULFILLMENT_SET := NULL;
1117: l_attr:=l_attr||' 6';
1118: END IF;

Line 1274: OE_HEADER_CL_DEP_ATTR.IB_INSTALLED_AT_LOCATION(p_initial_rec, p_in_old_rec, g_record);

1270: END IF;
1271: IF g_record.IB_INSTALLED_AT_LOCATION IS NOT NULL THEN
1272: l_attr:=l_attr||' 4';
1273: -- if valid, clear dependent attributes
1274: OE_HEADER_CL_DEP_ATTR.IB_INSTALLED_AT_LOCATION(p_initial_rec, p_in_old_rec, g_record);
1275: END IF;
1276: END IF;
1277: l_attr:= 'INVOICING_RULE_ID';
1278:

Line 1372: OE_HEADER_CL_DEP_ATTR.CUSTOMER_PREFERENCE_SET(p_initial_rec, p_in_old_rec, g_record);

1368: l_attr:=l_attr||' 4';
1369: -- Validate defaulted value if not null
1370: IF OE_VALIDATE.CUSTOMER_PREFERENCE_SET(g_record.CUSTOMER_PREFERENCE_SET_CODE) THEN
1371: -- if valid, clear dependent attributes
1372: OE_HEADER_CL_DEP_ATTR.CUSTOMER_PREFERENCE_SET(p_initial_rec, p_in_old_rec, g_record);
1373: ELSE
1374: g_record.CUSTOMER_PREFERENCE_SET_CODE := NULL;
1375: l_attr:=l_attr||' 6';
1376: END IF;

Line 1473: OE_HEADER_CL_DEP_ATTR.ORDER_TYPE(p_initial_rec, p_in_old_rec, g_record);

1469: l_attr:=l_attr||' 4';
1470: -- Validate defaulted value if not null
1471: IF OE_VALIDATE.ORDER_TYPE(g_record.ORDER_TYPE_ID) THEN
1472: -- if valid, clear dependent attributes
1473: OE_HEADER_CL_DEP_ATTR.ORDER_TYPE(p_initial_rec, p_in_old_rec, g_record);
1474: ELSE
1475: g_record.ORDER_TYPE_ID := NULL;
1476: l_attr:=l_attr||' 6';
1477: END IF;

Line 1544: OE_HEADER_CL_DEP_ATTR.IB_OWNER(p_initial_rec, p_in_old_rec, g_record);

1540: END IF;
1541: IF g_record.IB_OWNER IS NOT NULL THEN
1542: l_attr:=l_attr||' 4';
1543: -- if valid, clear dependent attributes
1544: OE_HEADER_CL_DEP_ATTR.IB_OWNER(p_initial_rec, p_in_old_rec, g_record);
1545: END IF;
1546: END IF;
1547: l_attr:= 'PACKING_INSTRUCTIONS';
1548:

Line 1733: OE_HEADER_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);

1729: l_attr:=l_attr||' 4';
1730: -- Validate defaulted value if not null
1731: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
1732: -- if valid, clear dependent attributes
1733: OE_HEADER_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
1734: ELSE
1735: g_record.BLANKET_NUMBER := NULL;
1736: l_attr:=l_attr||' 6';
1737: END IF;

Line 1835: OE_HEADER_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);

1831: l_attr:=l_attr||' 4';
1832: -- Validate defaulted value if not null
1833: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
1834: -- if valid, clear dependent attributes
1835: OE_HEADER_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
1836: ELSE
1837: g_record.SHIP_TO_CONTACT_ID := NULL;
1838: l_attr:=l_attr||' 6';
1839: END IF;

Line 2036: OE_HEADER_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);

2032: l_attr:=l_attr||' 4';
2033: -- Validate defaulted value if not null
2034: IF OE_VALIDATE.TAX_EXEMPT(g_record.TAX_EXEMPT_FLAG) THEN
2035: -- if valid, clear dependent attributes
2036: OE_HEADER_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);
2037: ELSE
2038: g_record.TAX_EXEMPT_FLAG := NULL;
2039: l_attr:=l_attr||' 6';
2040: END IF;

Line 2138: OE_HEADER_CL_DEP_ATTR.TRANSACTION_PHASE(p_initial_rec, p_in_old_rec, g_record);

2134: l_attr:=l_attr||' 4';
2135: -- Validate defaulted value if not null
2136: IF OE_VALIDATE.TRANSACTION_PHASE(g_record.TRANSACTION_PHASE_CODE) THEN
2137: -- if valid, clear dependent attributes
2138: OE_HEADER_CL_DEP_ATTR.TRANSACTION_PHASE(p_initial_rec, p_in_old_rec, g_record);
2139: ELSE
2140: g_record.TRANSACTION_PHASE_CODE := NULL;
2141: l_attr:=l_attr||' 6';
2142: END IF;

Line 2186: OE_HEADER_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);

2182: l_attr:=l_attr||' 4';
2183: -- Validate defaulted value if not null
2184: IF OE_VALIDATE.SHIP_FROM_ORG(g_record.SHIP_FROM_ORG_ID) THEN
2185: -- if valid, clear dependent attributes
2186: OE_HEADER_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);
2187: ELSE
2188: g_record.SHIP_FROM_ORG_ID := NULL;
2189: l_attr:=l_attr||' 6';
2190: END IF;