[Home] [Help]
11: FROM oe_order_sources
12: WHERE aia_enabled_flag = 'Y';
13: BEGIN
14: -- Bug 8647864
15: IF Nvl(p_source_id, Fnd_Api.G_Miss_Num) = Fnd_Api.G_Miss_Num
16: THEN
17: RETURN FALSE;
18: END IF;
19:
1953:
1954: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
1955:
1956: IF p_x_header_rec.accounting_rule_id IS NULL THEN
1957: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
1958: END IF;
1959:
1960: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
1961: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
1957: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
1958: END IF;
1959:
1960: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
1961: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
1962: END IF;
1963:
1964: IF p_x_header_rec.agreement_id IS NULL THEN
1965: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
1961: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
1962: END IF;
1963:
1964: IF p_x_header_rec.agreement_id IS NULL THEN
1965: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
1966: END IF;
1967:
1968: IF p_x_header_rec.blanket_number IS NULL THEN
1969: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
1965: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
1966: END IF;
1967:
1968: IF p_x_header_rec.blanket_number IS NULL THEN
1969: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
1970: END IF;
1971:
1972: IF p_x_header_rec.booked_flag IS NULL THEN
1973: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR ;
1969: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
1970: END IF;
1971:
1972: IF p_x_header_rec.booked_flag IS NULL THEN
1973: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR ;
1974: END IF;
1975:
1976: IF p_x_header_rec.upgraded_flag IS NULL THEN
1977: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
1973: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR ;
1974: END IF;
1975:
1976: IF p_x_header_rec.upgraded_flag IS NULL THEN
1977: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
1978: END IF;
1979:
1980: IF p_x_header_rec.booked_date IS NULL THEN
1981: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
1977: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
1978: END IF;
1979:
1980: IF p_x_header_rec.booked_date IS NULL THEN
1981: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
1982: END IF;
1983:
1984: IF p_x_header_rec.cancelled_flag IS NULL THEN
1985: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1981: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
1982: END IF;
1983:
1984: IF p_x_header_rec.cancelled_flag IS NULL THEN
1985: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1986: END IF;
1987:
1988: IF p_x_header_rec.attribute1 IS NULL THEN
1989: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1985: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1986: END IF;
1987:
1988: IF p_x_header_rec.attribute1 IS NULL THEN
1989: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1990: END IF;
1991:
1992: IF p_x_header_rec.attribute10 IS NULL THEN
1993: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1989: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1990: END IF;
1991:
1992: IF p_x_header_rec.attribute10 IS NULL THEN
1993: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1994: END IF;
1995:
1996: IF p_x_header_rec.attribute11 IS NULL THEN
1997: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1993: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1994: END IF;
1995:
1996: IF p_x_header_rec.attribute11 IS NULL THEN
1997: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1998: END IF;
1999:
2000: IF p_x_header_rec.attribute12 IS NULL THEN
2001: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1997: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1998: END IF;
1999:
2000: IF p_x_header_rec.attribute12 IS NULL THEN
2001: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
2002: END IF;
2003:
2004: IF p_x_header_rec.attribute13 IS NULL THEN
2005: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
2001: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
2002: END IF;
2003:
2004: IF p_x_header_rec.attribute13 IS NULL THEN
2005: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
2006: END IF;
2007:
2008: IF p_x_header_rec.attribute14 IS NULL THEN
2009: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
2005: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
2006: END IF;
2007:
2008: IF p_x_header_rec.attribute14 IS NULL THEN
2009: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
2010: END IF;
2011:
2012: IF p_x_header_rec.attribute15 IS NULL THEN
2013: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
2009: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
2010: END IF;
2011:
2012: IF p_x_header_rec.attribute15 IS NULL THEN
2013: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
2014: END IF;
2015:
2016: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
2017: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
2013: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
2014: END IF;
2015:
2016: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
2017: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
2018: END IF;
2019:
2020: IF p_x_header_rec.attribute17 IS NULL THEN
2021: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
2017: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
2018: END IF;
2019:
2020: IF p_x_header_rec.attribute17 IS NULL THEN
2021: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
2022: END IF;
2023:
2024: IF p_x_header_rec.attribute18 IS NULL THEN
2025: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
2021: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
2022: END IF;
2023:
2024: IF p_x_header_rec.attribute18 IS NULL THEN
2025: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
2026: END IF;
2027:
2028: IF p_x_header_rec.attribute19 IS NULL THEN
2029: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
2025: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
2026: END IF;
2027:
2028: IF p_x_header_rec.attribute19 IS NULL THEN
2029: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
2030: END IF;
2031:
2032: IF p_x_header_rec.attribute2 IS NULL THEN
2033: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
2029: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
2030: END IF;
2031:
2032: IF p_x_header_rec.attribute2 IS NULL THEN
2033: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
2034: END IF;
2035:
2036: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
2037: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
2033: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
2034: END IF;
2035:
2036: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
2037: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
2038: END IF;
2039:
2040: IF p_x_header_rec.attribute3 IS NULL THEN
2041: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
2037: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
2038: END IF;
2039:
2040: IF p_x_header_rec.attribute3 IS NULL THEN
2041: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
2042: END IF;
2043:
2044: IF p_x_header_rec.attribute4 IS NULL THEN
2045: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
2041: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
2042: END IF;
2043:
2044: IF p_x_header_rec.attribute4 IS NULL THEN
2045: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
2046: END IF;
2047:
2048: IF p_x_header_rec.attribute5 IS NULL THEN
2049: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
2045: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
2046: END IF;
2047:
2048: IF p_x_header_rec.attribute5 IS NULL THEN
2049: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
2050: END IF;
2051:
2052: IF p_x_header_rec.attribute6 IS NULL THEN
2053: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
2049: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
2050: END IF;
2051:
2052: IF p_x_header_rec.attribute6 IS NULL THEN
2053: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
2054: END IF;
2055:
2056: IF p_x_header_rec.attribute7 IS NULL THEN
2057: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
2053: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
2054: END IF;
2055:
2056: IF p_x_header_rec.attribute7 IS NULL THEN
2057: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
2058: END IF;
2059:
2060: IF p_x_header_rec.attribute8 IS NULL THEN
2061: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
2057: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
2058: END IF;
2059:
2060: IF p_x_header_rec.attribute8 IS NULL THEN
2061: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
2062: END IF;
2063:
2064: IF p_x_header_rec.attribute9 IS NULL THEN
2065: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
2061: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
2062: END IF;
2063:
2064: IF p_x_header_rec.attribute9 IS NULL THEN
2065: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
2066: END IF;
2067:
2068: IF p_x_header_rec.context IS NULL THEN
2069: p_x_header_rec.context := FND_API.G_MISS_CHAR;
2065: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
2066: END IF;
2067:
2068: IF p_x_header_rec.context IS NULL THEN
2069: p_x_header_rec.context := FND_API.G_MISS_CHAR;
2070: END IF;
2071:
2072: IF p_x_header_rec.conversion_rate IS NULL THEN
2073: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
2069: p_x_header_rec.context := FND_API.G_MISS_CHAR;
2070: END IF;
2071:
2072: IF p_x_header_rec.conversion_rate IS NULL THEN
2073: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
2074: END IF;
2075:
2076: IF p_x_header_rec.conversion_rate_date IS NULL THEN
2077: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
2073: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
2074: END IF;
2075:
2076: IF p_x_header_rec.conversion_rate_date IS NULL THEN
2077: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
2078: END IF;
2079:
2080: IF p_x_header_rec.conversion_type_code IS NULL THEN
2081: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2077: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
2078: END IF;
2079:
2080: IF p_x_header_rec.conversion_type_code IS NULL THEN
2081: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2082: END IF;
2083:
2084: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
2085: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
2081: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2082: END IF;
2083:
2084: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
2085: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
2086: END IF;
2087:
2088: IF p_x_header_rec.created_by IS NULL THEN
2089: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
2085: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
2086: END IF;
2087:
2088: IF p_x_header_rec.created_by IS NULL THEN
2089: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
2090: END IF;
2091:
2092: IF p_x_header_rec.creation_date IS NULL THEN
2093: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
2089: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
2090: END IF;
2091:
2092: IF p_x_header_rec.creation_date IS NULL THEN
2093: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
2094: END IF;
2095:
2096: IF p_x_header_rec.cust_po_number IS NULL THEN
2097: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
2093: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
2094: END IF;
2095:
2096: IF p_x_header_rec.cust_po_number IS NULL THEN
2097: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
2098: END IF;
2099:
2100: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
2101: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
2097: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
2098: END IF;
2099:
2100: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
2101: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
2102: END IF;
2103:
2104: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
2105: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2101: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
2102: END IF;
2103:
2104: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
2105: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2106: END IF;
2107:
2108: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
2109: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2105: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2106: END IF;
2107:
2108: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
2109: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2110: END IF;
2111:
2112: IF p_x_header_rec.demand_class_code IS NULL THEN
2113: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
2109: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2110: END IF;
2111:
2112: IF p_x_header_rec.demand_class_code IS NULL THEN
2113: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
2114: END IF;
2115:
2116: IF p_x_header_rec.expiration_date IS NULL THEN
2117: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
2113: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
2114: END IF;
2115:
2116: IF p_x_header_rec.expiration_date IS NULL THEN
2117: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
2118: END IF;
2119:
2120: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
2121: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
2117: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
2118: END IF;
2119:
2120: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
2121: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
2122: END IF;
2123:
2124: IF p_x_header_rec.fob_point_code IS NULL THEN
2125: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
2121: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
2122: END IF;
2123:
2124: IF p_x_header_rec.fob_point_code IS NULL THEN
2125: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
2126: END IF;
2127:
2128: IF p_x_header_rec.freight_carrier_code IS NULL THEN
2129: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
2125: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
2126: END IF;
2127:
2128: IF p_x_header_rec.freight_carrier_code IS NULL THEN
2129: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
2130: END IF;
2131:
2132: IF p_x_header_rec.freight_terms_code IS NULL THEN
2133: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2129: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
2130: END IF;
2131:
2132: IF p_x_header_rec.freight_terms_code IS NULL THEN
2133: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2134: END IF;
2135:
2136: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
2137: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
2133: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2134: END IF;
2135:
2136: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
2137: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
2138: END IF;
2139:
2140: IF p_x_header_rec.global_attribute1 IS NULL THEN
2141: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
2137: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
2138: END IF;
2139:
2140: IF p_x_header_rec.global_attribute1 IS NULL THEN
2141: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
2142: END IF;
2143:
2144: IF p_x_header_rec.global_attribute10 IS NULL THEN
2145: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
2141: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
2142: END IF;
2143:
2144: IF p_x_header_rec.global_attribute10 IS NULL THEN
2145: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
2146: END IF;
2147:
2148: IF p_x_header_rec.global_attribute11 IS NULL THEN
2149: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
2145: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
2146: END IF;
2147:
2148: IF p_x_header_rec.global_attribute11 IS NULL THEN
2149: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
2150: END IF;
2151:
2152: IF p_x_header_rec.global_attribute12 IS NULL THEN
2153: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
2149: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
2150: END IF;
2151:
2152: IF p_x_header_rec.global_attribute12 IS NULL THEN
2153: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
2154: END IF;
2155:
2156: IF p_x_header_rec.global_attribute13 IS NULL THEN
2157: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
2153: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
2154: END IF;
2155:
2156: IF p_x_header_rec.global_attribute13 IS NULL THEN
2157: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
2158: END IF;
2159:
2160: IF p_x_header_rec.global_attribute14 IS NULL THEN
2161: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
2157: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
2158: END IF;
2159:
2160: IF p_x_header_rec.global_attribute14 IS NULL THEN
2161: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
2162: END IF;
2163:
2164: IF p_x_header_rec.global_attribute15 IS NULL THEN
2165: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
2161: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
2162: END IF;
2163:
2164: IF p_x_header_rec.global_attribute15 IS NULL THEN
2165: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
2166: END IF;
2167:
2168: IF p_x_header_rec.global_attribute16 IS NULL THEN
2169: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
2165: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
2166: END IF;
2167:
2168: IF p_x_header_rec.global_attribute16 IS NULL THEN
2169: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
2170: END IF;
2171:
2172: IF p_x_header_rec.global_attribute17 IS NULL THEN
2173: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
2169: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
2170: END IF;
2171:
2172: IF p_x_header_rec.global_attribute17 IS NULL THEN
2173: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
2174: END IF;
2175:
2176: IF p_x_header_rec.global_attribute18 IS NULL THEN
2177: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
2173: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
2174: END IF;
2175:
2176: IF p_x_header_rec.global_attribute18 IS NULL THEN
2177: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
2178: END IF;
2179:
2180: IF p_x_header_rec.global_attribute19 IS NULL THEN
2181: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
2177: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
2178: END IF;
2179:
2180: IF p_x_header_rec.global_attribute19 IS NULL THEN
2181: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
2182: END IF;
2183:
2184: IF p_x_header_rec.global_attribute2 IS NULL THEN
2185: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
2181: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
2182: END IF;
2183:
2184: IF p_x_header_rec.global_attribute2 IS NULL THEN
2185: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
2186: END IF;
2187:
2188: IF p_x_header_rec.global_attribute20 IS NULL THEN
2189: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
2185: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
2186: END IF;
2187:
2188: IF p_x_header_rec.global_attribute20 IS NULL THEN
2189: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
2190: END IF;
2191:
2192: IF p_x_header_rec.global_attribute3 IS NULL THEN
2193: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
2189: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
2190: END IF;
2191:
2192: IF p_x_header_rec.global_attribute3 IS NULL THEN
2193: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
2194: END IF;
2195:
2196: IF p_x_header_rec.global_attribute4 IS NULL THEN
2197: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
2193: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
2194: END IF;
2195:
2196: IF p_x_header_rec.global_attribute4 IS NULL THEN
2197: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
2198: END IF;
2199:
2200: IF p_x_header_rec.global_attribute5 IS NULL THEN
2201: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
2197: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
2198: END IF;
2199:
2200: IF p_x_header_rec.global_attribute5 IS NULL THEN
2201: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
2202: END IF;
2203:
2204: IF p_x_header_rec.global_attribute6 IS NULL THEN
2205: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
2201: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
2202: END IF;
2203:
2204: IF p_x_header_rec.global_attribute6 IS NULL THEN
2205: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
2206: END IF;
2207:
2208: IF p_x_header_rec.global_attribute7 IS NULL THEN
2209: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
2205: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
2206: END IF;
2207:
2208: IF p_x_header_rec.global_attribute7 IS NULL THEN
2209: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
2210: END IF;
2211:
2212: IF p_x_header_rec.global_attribute8 IS NULL THEN
2213: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
2209: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
2210: END IF;
2211:
2212: IF p_x_header_rec.global_attribute8 IS NULL THEN
2213: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
2214: END IF;
2215:
2216: IF p_x_header_rec.global_attribute9 IS NULL THEN
2217: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
2213: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
2214: END IF;
2215:
2216: IF p_x_header_rec.global_attribute9 IS NULL THEN
2217: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
2218: END IF;
2219:
2220: IF p_x_header_rec.global_attribute_category IS NULL THEN
2221: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
2217: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
2218: END IF;
2219:
2220: IF p_x_header_rec.global_attribute_category IS NULL THEN
2221: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
2222: END IF;
2223:
2224: IF p_x_header_rec.header_id IS NULL THEN
2225: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
2221: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
2222: END IF;
2223:
2224: IF p_x_header_rec.header_id IS NULL THEN
2225: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
2226: END IF;
2227:
2228: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
2229: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2225: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
2226: END IF;
2227:
2228: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
2229: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2230: END IF;
2231:
2232: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
2233: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2229: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2230: END IF;
2231:
2232: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
2233: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2234: END IF;
2235:
2236: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
2237: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2233: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2234: END IF;
2235:
2236: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
2237: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2238: END IF;
2239:
2240: IF p_x_header_rec.last_updated_by IS NULL THEN
2241: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
2237: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2238: END IF;
2239:
2240: IF p_x_header_rec.last_updated_by IS NULL THEN
2241: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
2242: END IF;
2243:
2244: IF p_x_header_rec.last_update_date IS NULL THEN
2245: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
2241: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
2242: END IF;
2243:
2244: IF p_x_header_rec.last_update_date IS NULL THEN
2245: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
2246: END IF;
2247:
2248: IF p_x_header_rec.last_update_login IS NULL THEN
2249: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
2245: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
2246: END IF;
2247:
2248: IF p_x_header_rec.last_update_login IS NULL THEN
2249: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
2250: END IF;
2251:
2252:
2253: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
2250: END IF;
2251:
2252:
2253: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
2254: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
2255: END IF;
2256:
2257: IF p_x_header_rec.line_set_name IS NULL THEN
2258: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
2254: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
2255: END IF;
2256:
2257: IF p_x_header_rec.line_set_name IS NULL THEN
2258: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
2259: END IF;
2260:
2261: IF p_x_header_rec.open_flag IS NULL THEN
2262: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
2258: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
2259: END IF;
2260:
2261: IF p_x_header_rec.open_flag IS NULL THEN
2262: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
2263: END IF;
2264:
2265: IF p_x_header_rec.ordered_date IS NULL THEN
2266: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
2262: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
2263: END IF;
2264:
2265: IF p_x_header_rec.ordered_date IS NULL THEN
2266: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
2267: END IF;
2268:
2269: IF p_x_header_rec.order_date_type_code IS NULL THEN
2270: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
2266: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
2267: END IF;
2268:
2269: IF p_x_header_rec.order_date_type_code IS NULL THEN
2270: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
2271: END IF;
2272:
2273: IF p_x_header_rec.order_number IS NULL THEN
2274: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
2270: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
2271: END IF;
2272:
2273: IF p_x_header_rec.order_number IS NULL THEN
2274: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
2275: END IF;
2276:
2277: IF p_x_header_rec.order_source_id IS NULL THEN
2278: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
2274: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
2275: END IF;
2276:
2277: IF p_x_header_rec.order_source_id IS NULL THEN
2278: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
2279: END IF;
2280:
2281: IF p_x_header_rec.order_type_id IS NULL THEN
2282: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
2278: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
2279: END IF;
2280:
2281: IF p_x_header_rec.order_type_id IS NULL THEN
2282: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
2283: END IF;
2284: IF p_x_header_rec.order_category_code IS NULL THEN
2285: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
2286: END IF;
2281: IF p_x_header_rec.order_type_id IS NULL THEN
2282: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
2283: END IF;
2284: IF p_x_header_rec.order_category_code IS NULL THEN
2285: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
2286: END IF;
2287:
2288: IF p_x_header_rec.org_id IS NULL THEN
2289: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
2285: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
2286: END IF;
2287:
2288: IF p_x_header_rec.org_id IS NULL THEN
2289: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
2290: END IF;
2291:
2292: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
2293: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
2289: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
2290: END IF;
2291:
2292: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
2293: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
2294: END IF;
2295:
2296: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
2297: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
2293: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
2294: END IF;
2295:
2296: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
2297: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
2298: END IF;
2299:
2300: IF p_x_header_rec.payment_term_id IS NULL THEN
2301: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
2297: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
2298: END IF;
2299:
2300: IF p_x_header_rec.payment_term_id IS NULL THEN
2301: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
2302: END IF;
2303:
2304: IF p_x_header_rec.price_list_id IS NULL THEN
2305: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
2301: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
2302: END IF;
2303:
2304: IF p_x_header_rec.price_list_id IS NULL THEN
2305: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
2306: END IF;
2307:
2308: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
2309: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
2305: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
2306: END IF;
2307:
2308: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
2309: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
2310: END IF;
2311:
2312: IF p_x_header_rec.pricing_date IS NULL THEN
2313: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
2309: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
2310: END IF;
2311:
2312: IF p_x_header_rec.pricing_date IS NULL THEN
2313: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
2314: END IF;
2315:
2316: IF p_x_header_rec.program_application_id IS NULL THEN
2317: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
2313: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
2314: END IF;
2315:
2316: IF p_x_header_rec.program_application_id IS NULL THEN
2317: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
2318: END IF;
2319:
2320: IF p_x_header_rec.program_id IS NULL THEN
2321: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
2317: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
2318: END IF;
2319:
2320: IF p_x_header_rec.program_id IS NULL THEN
2321: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
2322: END IF;
2323:
2324: IF p_x_header_rec.program_update_date IS NULL THEN
2325: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
2321: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
2322: END IF;
2323:
2324: IF p_x_header_rec.program_update_date IS NULL THEN
2325: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
2326: END IF;
2327:
2328: IF p_x_header_rec.request_date IS NULL THEN
2329: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
2325: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
2326: END IF;
2327:
2328: IF p_x_header_rec.request_date IS NULL THEN
2329: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
2330: END IF;
2331:
2332: IF p_x_header_rec.request_id IS NULL THEN
2333: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
2329: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
2330: END IF;
2331:
2332: IF p_x_header_rec.request_id IS NULL THEN
2333: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
2334: END IF;
2335:
2336: IF p_x_header_rec.return_reason_code IS NULL THEN
2337: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
2333: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
2334: END IF;
2335:
2336: IF p_x_header_rec.return_reason_code IS NULL THEN
2337: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
2338: END IF;
2339:
2340: IF p_x_header_rec.salesrep_id IS NULL THEN
2341: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
2337: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
2338: END IF;
2339:
2340: IF p_x_header_rec.salesrep_id IS NULL THEN
2341: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
2342: END IF;
2343:
2344: IF p_x_header_rec.sales_channel_code IS NULL THEN
2345: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
2341: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
2342: END IF;
2343:
2344: IF p_x_header_rec.sales_channel_code IS NULL THEN
2345: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
2346: END IF;
2347:
2348: IF p_x_header_rec.shipment_priority_code IS NULL THEN
2349: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
2345: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
2346: END IF;
2347:
2348: IF p_x_header_rec.shipment_priority_code IS NULL THEN
2349: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
2350: END IF;
2351:
2352: IF p_x_header_rec.shipping_method_code IS NULL THEN
2353: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
2349: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
2350: END IF;
2351:
2352: IF p_x_header_rec.shipping_method_code IS NULL THEN
2353: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
2354: END IF;
2355:
2356: IF p_x_header_rec.ship_from_org_id IS NULL THEN
2357: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
2353: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
2354: END IF;
2355:
2356: IF p_x_header_rec.ship_from_org_id IS NULL THEN
2357: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
2358: END IF;
2359:
2360: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
2361: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
2357: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
2358: END IF;
2359:
2360: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
2361: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
2362: END IF;
2363:
2364: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
2365: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
2361: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
2362: END IF;
2363:
2364: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
2365: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
2366: END IF;
2367:
2368: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
2369: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
2365: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
2366: END IF;
2367:
2368: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
2369: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
2370: END IF;
2371:
2372: IF p_x_header_rec.ship_to_org_id IS NULL THEN
2373: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
2369: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
2370: END IF;
2371:
2372: IF p_x_header_rec.ship_to_org_id IS NULL THEN
2373: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
2374: END IF;
2375:
2376: IF p_x_header_rec.sold_from_org_id IS NULL THEN
2377: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
2373: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
2374: END IF;
2375:
2376: IF p_x_header_rec.sold_from_org_id IS NULL THEN
2377: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
2378: END IF;
2379:
2380: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
2381: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
2377: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
2378: END IF;
2379:
2380: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
2381: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
2382: END IF;
2383:
2384: IF p_x_header_rec.sold_to_org_id IS NULL THEN
2385: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
2381: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
2382: END IF;
2383:
2384: IF p_x_header_rec.sold_to_org_id IS NULL THEN
2385: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
2386: END IF;
2387:
2388: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
2389: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
2385: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
2386: END IF;
2387:
2388: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
2389: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
2390: END IF;
2391:
2392: IF p_x_header_rec.source_document_id IS NULL THEN
2393: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
2389: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
2390: END IF;
2391:
2392: IF p_x_header_rec.source_document_id IS NULL THEN
2393: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
2394: END IF;
2395:
2396: IF p_x_header_rec.source_document_type_id IS NULL THEN
2397: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
2393: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
2394: END IF;
2395:
2396: IF p_x_header_rec.source_document_type_id IS NULL THEN
2397: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
2398: END IF;
2399:
2400: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
2401: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
2397: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
2398: END IF;
2399:
2400: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
2401: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
2402: END IF;
2403:
2404: IF p_x_header_rec.tax_exempt_number IS NULL THEN
2405: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2401: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
2402: END IF;
2403:
2404: IF p_x_header_rec.tax_exempt_number IS NULL THEN
2405: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2406: END IF;
2407:
2408: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
2409: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2405: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2406: END IF;
2407:
2408: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
2409: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2410: END IF;
2411:
2412: IF p_x_header_rec.tax_point_code IS NULL THEN
2413: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
2409: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2410: END IF;
2411:
2412: IF p_x_header_rec.tax_point_code IS NULL THEN
2413: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
2414: END IF;
2415:
2416: IF p_x_header_rec.transactional_curr_code IS NULL THEN
2417: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
2413: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
2414: END IF;
2415:
2416: IF p_x_header_rec.transactional_curr_code IS NULL THEN
2417: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
2418: END IF;
2419:
2420: IF p_x_header_rec.version_number IS NULL THEN
2421: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
2417: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
2418: END IF;
2419:
2420: IF p_x_header_rec.version_number IS NULL THEN
2421: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
2422: END IF;
2423:
2424: IF p_x_header_rec.payment_type_code IS NULL THEN
2425: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
2421: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
2422: END IF;
2423:
2424: IF p_x_header_rec.payment_type_code IS NULL THEN
2425: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
2426: END IF;
2427:
2428: IF p_x_header_rec.payment_amount IS NULL THEN
2429: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
2425: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
2426: END IF;
2427:
2428: IF p_x_header_rec.payment_amount IS NULL THEN
2429: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
2430: END IF;
2431:
2432: IF p_x_header_rec.check_number IS NULL THEN
2433: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
2429: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
2430: END IF;
2431:
2432: IF p_x_header_rec.check_number IS NULL THEN
2433: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
2434: END IF;
2435:
2436: IF p_x_header_rec.credit_card_code IS NULL THEN
2437: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
2433: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
2434: END IF;
2435:
2436: IF p_x_header_rec.credit_card_code IS NULL THEN
2437: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
2438: END IF;
2439:
2440: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
2441: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2437: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
2438: END IF;
2439:
2440: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
2441: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2442: END IF;
2443:
2444: IF p_x_header_rec.credit_card_number IS NULL THEN
2445: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
2441: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2442: END IF;
2443:
2444: IF p_x_header_rec.credit_card_number IS NULL THEN
2445: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
2446: END IF;
2447:
2448: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
2449: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2445: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
2446: END IF;
2447:
2448: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
2449: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2450: END IF;
2451:
2452: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
2453: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2449: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2450: END IF;
2451:
2452: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
2453: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2454: END IF;
2455:
2456: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
2457: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2453: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2454: END IF;
2455:
2456: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
2457: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2458: END IF;
2459:
2460: IF p_x_header_rec.first_ack_code IS NULL THEN
2461: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
2457: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2458: END IF;
2459:
2460: IF p_x_header_rec.first_ack_code IS NULL THEN
2461: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
2462: END IF;
2463:
2464: IF p_x_header_rec.first_ack_date IS NULL THEN
2465: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
2461: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
2462: END IF;
2463:
2464: IF p_x_header_rec.first_ack_date IS NULL THEN
2465: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
2466: END IF;
2467:
2468: IF p_x_header_rec.last_ack_code IS NULL THEN
2469: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
2465: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
2466: END IF;
2467:
2468: IF p_x_header_rec.last_ack_code IS NULL THEN
2469: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
2470: END IF;
2471:
2472: IF p_x_header_rec.last_ack_date IS NULL THEN
2473: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
2469: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
2470: END IF;
2471:
2472: IF p_x_header_rec.last_ack_date IS NULL THEN
2473: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
2474: END IF;
2475:
2476: IF p_x_header_rec.shipping_instructions IS NULL THEN
2477: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2473: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
2474: END IF;
2475:
2476: IF p_x_header_rec.shipping_instructions IS NULL THEN
2477: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2478: END IF;
2479:
2480: IF p_x_header_rec.packing_instructions IS NULL THEN
2481: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
2477: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2478: END IF;
2479:
2480: IF p_x_header_rec.packing_instructions IS NULL THEN
2481: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
2482: END IF;
2483:
2484: IF p_x_header_rec.flow_status_code IS NULL THEN
2485: p_x_header_rec.flow_status_code := 'ENTERED'; --Bug 15963000
2485: p_x_header_rec.flow_status_code := 'ENTERED'; --Bug 15963000
2486: END IF;
2487:
2488: IF p_x_header_rec.marketing_source_code_id IS NULL THEN
2489: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
2490: END IF;
2491:
2492: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
2493: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
2489: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
2490: END IF;
2491:
2492: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
2493: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
2494: END IF;
2495:
2496: -- QUOTING changes
2497:
2495:
2496: -- QUOTING changes
2497:
2498: IF p_x_header_rec.quote_date IS NULL THEN
2499: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
2500: END IF;
2501:
2502: IF p_x_header_rec.quote_number IS NULL THEN
2503: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
2499: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
2500: END IF;
2501:
2502: IF p_x_header_rec.quote_number IS NULL THEN
2503: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
2504: END IF;
2505:
2506: IF p_x_header_rec.sales_document_name IS NULL THEN
2507: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
2503: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
2504: END IF;
2505:
2506: IF p_x_header_rec.sales_document_name IS NULL THEN
2507: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
2508: END IF;
2509:
2510: IF p_x_header_rec.transaction_phase_code IS NULL THEN
2511: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2507: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
2508: END IF;
2509:
2510: IF p_x_header_rec.transaction_phase_code IS NULL THEN
2511: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2512: END IF;
2513:
2514: IF p_x_header_rec.user_status_code IS NULL THEN
2515: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
2511: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2512: END IF;
2513:
2514: IF p_x_header_rec.user_status_code IS NULL THEN
2515: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
2516: END IF;
2517:
2518: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
2519: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
2515: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
2516: END IF;
2517:
2518: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
2519: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
2520: END IF;
2521:
2522: IF p_x_header_rec.source_document_version_number IS NULL THEN
2523: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
2519: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
2520: END IF;
2521:
2522: IF p_x_header_rec.source_document_version_number IS NULL THEN
2523: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
2524: END IF;
2525:
2526: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
2527: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
2523: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
2524: END IF;
2525:
2526: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
2527: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
2528: END IF;
2529:
2530: -- QUOTING changes END
2531:
2529:
2530: -- QUOTING changes END
2531:
2532: IF p_x_header_rec.Minisite_id IS NULL THEN
2533: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
2534: END IF;
2535:
2536: IF p_x_header_rec.End_customer_id IS NULL THEN
2537: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
2533: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
2534: END IF;
2535:
2536: IF p_x_header_rec.End_customer_id IS NULL THEN
2537: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
2538: END IF;
2539:
2540: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
2541: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2537: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
2538: END IF;
2539:
2540: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
2541: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2542: END IF;
2543:
2544: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
2545: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2541: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2542: END IF;
2543:
2544: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
2545: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2546: END IF;
2547:
2548: IF p_x_header_rec.Ib_owner IS NULL THEN
2549: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
2545: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2546: END IF;
2547:
2548: IF p_x_header_rec.Ib_owner IS NULL THEN
2549: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
2550: END IF;
2551:
2552: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
2553: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2549: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
2550: END IF;
2551:
2552: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
2553: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2554: END IF;
2555:
2556: IF p_x_header_rec.Ib_current_location IS NULL THEN
2557: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2553: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2554: END IF;
2555:
2556: IF p_x_header_rec.Ib_current_location IS NULL THEN
2557: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2558: END IF;
2559:
2560: IF p_x_header_rec.supplier_signature IS NULL THEN
2561: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
2557: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2558: END IF;
2559:
2560: IF p_x_header_rec.supplier_signature IS NULL THEN
2561: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
2562: END IF;
2563:
2564: IF p_x_header_rec.supplier_signature_date IS NULL THEN
2565: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2561: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
2562: END IF;
2563:
2564: IF p_x_header_rec.supplier_signature_date IS NULL THEN
2565: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2566: END IF;
2567:
2568: IF p_x_header_rec.customer_signature IS NULL THEN
2569: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
2565: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2566: END IF;
2567:
2568: IF p_x_header_rec.customer_signature IS NULL THEN
2569: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
2570: END IF;
2571:
2572: IF p_x_header_rec.customer_signature_date IS NULL THEN
2573: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
2569: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
2570: END IF;
2571:
2572: IF p_x_header_rec.customer_signature_date IS NULL THEN
2573: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
2574: END IF;
2575:
2576: IF p_x_header_rec.contract_template_id IS NULL THEN
2577: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
2573: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
2574: END IF;
2575:
2576: IF p_x_header_rec.contract_template_id IS NULL THEN
2577: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
2578: END IF;
2579:
2580: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
2581: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
2577: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
2578: END IF;
2579:
2580: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
2581: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
2582: END IF;
2583:
2584: IF p_x_header_rec.contract_source_document_id IS NULL THEN
2585: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
2581: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
2582: END IF;
2583:
2584: IF p_x_header_rec.contract_source_document_id IS NULL THEN
2585: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
2586: END IF;
2587:
2588: --key Transaction dates
2589: IF p_x_header_rec.order_firmed_date IS NULL THEN
2586: END IF;
2587:
2588: --key Transaction dates
2589: IF p_x_header_rec.order_firmed_date IS NULL THEN
2590: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
2591: END IF;
2592:
2593: oe_debug_pub.add('Exiting Convert_hdr_null_to_miss', 1);
2594:
2611:
2612: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2613:
2614: IF p_x_Header_Payment_rec.attribute1 IS NULL THEN
2615: p_x_Header_Payment_rec.attribute1 := FND_API.G_MISS_CHAR;
2616: END IF;
2617:
2618: IF p_x_Header_Payment_rec.attribute2 IS NULL THEN
2619: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
2615: p_x_Header_Payment_rec.attribute1 := FND_API.G_MISS_CHAR;
2616: END IF;
2617:
2618: IF p_x_Header_Payment_rec.attribute2 IS NULL THEN
2619: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
2620: END IF;
2621:
2622: IF p_x_Header_Payment_rec.attribute3 IS NULL THEN
2623: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
2619: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
2620: END IF;
2621:
2622: IF p_x_Header_Payment_rec.attribute3 IS NULL THEN
2623: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
2624: END IF;
2625:
2626: IF p_x_Header_Payment_rec.attribute4 IS NULL THEN
2627: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
2623: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
2624: END IF;
2625:
2626: IF p_x_Header_Payment_rec.attribute4 IS NULL THEN
2627: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
2628: END IF;
2629:
2630: IF p_x_Header_Payment_rec.attribute5 IS NULL THEN
2631: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
2627: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
2628: END IF;
2629:
2630: IF p_x_Header_Payment_rec.attribute5 IS NULL THEN
2631: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
2632: END IF;
2633:
2634: IF p_x_Header_Payment_rec.attribute6 IS NULL THEN
2635: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
2631: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
2632: END IF;
2633:
2634: IF p_x_Header_Payment_rec.attribute6 IS NULL THEN
2635: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
2636: END IF;
2637:
2638: IF p_x_Header_Payment_rec.attribute7 IS NULL THEN
2639: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
2635: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
2636: END IF;
2637:
2638: IF p_x_Header_Payment_rec.attribute7 IS NULL THEN
2639: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
2640: END IF;
2641:
2642: IF p_x_Header_Payment_rec.attribute8 IS NULL THEN
2643: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
2639: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
2640: END IF;
2641:
2642: IF p_x_Header_Payment_rec.attribute8 IS NULL THEN
2643: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
2644: END IF;
2645:
2646: IF p_x_Header_Payment_rec.attribute9 IS NULL THEN
2647: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
2643: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
2644: END IF;
2645:
2646: IF p_x_Header_Payment_rec.attribute9 IS NULL THEN
2647: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
2648: END IF;
2649:
2650: IF p_x_Header_Payment_rec.attribute10 IS NULL THEN
2651: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
2647: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
2648: END IF;
2649:
2650: IF p_x_Header_Payment_rec.attribute10 IS NULL THEN
2651: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
2652: END IF;
2653:
2654: IF p_x_Header_Payment_rec.attribute11 IS NULL THEN
2655: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
2651: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
2652: END IF;
2653:
2654: IF p_x_Header_Payment_rec.attribute11 IS NULL THEN
2655: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
2656: END IF;
2657:
2658: IF p_x_Header_Payment_rec.attribute12 IS NULL THEN
2659: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
2655: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
2656: END IF;
2657:
2658: IF p_x_Header_Payment_rec.attribute12 IS NULL THEN
2659: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
2660: END IF;
2661:
2662: IF p_x_Header_Payment_rec.attribute13 IS NULL THEN
2663: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
2659: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
2660: END IF;
2661:
2662: IF p_x_Header_Payment_rec.attribute13 IS NULL THEN
2663: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
2664: END IF;
2665:
2666: IF p_x_Header_Payment_rec.attribute14 IS NULL THEN
2667: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
2663: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
2664: END IF;
2665:
2666: IF p_x_Header_Payment_rec.attribute14 IS NULL THEN
2667: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
2668: END IF;
2669:
2670: IF p_x_Header_Payment_rec.attribute15 IS NULL THEN
2671: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
2667: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
2668: END IF;
2669:
2670: IF p_x_Header_Payment_rec.attribute15 IS NULL THEN
2671: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
2672: END IF;
2673:
2674: IF p_x_Header_Payment_rec.context IS NULL THEN
2675: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
2671: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
2672: END IF;
2673:
2674: IF p_x_Header_Payment_rec.context IS NULL THEN
2675: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
2676: END IF;
2677:
2678: IF p_x_Header_Payment_rec.created_by IS NULL THEN
2679: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
2675: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
2676: END IF;
2677:
2678: IF p_x_Header_Payment_rec.created_by IS NULL THEN
2679: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
2680: END IF;
2681:
2682: IF p_x_Header_Payment_rec.creation_date IS NULL THEN
2683: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
2679: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
2680: END IF;
2681:
2682: IF p_x_Header_Payment_rec.creation_date IS NULL THEN
2683: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
2684: END IF;
2685:
2686: IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
2687: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
2683: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
2684: END IF;
2685:
2686: IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
2687: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
2688: END IF;
2689:
2690: IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
2691: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
2687: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
2688: END IF;
2689:
2690: IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
2691: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
2692: END IF;
2693:
2694: IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
2695: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
2691: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
2692: END IF;
2693:
2694: IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
2695: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
2696: END IF;
2697:
2698: IF p_x_Header_Payment_rec.check_number IS NULL THEN
2699: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
2695: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
2696: END IF;
2697:
2698: IF p_x_Header_Payment_rec.check_number IS NULL THEN
2699: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
2700: END IF;
2701:
2702: IF p_x_Header_Payment_rec.credit_card_approval_code IS NULL THEN
2703: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2699: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
2700: END IF;
2701:
2702: IF p_x_Header_Payment_rec.credit_card_approval_code IS NULL THEN
2703: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2704: END IF;
2705:
2706: IF p_x_Header_Payment_rec.credit_card_approval_date IS NULL THEN
2707: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2703: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
2704: END IF;
2705:
2706: IF p_x_Header_Payment_rec.credit_card_approval_date IS NULL THEN
2707: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2708: END IF;
2709:
2710: IF p_x_Header_Payment_rec.credit_card_code IS NULL THEN
2711: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
2707: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
2708: END IF;
2709:
2710: IF p_x_Header_Payment_rec.credit_card_code IS NULL THEN
2711: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
2712: END IF;
2713:
2714: IF p_x_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
2715: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2711: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
2712: END IF;
2713:
2714: IF p_x_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
2715: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2716: END IF;
2717:
2718: IF p_x_Header_Payment_rec.credit_card_holder_name IS NULL THEN
2719: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2715: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
2716: END IF;
2717:
2718: IF p_x_Header_Payment_rec.credit_card_holder_name IS NULL THEN
2719: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2720: END IF;
2721:
2722: IF p_x_Header_Payment_rec.credit_card_number IS NULL THEN
2723: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
2719: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
2720: END IF;
2721:
2722: IF p_x_Header_Payment_rec.credit_card_number IS NULL THEN
2723: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
2724: END IF;
2725:
2726: IF p_x_Header_Payment_rec.payment_level_code IS NULL THEN
2727: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
2723: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
2724: END IF;
2725:
2726: IF p_x_Header_Payment_rec.payment_level_code IS NULL THEN
2727: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
2728: END IF;
2729:
2730: IF p_x_Header_Payment_rec.commitment_applied_amount IS NULL THEN
2731: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
2727: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
2728: END IF;
2729:
2730: IF p_x_Header_Payment_rec.commitment_applied_amount IS NULL THEN
2731: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
2732: END IF;
2733:
2734: IF p_x_Header_Payment_rec.commitment_interfaced_amount IS NULL THEN
2735: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
2731: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
2732: END IF;
2733:
2734: IF p_x_Header_Payment_rec.commitment_interfaced_amount IS NULL THEN
2735: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
2736: END IF;
2737:
2738: IF p_x_Header_Payment_rec.payment_number IS NULL THEN
2739: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
2735: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
2736: END IF;
2737:
2738: IF p_x_Header_Payment_rec.payment_number IS NULL THEN
2739: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
2740: END IF;
2741:
2742: IF p_x_Header_Payment_rec.header_id IS NULL THEN
2743: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
2739: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
2740: END IF;
2741:
2742: IF p_x_Header_Payment_rec.header_id IS NULL THEN
2743: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
2744: END IF;
2745:
2746: IF p_x_Header_Payment_rec.line_id IS NULL THEN
2747: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
2743: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
2744: END IF;
2745:
2746: IF p_x_Header_Payment_rec.line_id IS NULL THEN
2747: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
2748: END IF;
2749:
2750: IF p_x_Header_Payment_rec.payment_amount IS NULL THEN
2751: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
2747: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
2748: END IF;
2749:
2750: IF p_x_Header_Payment_rec.payment_amount IS NULL THEN
2751: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
2752: END IF;
2753:
2754: IF p_x_Header_Payment_rec.payment_collection_event IS NULL THEN
2755: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
2751: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
2752: END IF;
2753:
2754: IF p_x_Header_Payment_rec.payment_collection_event IS NULL THEN
2755: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
2756: END IF;
2757:
2758: IF p_x_Header_Payment_rec.defer_payment_processing_flag IS NULL THEN
2759: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
2755: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
2756: END IF;
2757:
2758: IF p_x_Header_Payment_rec.defer_payment_processing_flag IS NULL THEN
2759: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
2760: END IF;
2761:
2762: IF p_x_Header_Payment_rec.payment_trx_id IS NULL THEN
2763: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
2759: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
2760: END IF;
2761:
2762: IF p_x_Header_Payment_rec.payment_trx_id IS NULL THEN
2763: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
2764: END IF;
2765:
2766: IF p_x_Header_Payment_rec.payment_type_code IS NULL THEN
2767: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
2763: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
2764: END IF;
2765:
2766: IF p_x_Header_Payment_rec.payment_type_code IS NULL THEN
2767: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
2768: END IF;
2769:
2770: IF p_x_Header_Payment_rec.payment_set_id IS NULL THEN
2771: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
2767: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
2768: END IF;
2769:
2770: IF p_x_Header_Payment_rec.payment_set_id IS NULL THEN
2771: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
2772: END IF;
2773:
2774: IF p_x_Header_Payment_rec.prepaid_amount IS NULL THEN
2775: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
2771: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
2772: END IF;
2773:
2774: IF p_x_Header_Payment_rec.prepaid_amount IS NULL THEN
2775: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
2776: END IF;
2777:
2778: IF p_x_Header_Payment_rec.program_application_id IS NULL THEN
2779: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
2775: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
2776: END IF;
2777:
2778: IF p_x_Header_Payment_rec.program_application_id IS NULL THEN
2779: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
2780: END IF;
2781:
2782: IF p_x_Header_Payment_rec.program_id IS NULL THEN
2783: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
2779: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
2780: END IF;
2781:
2782: IF p_x_Header_Payment_rec.program_id IS NULL THEN
2783: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
2784: END IF;
2785:
2786: IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
2787: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
2783: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
2784: END IF;
2785:
2786: IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
2787: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
2788: END IF;
2789:
2790: IF p_x_Header_Payment_rec.receipt_method_id IS NULL THEN
2791: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
2787: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
2788: END IF;
2789:
2790: IF p_x_Header_Payment_rec.receipt_method_id IS NULL THEN
2791: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
2792: END IF;
2793:
2794: IF p_x_Header_Payment_rec.request_id IS NULL THEN
2795: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
2791: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
2792: END IF;
2793:
2794: IF p_x_Header_Payment_rec.request_id IS NULL THEN
2795: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
2796: END IF;
2797:
2798: IF p_x_Header_Payment_rec.tangible_id IS NULL THEN
2799: p_x_Header_Payment_rec.tangible_id := FND_API.G_MISS_CHAR;
2795: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
2796: END IF;
2797:
2798: IF p_x_Header_Payment_rec.tangible_id IS NULL THEN
2799: p_x_Header_Payment_rec.tangible_id := FND_API.G_MISS_CHAR;
2800: END IF;
2801:
2802: oe_debug_pub.add('Exiting OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2803:
2822: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
2823: end if;
2824:
2825: IF p_x_line_rec.unit_cost IS NULL THEN
2826: p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
2827: END IF;
2828:
2829: -- Bug 8841055
2830: IF p_x_line_rec.split_action_code IS NULL THEN
2827: END IF;
2828:
2829: -- Bug 8841055
2830: IF p_x_line_rec.split_action_code IS NULL THEN
2831: p_x_line_rec.split_action_code := Fnd_Api.G_Miss_Char;
2832: END IF;
2833:
2834:
2835: IF p_x_line_rec.accounting_rule_id IS NULL THEN
2832: END IF;
2833:
2834:
2835: IF p_x_line_rec.accounting_rule_id IS NULL THEN
2836: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2837: END IF;
2838:
2839: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
2840: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2836: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2837: END IF;
2838:
2839: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
2840: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2841: END IF;
2842:
2843: IF p_x_line_rec.actual_arrival_date IS NULL THEN
2844: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
2840: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2841: END IF;
2842:
2843: IF p_x_line_rec.actual_arrival_date IS NULL THEN
2844: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
2845: END IF;
2846:
2847: IF p_x_line_rec.actual_shipment_date IS NULL THEN
2848: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
2844: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
2845: END IF;
2846:
2847: IF p_x_line_rec.actual_shipment_date IS NULL THEN
2848: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
2849: END IF;
2850:
2851: IF p_x_line_rec.agreement_id IS NULL THEN
2852: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2848: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
2849: END IF;
2850:
2851: IF p_x_line_rec.agreement_id IS NULL THEN
2852: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2853: END IF;
2854:
2855: --Added for 10182413...
2856: IF p_x_line_rec.reserved_quantity IS NULL THEN
2853: END IF;
2854:
2855: --Added for 10182413...
2856: IF p_x_line_rec.reserved_quantity IS NULL THEN
2857: p_x_line_rec.reserved_quantity := FND_API.G_MISS_NUM;
2858: END IF;
2859: -- End of 10182413
2860:
2861:
2859: -- End of 10182413
2860:
2861:
2862: IF p_x_line_rec.arrival_set_id IS NULL THEN
2863: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
2864: END IF;
2865:
2866: -- Start: Fix 8530507
2867: -------------------
2877: FROM oe_order_lines_all l
2878: WHERE l.line_id = p_x_line_rec.line_id;
2879: oe_debug_pub.ADD(' cnv line null to miss: l_old_arrival_set = ' || l_old_arrival_set_id);
2880:
2881: IF Nvl(l_old_arrival_set_id, Fnd_Api.G_Miss_Num) <> Fnd_Api.G_Miss_Num
2882: THEN
2883: -- The line has already been a part of shipset. The user really
2884: -- intended to remove it from the arrival set, if at all they had set
2885: -- p_x_line_rec.arrival_set to a NULL. Explicitly check for this case
2905: -- stamp the derived arrival_set_id on p_x_line_rec.arrival_set_id
2906: p_x_line_rec.arrival_set_id := l_old_arrival_set_id;
2907: -- 10171747
2908: ELSE -- that is, when p_x_line_rec.arrival_set is null in update mode.
2909: p_x_line_rec.arrival_set := Fnd_Api.G_Miss_Char;
2910: -- 10171747
2911: END IF;
2912: END IF; -- Check on l_old_arrival_set_id
2913: EXCEPTION
2912: END IF; -- Check on l_old_arrival_set_id
2913: EXCEPTION
2914: WHEN Others THEN
2915: IF p_x_line_rec.arrival_set_id IS NULL THEN
2916: p_x_line_rec.arrival_set_id := fnd_api.g_miss_num;
2917: END IF;
2918:
2919: -- 10171747
2920: IF p_x_line_rec.arrival_set IS NULL THEN
2917: END IF;
2918:
2919: -- 10171747
2920: IF p_x_line_rec.arrival_set IS NULL THEN
2921: p_x_line_rec.arrival_set := Fnd_Api.G_Miss_Char;
2922: END IF;
2923: -- 10171747
2924: oe_debug_pub.ADD('Exception occurred at OEXUGNIB Loc 14: ' || SQLERRM);
2925: END;
2925: END;
2926: ELSE -- For entity operations other than UPDATE.
2927: oe_debug_pub.ADD(' cnv line null to miss: Location 15...');
2928: IF p_x_line_rec.arrival_set_id IS NULL THEN
2929: p_x_line_rec.arrival_set_id := Fnd_Api.G_Miss_Num;
2930: END IF;
2931:
2932: -- 10171747
2933: IF p_x_line_rec.arrival_set IS NULL THEN
2930: END IF;
2931:
2932: -- 10171747
2933: IF p_x_line_rec.arrival_set IS NULL THEN
2934: p_x_line_rec.arrival_set := Fnd_Api.G_Miss_Char;
2935: END IF;
2936: -- 10171747
2937:
2938: END IF; -- Operation code check for UPDATE.
2957: AND l.line_id = p_x_line_rec.line_id;
2958:
2959: -- If existing value and incoming value are same, set it to miss char
2960: IF l_old_arrival_set = p_x_line_rec.arrival_set THEN
2961: p_x_line_rec.arrival_set := Fnd_Api.G_Miss_Char;
2962: END IF;
2963:
2964: EXCEPTION
2965: -- If there is no ship set before and incoming value is also null
2965: -- If there is no ship set before and incoming value is also null
2966: -- set it to miss Char
2967: WHEN Others THEN -- including NO_DATA_FOUND
2968: IF p_x_line_rec.arrival_set IS NULL THEN
2969: p_x_line_rec.arrival_set := fnd_api.g_miss_Char;
2970: END IF;
2971: END;
2972: END IF; -- Additional operation code check for UPDATE.
2973: */
2974: -- End: Fix 9874630
2975:
2976:
2977: IF p_x_line_rec.ato_line_id IS NULL THEN
2978: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
2979: END IF;
2980: IF p_x_line_rec.upgraded_flag IS NULL THEN
2981: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
2982: END IF;
2977: IF p_x_line_rec.ato_line_id IS NULL THEN
2978: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
2979: END IF;
2980: IF p_x_line_rec.upgraded_flag IS NULL THEN
2981: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
2982: END IF;
2983:
2984: IF p_x_line_rec.attribute1 IS NULL THEN
2985: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
2981: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
2982: END IF;
2983:
2984: IF p_x_line_rec.attribute1 IS NULL THEN
2985: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
2986: END IF;
2987:
2988: IF p_x_line_rec.attribute10 IS NULL THEN
2989: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
2985: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
2986: END IF;
2987:
2988: IF p_x_line_rec.attribute10 IS NULL THEN
2989: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
2990: END IF;
2991:
2992: IF p_x_line_rec.attribute11 IS NULL THEN
2993: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
2989: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
2990: END IF;
2991:
2992: IF p_x_line_rec.attribute11 IS NULL THEN
2993: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
2994: END IF;
2995:
2996: IF p_x_line_rec.attribute12 IS NULL THEN
2997: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
2993: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
2994: END IF;
2995:
2996: IF p_x_line_rec.attribute12 IS NULL THEN
2997: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
2998: END IF;
2999:
3000: IF p_x_line_rec.attribute13 IS NULL THEN
3001: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
2997: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
2998: END IF;
2999:
3000: IF p_x_line_rec.attribute13 IS NULL THEN
3001: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3002: END IF;
3003:
3004: IF p_x_line_rec.attribute14 IS NULL THEN
3005: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3001: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3002: END IF;
3003:
3004: IF p_x_line_rec.attribute14 IS NULL THEN
3005: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3006: END IF;
3007:
3008: IF p_x_line_rec.attribute15 IS NULL THEN
3009: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3005: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3006: END IF;
3007:
3008: IF p_x_line_rec.attribute15 IS NULL THEN
3009: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3010: END IF;
3011:
3012: IF p_x_line_rec.attribute16 IS NULL THEN --For bug 2184255
3013: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
3009: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3010: END IF;
3011:
3012: IF p_x_line_rec.attribute16 IS NULL THEN --For bug 2184255
3013: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
3014: END IF;
3015:
3016: IF p_x_line_rec.attribute17 IS NULL THEN
3017: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3013: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
3014: END IF;
3015:
3016: IF p_x_line_rec.attribute17 IS NULL THEN
3017: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3018: END IF;
3019:
3020: IF p_x_line_rec.attribute18 IS NULL THEN
3021: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3017: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3018: END IF;
3019:
3020: IF p_x_line_rec.attribute18 IS NULL THEN
3021: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3022: END IF;
3023:
3024: IF p_x_line_rec.attribute19 IS NULL THEN
3025: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3021: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3022: END IF;
3023:
3024: IF p_x_line_rec.attribute19 IS NULL THEN
3025: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3026: END IF;
3027:
3028: IF p_x_line_rec.attribute2 IS NULL THEN
3029: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3025: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3026: END IF;
3027:
3028: IF p_x_line_rec.attribute2 IS NULL THEN
3029: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3030: END IF;
3031:
3032: IF p_x_line_rec.attribute20 IS NULL THEN
3033: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3029: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3030: END IF;
3031:
3032: IF p_x_line_rec.attribute20 IS NULL THEN
3033: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3034: END IF;
3035:
3036: IF p_x_line_rec.attribute3 IS NULL THEN
3037: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3033: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3034: END IF;
3035:
3036: IF p_x_line_rec.attribute3 IS NULL THEN
3037: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3038: END IF;
3039:
3040: IF p_x_line_rec.attribute4 IS NULL THEN
3041: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3037: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3038: END IF;
3039:
3040: IF p_x_line_rec.attribute4 IS NULL THEN
3041: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3042: END IF;
3043:
3044: IF p_x_line_rec.attribute5 IS NULL THEN
3045: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3041: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3042: END IF;
3043:
3044: IF p_x_line_rec.attribute5 IS NULL THEN
3045: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3046: END IF;
3047:
3048: IF p_x_line_rec.attribute6 IS NULL THEN
3049: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3045: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3046: END IF;
3047:
3048: IF p_x_line_rec.attribute6 IS NULL THEN
3049: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3050: END IF;
3051:
3052: IF p_x_line_rec.attribute7 IS NULL THEN
3053: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3049: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3050: END IF;
3051:
3052: IF p_x_line_rec.attribute7 IS NULL THEN
3053: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3054: END IF;
3055:
3056: IF p_x_line_rec.attribute8 IS NULL THEN
3057: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3053: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3054: END IF;
3055:
3056: IF p_x_line_rec.attribute8 IS NULL THEN
3057: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3058: END IF;
3059:
3060: IF p_x_line_rec.attribute9 IS NULL THEN
3061: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3057: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3058: END IF;
3059:
3060: IF p_x_line_rec.attribute9 IS NULL THEN
3061: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3062: END IF;
3063:
3064: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
3065: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
3061: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3062: END IF;
3063:
3064: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
3065: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
3066: END IF;
3067: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
3068: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
3069: END IF;
3064: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
3065: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
3066: END IF;
3067: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
3068: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
3069: END IF;
3070:
3071: IF p_x_line_rec.booked_flag IS NULL THEN
3072: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
3068: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
3069: END IF;
3070:
3071: IF p_x_line_rec.booked_flag IS NULL THEN
3072: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
3073: END IF;
3074:
3075: IF p_x_line_rec.cancelled_flag IS NULL THEN
3076: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
3072: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
3073: END IF;
3074:
3075: IF p_x_line_rec.cancelled_flag IS NULL THEN
3076: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
3077: END IF;
3078:
3079: IF p_x_line_rec.cancelled_quantity IS NULL THEN
3080: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
3076: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
3077: END IF;
3078:
3079: IF p_x_line_rec.cancelled_quantity IS NULL THEN
3080: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
3081: END IF;
3082:
3083: IF p_x_line_rec.component_code IS NULL THEN
3084: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
3080: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
3081: END IF;
3082:
3083: IF p_x_line_rec.component_code IS NULL THEN
3084: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
3085: END IF;
3086:
3087: IF p_x_line_rec.component_number IS NULL THEN
3088: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
3084: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
3085: END IF;
3086:
3087: IF p_x_line_rec.component_number IS NULL THEN
3088: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
3089: END IF;
3090:
3091: IF p_x_line_rec.component_sequence_id IS NULL THEN
3092: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
3088: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
3089: END IF;
3090:
3091: IF p_x_line_rec.component_sequence_id IS NULL THEN
3092: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
3093: END IF;
3094:
3095: IF p_x_line_rec.config_header_id IS NULL THEN
3096: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
3092: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
3093: END IF;
3094:
3095: IF p_x_line_rec.config_header_id IS NULL THEN
3096: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
3097: END IF;
3098:
3099: IF p_x_line_rec.config_rev_nbr IS NULL THEN
3100: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
3096: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
3097: END IF;
3098:
3099: IF p_x_line_rec.config_rev_nbr IS NULL THEN
3100: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
3101: END IF;
3102:
3103: IF p_x_line_rec.config_display_sequence IS NULL THEN
3104: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
3100: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
3101: END IF;
3102:
3103: IF p_x_line_rec.config_display_sequence IS NULL THEN
3104: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
3105: END IF;
3106:
3107: IF p_x_line_rec.configuration_id IS NULL THEN
3108: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
3104: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
3105: END IF;
3106:
3107: IF p_x_line_rec.configuration_id IS NULL THEN
3108: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
3109: END IF;
3110:
3111: IF p_x_line_rec.context IS NULL THEN
3112: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3108: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
3109: END IF;
3110:
3111: IF p_x_line_rec.context IS NULL THEN
3112: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3113: END IF;
3114:
3115:
3116:
3116:
3117:
3118:
3119: IF p_x_line_rec.created_by IS NULL THEN
3120: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
3121: END IF;
3122:
3123: IF p_x_line_rec.creation_date IS NULL THEN
3124: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
3120: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
3121: END IF;
3122:
3123: IF p_x_line_rec.creation_date IS NULL THEN
3124: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
3125: END IF;
3126:
3127: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
3128: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
3124: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
3125: END IF;
3126:
3127: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
3128: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
3129: END IF;
3130:
3131: IF p_x_line_rec.customer_dock_code IS NULL THEN
3132: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
3128: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
3129: END IF;
3130:
3131: IF p_x_line_rec.customer_dock_code IS NULL THEN
3132: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
3133: END IF;
3134:
3135: IF p_x_line_rec.customer_job IS NULL THEN
3136: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
3132: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
3133: END IF;
3134:
3135: IF p_x_line_rec.customer_job IS NULL THEN
3136: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
3137: END IF;
3138:
3139: IF p_x_line_rec.customer_production_line IS NULL THEN
3140: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
3136: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
3137: END IF;
3138:
3139: IF p_x_line_rec.customer_production_line IS NULL THEN
3140: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
3141: END IF;
3142:
3143: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
3144: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
3140: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
3141: END IF;
3142:
3143: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
3144: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
3145: END IF;
3146:
3147: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
3148: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
3144: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
3145: END IF;
3146:
3147: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
3148: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
3149: END IF;
3150:
3151: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
3152: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
3148: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
3149: END IF;
3150:
3151: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
3152: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
3153: END IF;
3154:
3155: IF p_x_line_rec.cust_po_number IS NULL THEN
3156: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
3152: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
3153: END IF;
3154:
3155: IF p_x_line_rec.cust_po_number IS NULL THEN
3156: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
3157: END IF;
3158:
3159: IF p_x_line_rec.customer_line_number IS NULL THEN
3160: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
3156: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
3157: END IF;
3158:
3159: IF p_x_line_rec.customer_line_number IS NULL THEN
3160: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
3161: END IF;
3162:
3163: IF p_x_line_rec.customer_shipment_number IS NULL THEN
3164: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
3160: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
3161: END IF;
3162:
3163: IF p_x_line_rec.customer_shipment_number IS NULL THEN
3164: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
3165: END IF;
3166:
3167: IF p_x_line_rec.delivery_lead_time IS NULL THEN
3168: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
3164: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
3165: END IF;
3166:
3167: IF p_x_line_rec.delivery_lead_time IS NULL THEN
3168: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
3169: END IF;
3170:
3171: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
3172: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3168: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
3169: END IF;
3170:
3171: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
3172: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3173: END IF;
3174:
3175: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
3176: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3172: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3173: END IF;
3174:
3175: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
3176: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3177: END IF;
3178:
3179: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
3180: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
3176: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3177: END IF;
3178:
3179: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
3180: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
3181: END IF;
3182:
3183: IF p_x_line_rec.demand_class_code IS NULL THEN
3184: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
3180: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
3181: END IF;
3182:
3183: IF p_x_line_rec.demand_class_code IS NULL THEN
3184: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
3185: END IF;
3186:
3187: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
3188: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
3184: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
3185: END IF;
3186:
3187: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
3188: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
3189: END IF;
3190:
3191:
3192: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
3189: END IF;
3190:
3191:
3192: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
3193: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
3194: END IF;
3195:
3196: IF p_x_line_rec.explosion_date IS NULL THEN
3197: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
3193: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
3194: END IF;
3195:
3196: IF p_x_line_rec.explosion_date IS NULL THEN
3197: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
3198: END IF;
3199:
3200: IF p_x_line_rec.fob_point_code IS NULL THEN
3201: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
3197: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
3198: END IF;
3199:
3200: IF p_x_line_rec.fob_point_code IS NULL THEN
3201: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
3202: END IF;
3203:
3204: IF p_x_line_rec.freight_carrier_code IS NULL THEN
3205: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
3201: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
3202: END IF;
3203:
3204: IF p_x_line_rec.freight_carrier_code IS NULL THEN
3205: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
3206: END IF;
3207:
3208: IF p_x_line_rec.freight_terms_code IS NULL THEN
3209: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3205: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
3206: END IF;
3207:
3208: IF p_x_line_rec.freight_terms_code IS NULL THEN
3209: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3210: END IF;
3211:
3212: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
3213: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
3209: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3210: END IF;
3211:
3212: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
3213: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
3214: END IF;
3215:
3216: IF p_x_line_rec.fulfilled_flag IS NULL THEN
3217: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3213: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
3214: END IF;
3215:
3216: IF p_x_line_rec.fulfilled_flag IS NULL THEN
3217: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3218: END IF;
3219:
3220: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
3221: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
3217: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3218: END IF;
3219:
3220: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
3221: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
3222: END IF;
3223:
3224: IF p_x_line_rec.fulfillment_date IS NULL THEN
3225: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
3221: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
3222: END IF;
3223:
3224: IF p_x_line_rec.fulfillment_date IS NULL THEN
3225: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
3226: END IF;
3227:
3228: IF p_x_line_rec.global_attribute1 IS NULL THEN
3229: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3225: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
3226: END IF;
3227:
3228: IF p_x_line_rec.global_attribute1 IS NULL THEN
3229: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3230: END IF;
3231:
3232: IF p_x_line_rec.global_attribute10 IS NULL THEN
3233: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
3229: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3230: END IF;
3231:
3232: IF p_x_line_rec.global_attribute10 IS NULL THEN
3233: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
3234: END IF;
3235:
3236: IF p_x_line_rec.global_attribute11 IS NULL THEN
3237: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3233: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
3234: END IF;
3235:
3236: IF p_x_line_rec.global_attribute11 IS NULL THEN
3237: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3238: END IF;
3239:
3240: IF p_x_line_rec.global_attribute12 IS NULL THEN
3241: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3237: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3238: END IF;
3239:
3240: IF p_x_line_rec.global_attribute12 IS NULL THEN
3241: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3242: END IF;
3243:
3244: IF p_x_line_rec.global_attribute13 IS NULL THEN
3245: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3241: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3242: END IF;
3243:
3244: IF p_x_line_rec.global_attribute13 IS NULL THEN
3245: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3246: END IF;
3247:
3248: IF p_x_line_rec.global_attribute14 IS NULL THEN
3249: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3245: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3246: END IF;
3247:
3248: IF p_x_line_rec.global_attribute14 IS NULL THEN
3249: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3250: END IF;
3251:
3252: IF p_x_line_rec.global_attribute15 IS NULL THEN
3253: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3249: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3250: END IF;
3251:
3252: IF p_x_line_rec.global_attribute15 IS NULL THEN
3253: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3254: END IF;
3255:
3256: IF p_x_line_rec.global_attribute16 IS NULL THEN
3257: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3253: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3254: END IF;
3255:
3256: IF p_x_line_rec.global_attribute16 IS NULL THEN
3257: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3258: END IF;
3259:
3260: IF p_x_line_rec.global_attribute17 IS NULL THEN
3261: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3257: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3258: END IF;
3259:
3260: IF p_x_line_rec.global_attribute17 IS NULL THEN
3261: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3262: END IF;
3263:
3264: IF p_x_line_rec.global_attribute18 IS NULL THEN
3265: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3261: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3262: END IF;
3263:
3264: IF p_x_line_rec.global_attribute18 IS NULL THEN
3265: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3266: END IF;
3267:
3268: IF p_x_line_rec.global_attribute19 IS NULL THEN
3269: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3265: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3266: END IF;
3267:
3268: IF p_x_line_rec.global_attribute19 IS NULL THEN
3269: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3270: END IF;
3271:
3272: IF p_x_line_rec.global_attribute2 IS NULL THEN
3273: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3269: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3270: END IF;
3271:
3272: IF p_x_line_rec.global_attribute2 IS NULL THEN
3273: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3274: END IF;
3275:
3276: IF p_x_line_rec.global_attribute20 IS NULL THEN
3277: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3273: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3274: END IF;
3275:
3276: IF p_x_line_rec.global_attribute20 IS NULL THEN
3277: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3278: END IF;
3279:
3280: IF p_x_line_rec.global_attribute3 IS NULL THEN
3281: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3277: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3278: END IF;
3279:
3280: IF p_x_line_rec.global_attribute3 IS NULL THEN
3281: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3282: END IF;
3283:
3284: IF p_x_line_rec.global_attribute4 IS NULL THEN
3285: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3281: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3282: END IF;
3283:
3284: IF p_x_line_rec.global_attribute4 IS NULL THEN
3285: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3286: END IF;
3287:
3288: IF p_x_line_rec.global_attribute5 IS NULL THEN
3289: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3285: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3286: END IF;
3287:
3288: IF p_x_line_rec.global_attribute5 IS NULL THEN
3289: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3290: END IF;
3291:
3292: IF p_x_line_rec.global_attribute6 IS NULL THEN
3293: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3289: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3290: END IF;
3291:
3292: IF p_x_line_rec.global_attribute6 IS NULL THEN
3293: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3294: END IF;
3295:
3296: IF p_x_line_rec.global_attribute7 IS NULL THEN
3297: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3293: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3294: END IF;
3295:
3296: IF p_x_line_rec.global_attribute7 IS NULL THEN
3297: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3298: END IF;
3299:
3300: IF p_x_line_rec.global_attribute8 IS NULL THEN
3301: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3297: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3298: END IF;
3299:
3300: IF p_x_line_rec.global_attribute8 IS NULL THEN
3301: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3302: END IF;
3303:
3304: IF p_x_line_rec.global_attribute9 IS NULL THEN
3305: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3301: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3302: END IF;
3303:
3304: IF p_x_line_rec.global_attribute9 IS NULL THEN
3305: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3306: END IF;
3307:
3308: IF p_x_line_rec.global_attribute_category IS NULL THEN
3309: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3305: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3306: END IF;
3307:
3308: IF p_x_line_rec.global_attribute_category IS NULL THEN
3309: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3310: END IF;
3311:
3312: IF p_x_line_rec.header_id IS NULL THEN
3313: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
3309: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3310: END IF;
3311:
3312: IF p_x_line_rec.header_id IS NULL THEN
3313: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
3314: END IF;
3315:
3316: IF p_x_line_rec.industry_attribute1 IS NULL THEN
3317: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
3313: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
3314: END IF;
3315:
3316: IF p_x_line_rec.industry_attribute1 IS NULL THEN
3317: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
3318: END IF;
3319:
3320: IF p_x_line_rec.industry_attribute10 IS NULL THEN
3321: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
3317: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
3318: END IF;
3319:
3320: IF p_x_line_rec.industry_attribute10 IS NULL THEN
3321: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
3322: END IF;
3323:
3324: IF p_x_line_rec.industry_attribute11 IS NULL THEN
3325: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
3321: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
3322: END IF;
3323:
3324: IF p_x_line_rec.industry_attribute11 IS NULL THEN
3325: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
3326: END IF;
3327:
3328: IF p_x_line_rec.industry_attribute12 IS NULL THEN
3329: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
3325: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
3326: END IF;
3327:
3328: IF p_x_line_rec.industry_attribute12 IS NULL THEN
3329: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
3330: END IF;
3331:
3332: IF p_x_line_rec.industry_attribute13 IS NULL THEN
3333: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
3329: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
3330: END IF;
3331:
3332: IF p_x_line_rec.industry_attribute13 IS NULL THEN
3333: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
3334: END IF;
3335:
3336: IF p_x_line_rec.industry_attribute14 IS NULL THEN
3337: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
3333: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
3334: END IF;
3335:
3336: IF p_x_line_rec.industry_attribute14 IS NULL THEN
3337: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
3338: END IF;
3339:
3340: IF p_x_line_rec.industry_attribute15 IS NULL THEN
3341: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
3337: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
3338: END IF;
3339:
3340: IF p_x_line_rec.industry_attribute15 IS NULL THEN
3341: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
3342: END IF;
3343:
3344: IF p_x_line_rec.industry_attribute16 IS NULL THEN
3345: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
3341: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
3342: END IF;
3343:
3344: IF p_x_line_rec.industry_attribute16 IS NULL THEN
3345: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
3346: END IF;
3347: IF p_x_line_rec.industry_attribute17 IS NULL THEN
3348: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
3349: END IF;
3344: IF p_x_line_rec.industry_attribute16 IS NULL THEN
3345: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
3346: END IF;
3347: IF p_x_line_rec.industry_attribute17 IS NULL THEN
3348: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
3349: END IF;
3350: IF p_x_line_rec.industry_attribute18 IS NULL THEN
3351: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
3352: END IF;
3347: IF p_x_line_rec.industry_attribute17 IS NULL THEN
3348: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
3349: END IF;
3350: IF p_x_line_rec.industry_attribute18 IS NULL THEN
3351: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
3352: END IF;
3353: IF p_x_line_rec.industry_attribute19 IS NULL THEN
3354: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
3355: END IF;
3350: IF p_x_line_rec.industry_attribute18 IS NULL THEN
3351: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
3352: END IF;
3353: IF p_x_line_rec.industry_attribute19 IS NULL THEN
3354: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
3355: END IF;
3356: IF p_x_line_rec.industry_attribute20 IS NULL THEN
3357: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
3358: END IF;
3353: IF p_x_line_rec.industry_attribute19 IS NULL THEN
3354: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
3355: END IF;
3356: IF p_x_line_rec.industry_attribute20 IS NULL THEN
3357: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
3358: END IF;
3359: IF p_x_line_rec.industry_attribute21 IS NULL THEN
3360: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
3361: END IF;
3356: IF p_x_line_rec.industry_attribute20 IS NULL THEN
3357: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
3358: END IF;
3359: IF p_x_line_rec.industry_attribute21 IS NULL THEN
3360: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
3361: END IF;
3362: IF p_x_line_rec.industry_attribute22 IS NULL THEN
3363: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
3364: END IF;
3359: IF p_x_line_rec.industry_attribute21 IS NULL THEN
3360: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
3361: END IF;
3362: IF p_x_line_rec.industry_attribute22 IS NULL THEN
3363: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
3364: END IF;
3365: IF p_x_line_rec.industry_attribute23 IS NULL THEN
3366: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
3367: END IF;
3362: IF p_x_line_rec.industry_attribute22 IS NULL THEN
3363: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
3364: END IF;
3365: IF p_x_line_rec.industry_attribute23 IS NULL THEN
3366: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
3367: END IF;
3368: IF p_x_line_rec.industry_attribute24 IS NULL THEN
3369: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
3370: END IF;
3365: IF p_x_line_rec.industry_attribute23 IS NULL THEN
3366: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
3367: END IF;
3368: IF p_x_line_rec.industry_attribute24 IS NULL THEN
3369: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
3370: END IF;
3371: IF p_x_line_rec.industry_attribute25 IS NULL THEN
3372: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
3373: END IF;
3368: IF p_x_line_rec.industry_attribute24 IS NULL THEN
3369: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
3370: END IF;
3371: IF p_x_line_rec.industry_attribute25 IS NULL THEN
3372: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
3373: END IF;
3374: IF p_x_line_rec.industry_attribute26 IS NULL THEN
3375: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
3376: END IF;
3371: IF p_x_line_rec.industry_attribute25 IS NULL THEN
3372: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
3373: END IF;
3374: IF p_x_line_rec.industry_attribute26 IS NULL THEN
3375: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
3376: END IF;
3377: IF p_x_line_rec.industry_attribute27 IS NULL THEN
3378: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
3379: END IF;
3374: IF p_x_line_rec.industry_attribute26 IS NULL THEN
3375: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
3376: END IF;
3377: IF p_x_line_rec.industry_attribute27 IS NULL THEN
3378: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
3379: END IF;
3380: IF p_x_line_rec.industry_attribute28 IS NULL THEN
3381: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
3382: END IF;
3377: IF p_x_line_rec.industry_attribute27 IS NULL THEN
3378: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
3379: END IF;
3380: IF p_x_line_rec.industry_attribute28 IS NULL THEN
3381: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
3382: END IF;
3383: IF p_x_line_rec.industry_attribute29 IS NULL THEN
3384: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
3385: END IF;
3380: IF p_x_line_rec.industry_attribute28 IS NULL THEN
3381: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
3382: END IF;
3383: IF p_x_line_rec.industry_attribute29 IS NULL THEN
3384: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
3385: END IF;
3386: IF p_x_line_rec.industry_attribute30 IS NULL THEN
3387: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
3388: END IF;
3383: IF p_x_line_rec.industry_attribute29 IS NULL THEN
3384: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
3385: END IF;
3386: IF p_x_line_rec.industry_attribute30 IS NULL THEN
3387: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
3388: END IF;
3389:
3390:
3391: IF p_x_line_rec.industry_attribute2 IS NULL THEN
3388: END IF;
3389:
3390:
3391: IF p_x_line_rec.industry_attribute2 IS NULL THEN
3392: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
3393: END IF;
3394:
3395: IF p_x_line_rec.industry_attribute3 IS NULL THEN
3396: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
3392: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
3393: END IF;
3394:
3395: IF p_x_line_rec.industry_attribute3 IS NULL THEN
3396: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
3397: END IF;
3398:
3399: IF p_x_line_rec.industry_attribute4 IS NULL THEN
3400: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
3396: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
3397: END IF;
3398:
3399: IF p_x_line_rec.industry_attribute4 IS NULL THEN
3400: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
3401: END IF;
3402:
3403: IF p_x_line_rec.industry_attribute5 IS NULL THEN
3404: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
3400: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
3401: END IF;
3402:
3403: IF p_x_line_rec.industry_attribute5 IS NULL THEN
3404: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
3405: END IF;
3406:
3407: IF p_x_line_rec.industry_attribute6 IS NULL THEN
3408: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
3404: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
3405: END IF;
3406:
3407: IF p_x_line_rec.industry_attribute6 IS NULL THEN
3408: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
3409: END IF;
3410:
3411: IF p_x_line_rec.industry_attribute7 IS NULL THEN
3412: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
3408: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
3409: END IF;
3410:
3411: IF p_x_line_rec.industry_attribute7 IS NULL THEN
3412: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
3413: END IF;
3414:
3415: IF p_x_line_rec.industry_attribute8 IS NULL THEN
3416: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
3412: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
3413: END IF;
3414:
3415: IF p_x_line_rec.industry_attribute8 IS NULL THEN
3416: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
3417: END IF;
3418:
3419: IF p_x_line_rec.industry_attribute9 IS NULL THEN
3420: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
3416: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
3417: END IF;
3418:
3419: IF p_x_line_rec.industry_attribute9 IS NULL THEN
3420: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
3421: END IF;
3422:
3423: IF p_x_line_rec.industry_context IS NULL THEN
3424: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
3420: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
3421: END IF;
3422:
3423: IF p_x_line_rec.industry_context IS NULL THEN
3424: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
3425: END IF;
3426:
3427: /* TP_ATTRIBUTE */
3428: IF p_x_line_rec.tp_context IS NULL THEN
3425: END IF;
3426:
3427: /* TP_ATTRIBUTE */
3428: IF p_x_line_rec.tp_context IS NULL THEN
3429: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3430: END IF;
3431: IF p_x_line_rec.tp_attribute1 IS NULL THEN
3432: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3433: END IF;
3428: IF p_x_line_rec.tp_context IS NULL THEN
3429: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3430: END IF;
3431: IF p_x_line_rec.tp_attribute1 IS NULL THEN
3432: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3433: END IF;
3434: IF p_x_line_rec.tp_attribute2 IS NULL THEN
3435: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3436: END IF;
3431: IF p_x_line_rec.tp_attribute1 IS NULL THEN
3432: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3433: END IF;
3434: IF p_x_line_rec.tp_attribute2 IS NULL THEN
3435: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3436: END IF;
3437: IF p_x_line_rec.tp_attribute3 IS NULL THEN
3438: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3439: END IF;
3434: IF p_x_line_rec.tp_attribute2 IS NULL THEN
3435: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3436: END IF;
3437: IF p_x_line_rec.tp_attribute3 IS NULL THEN
3438: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3439: END IF;
3440: IF p_x_line_rec.tp_attribute4 IS NULL THEN
3441: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3442: END IF;
3437: IF p_x_line_rec.tp_attribute3 IS NULL THEN
3438: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3439: END IF;
3440: IF p_x_line_rec.tp_attribute4 IS NULL THEN
3441: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3442: END IF;
3443: IF p_x_line_rec.tp_attribute5 IS NULL THEN
3444: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3445: END IF;
3440: IF p_x_line_rec.tp_attribute4 IS NULL THEN
3441: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3442: END IF;
3443: IF p_x_line_rec.tp_attribute5 IS NULL THEN
3444: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3445: END IF;
3446: IF p_x_line_rec.tp_attribute6 IS NULL THEN
3447: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3448: END IF;
3443: IF p_x_line_rec.tp_attribute5 IS NULL THEN
3444: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3445: END IF;
3446: IF p_x_line_rec.tp_attribute6 IS NULL THEN
3447: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3448: END IF;
3449: IF p_x_line_rec.tp_attribute7 IS NULL THEN
3450: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3451: END IF;
3446: IF p_x_line_rec.tp_attribute6 IS NULL THEN
3447: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3448: END IF;
3449: IF p_x_line_rec.tp_attribute7 IS NULL THEN
3450: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3451: END IF;
3452: IF p_x_line_rec.tp_attribute8 IS NULL THEN
3453: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3454: END IF;
3449: IF p_x_line_rec.tp_attribute7 IS NULL THEN
3450: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3451: END IF;
3452: IF p_x_line_rec.tp_attribute8 IS NULL THEN
3453: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3454: END IF;
3455: IF p_x_line_rec.tp_attribute9 IS NULL THEN
3456: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3457: END IF;
3452: IF p_x_line_rec.tp_attribute8 IS NULL THEN
3453: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3454: END IF;
3455: IF p_x_line_rec.tp_attribute9 IS NULL THEN
3456: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3457: END IF;
3458: IF p_x_line_rec.tp_attribute10 IS NULL THEN
3459: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3460: END IF;
3455: IF p_x_line_rec.tp_attribute9 IS NULL THEN
3456: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3457: END IF;
3458: IF p_x_line_rec.tp_attribute10 IS NULL THEN
3459: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3460: END IF;
3461: IF p_x_line_rec.tp_attribute11 IS NULL THEN
3462: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3463: END IF;
3458: IF p_x_line_rec.tp_attribute10 IS NULL THEN
3459: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3460: END IF;
3461: IF p_x_line_rec.tp_attribute11 IS NULL THEN
3462: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3463: END IF;
3464: IF p_x_line_rec.tp_attribute12 IS NULL THEN
3465: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3466: END IF;
3461: IF p_x_line_rec.tp_attribute11 IS NULL THEN
3462: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3463: END IF;
3464: IF p_x_line_rec.tp_attribute12 IS NULL THEN
3465: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3466: END IF;
3467: IF p_x_line_rec.tp_attribute13 IS NULL THEN
3468: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3469: END IF;
3464: IF p_x_line_rec.tp_attribute12 IS NULL THEN
3465: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3466: END IF;
3467: IF p_x_line_rec.tp_attribute13 IS NULL THEN
3468: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3469: END IF;
3470: IF p_x_line_rec.tp_attribute14 IS NULL THEN
3471: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3472: END IF;
3467: IF p_x_line_rec.tp_attribute13 IS NULL THEN
3468: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3469: END IF;
3470: IF p_x_line_rec.tp_attribute14 IS NULL THEN
3471: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3472: END IF;
3473: IF p_x_line_rec.tp_attribute15 IS NULL THEN
3474: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3475: END IF;
3470: IF p_x_line_rec.tp_attribute14 IS NULL THEN
3471: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3472: END IF;
3473: IF p_x_line_rec.tp_attribute15 IS NULL THEN
3474: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3475: END IF;
3476:
3477:
3478: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
3475: END IF;
3476:
3477:
3478: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
3479: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
3480: END IF;
3481:
3482: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
3483: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
3479: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
3480: END IF;
3481:
3482: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
3483: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
3484: END IF;
3485:
3486: IF p_x_line_rec.inventory_item_id IS NULL THEN
3487: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
3483: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
3484: END IF;
3485:
3486: IF p_x_line_rec.inventory_item_id IS NULL THEN
3487: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
3488: END IF;
3489:
3490: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
3491: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
3487: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
3488: END IF;
3489:
3490: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
3491: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
3492: END IF;
3493:
3494:
3495:
3493:
3494:
3495:
3496: IF p_x_line_rec.invoice_to_contact_id IS NULL THEN
3497: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3498: END IF;
3499:
3500: IF p_x_line_rec.invoiced_quantity IS NULL THEN
3501: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
3497: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3498: END IF;
3499:
3500: IF p_x_line_rec.invoiced_quantity IS NULL THEN
3501: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
3502: END IF;
3503:
3504: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
3505: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3501: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
3502: END IF;
3503:
3504: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
3505: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3506: END IF;
3507:
3508: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
3509: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3505: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3506: END IF;
3507:
3508: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
3509: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3510: END IF;
3511:
3512: IF p_x_line_rec.ordered_item_id IS NULL THEN
3513: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
3509: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3510: END IF;
3511:
3512: IF p_x_line_rec.ordered_item_id IS NULL THEN
3513: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
3514: END IF;
3515:
3516: IF p_x_line_rec.item_identifier_type IS NULL THEN
3517: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
3513: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
3514: END IF;
3515:
3516: IF p_x_line_rec.item_identifier_type IS NULL THEN
3517: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
3518: END IF;
3519:
3520: IF p_x_line_rec.ordered_item IS NULL THEN
3521: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
3517: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
3518: END IF;
3519:
3520: IF p_x_line_rec.ordered_item IS NULL THEN
3521: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
3522: END IF;
3523:
3524: IF p_x_line_rec.item_revision IS NULL THEN
3525: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
3521: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
3522: END IF;
3523:
3524: IF p_x_line_rec.item_revision IS NULL THEN
3525: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
3526: END IF;
3527:
3528: IF p_x_line_rec.item_type_code IS NULL THEN
3529: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3525: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
3526: END IF;
3527:
3528: IF p_x_line_rec.item_type_code IS NULL THEN
3529: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3530: END IF;
3531:
3532: IF p_x_line_rec.last_updated_by IS NULL THEN
3533: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
3529: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3530: END IF;
3531:
3532: IF p_x_line_rec.last_updated_by IS NULL THEN
3533: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
3534: END IF;
3535:
3536: IF p_x_line_rec.last_update_date IS NULL THEN
3537: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
3533: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
3534: END IF;
3535:
3536: IF p_x_line_rec.last_update_date IS NULL THEN
3537: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
3538: END IF;
3539:
3540: IF p_x_line_rec.last_update_login IS NULL THEN
3541: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
3537: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
3538: END IF;
3539:
3540: IF p_x_line_rec.last_update_login IS NULL THEN
3541: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
3542: END IF;
3543:
3544: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
3545: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
3541: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
3542: END IF;
3543:
3544: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
3545: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
3546: END IF;
3547:
3548: IF p_x_line_rec.line_category_code IS NULL THEN
3549: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
3545: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
3546: END IF;
3547:
3548: IF p_x_line_rec.line_category_code IS NULL THEN
3549: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
3550: END IF;
3551:
3552: IF p_x_line_rec.line_id IS NULL THEN
3553: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
3549: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
3550: END IF;
3551:
3552: IF p_x_line_rec.line_id IS NULL THEN
3553: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
3554: END IF;
3555:
3556: IF p_x_line_rec.line_number IS NULL THEN
3557: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
3553: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
3554: END IF;
3555:
3556: IF p_x_line_rec.line_number IS NULL THEN
3557: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
3558: END IF;
3559:
3560: IF p_x_line_rec.line_type_id IS NULL THEN
3561: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
3557: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
3558: END IF;
3559:
3560: IF p_x_line_rec.line_type_id IS NULL THEN
3561: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
3562: END IF;
3563:
3564: IF p_x_line_rec.link_to_line_id IS NULL THEN
3565: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
3561: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
3562: END IF;
3563:
3564: IF p_x_line_rec.link_to_line_id IS NULL THEN
3565: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
3566: END IF;
3567:
3568: IF p_x_line_rec.model_group_number IS NULL THEN
3569: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
3565: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
3566: END IF;
3567:
3568: IF p_x_line_rec.model_group_number IS NULL THEN
3569: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
3570: END IF;
3571:
3572: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
3573: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
3569: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
3570: END IF;
3571:
3572: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
3573: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
3574: END IF;
3575:
3576: IF p_x_line_rec.mfg_lead_time IS NULL THEN
3577: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
3573: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
3574: END IF;
3575:
3576: IF p_x_line_rec.mfg_lead_time IS NULL THEN
3577: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
3578: END IF;
3579:
3580: IF p_x_line_rec.open_flag IS NULL THEN
3581: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
3577: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
3578: END IF;
3579:
3580: IF p_x_line_rec.open_flag IS NULL THEN
3581: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
3582: END IF;
3583:
3584: IF p_x_line_rec.option_flag IS NULL THEN
3585: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
3581: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
3582: END IF;
3583:
3584: IF p_x_line_rec.option_flag IS NULL THEN
3585: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
3586: END IF;
3587:
3588: IF p_x_line_rec.option_number IS NULL THEN
3589: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
3585: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
3586: END IF;
3587:
3588: IF p_x_line_rec.option_number IS NULL THEN
3589: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
3590: END IF;
3591:
3592: IF p_x_line_rec.ordered_quantity IS NULL THEN
3593: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
3589: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
3590: END IF;
3591:
3592: IF p_x_line_rec.ordered_quantity IS NULL THEN
3593: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
3594: END IF;
3595:
3596: IF p_x_line_rec.order_quantity_uom IS NULL THEN
3597: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
3593: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
3594: END IF;
3595:
3596: IF p_x_line_rec.order_quantity_uom IS NULL THEN
3597: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
3598: END IF;
3599:
3600: -- OPM 02/JUN/00 - Deal with process attributes
3601: -- IS===========================================
3599:
3600: -- OPM 02/JUN/00 - Deal with process attributes
3601: -- IS===========================================
3602: IF p_x_line_rec.ordered_quantity2 IS NULL THEN
3603: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
3604: END IF;
3605:
3606: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
3607: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
3604: END IF;
3605:
3606: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
3607: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
3608: END IF;
3609: -- OPM 02/JUN/00 - END
3610: -- IS==================
3611:
3609: -- OPM 02/JUN/00 - END
3610: -- IS==================
3611:
3612: IF p_x_line_rec.org_id IS NULL THEN
3613: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
3614: END IF;
3615:
3616: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
3617: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
3614: END IF;
3615:
3616: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
3617: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
3618: END IF;
3619:
3620: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
3621: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
3618: END IF;
3619:
3620: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
3621: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
3622: END IF;
3623:
3624: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
3625: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
3622: END IF;
3623:
3624: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
3625: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
3626: END IF;
3627:
3628: IF p_x_line_rec.original_list_price IS NULL THEN
3629: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
3625: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
3626: END IF;
3627:
3628: IF p_x_line_rec.original_list_price IS NULL THEN
3629: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
3630: END IF;
3631:
3632: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
3633: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
3629: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
3630: END IF;
3631:
3632: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
3633: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
3634: END IF;
3635: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
3636: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
3637: END IF;
3632: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
3633: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
3634: END IF;
3635: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
3636: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
3637: END IF;
3638:
3639: IF p_x_line_rec.payment_term_id IS NULL THEN
3640: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3636: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
3637: END IF;
3638:
3639: IF p_x_line_rec.payment_term_id IS NULL THEN
3640: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3641: END IF;
3642:
3643: IF p_x_line_rec.planning_priority IS NULL THEN
3644: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
3640: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3641: END IF;
3642:
3643: IF p_x_line_rec.planning_priority IS NULL THEN
3644: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
3645: END IF;
3646:
3647: -- OPM 02/JUN/00 - Deal with process attributes
3648: -- IS===========================================
3646:
3647: -- OPM 02/JUN/00 - Deal with process attributes
3648: -- IS===========================================
3649: IF p_x_line_rec.preferred_grade IS NULL THEN
3650: p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
3651: END IF;
3652: -- OPM 02/JUN/00 - END
3653: -- IS==================
3654:
3652: -- OPM 02/JUN/00 - END
3653: -- IS==================
3654:
3655: IF p_x_line_rec.price_list_id IS NULL THEN
3656: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3657: END IF;
3658:
3659: IF p_x_line_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
3660: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
3656: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3657: END IF;
3658:
3659: IF p_x_line_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
3660: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
3661: END IF;
3662:
3663: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
3664: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
3660: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
3661: END IF;
3662:
3663: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
3664: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
3665: END IF;
3666:
3667: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
3668: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
3664: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
3665: END IF;
3666:
3667: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
3668: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
3669: END IF;
3670:
3671: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
3672: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
3668: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
3669: END IF;
3670:
3671: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
3672: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
3673: END IF;
3674:
3675: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
3676: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
3672: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
3673: END IF;
3674:
3675: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
3676: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
3677: END IF;
3678:
3679: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
3680: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
3676: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
3677: END IF;
3678:
3679: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
3680: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
3681: END IF;
3682:
3683: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
3684: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
3680: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
3681: END IF;
3682:
3683: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
3684: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
3685: END IF;
3686:
3687: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
3688: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
3684: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
3685: END IF;
3686:
3687: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
3688: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
3689: END IF;
3690:
3691: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
3692: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
3688: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
3689: END IF;
3690:
3691: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
3692: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
3693: END IF;
3694:
3695: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
3696: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
3692: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
3693: END IF;
3694:
3695: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
3696: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
3697: END IF;
3698:
3699: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
3700: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
3696: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
3697: END IF;
3698:
3699: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
3700: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
3701: END IF;
3702:
3703: IF p_x_line_rec.pricing_context IS NULL THEN
3704: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
3701: END IF;
3702:
3703: IF p_x_line_rec.pricing_context IS NULL THEN
3704: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
3705: END IF;
3706:
3707: IF p_x_line_rec.pricing_date IS NULL THEN
3708: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
3704: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
3705: END IF;
3706:
3707: IF p_x_line_rec.pricing_date IS NULL THEN
3708: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
3709: END IF;
3710:
3711: IF p_x_line_rec.pricing_quantity IS NULL THEN
3712: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
3708: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
3709: END IF;
3710:
3711: IF p_x_line_rec.pricing_quantity IS NULL THEN
3712: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
3713: END IF;
3714:
3715: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
3716: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
3713: END IF;
3714:
3715: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
3716: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
3717: END IF;
3718:
3719: IF p_x_line_rec.program_application_id IS NULL THEN
3720: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
3716: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
3717: END IF;
3718:
3719: IF p_x_line_rec.program_application_id IS NULL THEN
3720: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
3721: END IF;
3722:
3723: IF p_x_line_rec.program_id IS NULL THEN
3724: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
3720: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
3721: END IF;
3722:
3723: IF p_x_line_rec.program_id IS NULL THEN
3724: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
3725: END IF;
3726:
3727: IF p_x_line_rec.program_update_date IS NULL THEN
3728: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
3724: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
3725: END IF;
3726:
3727: IF p_x_line_rec.program_update_date IS NULL THEN
3728: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
3729: END IF;
3730:
3731: IF p_x_line_rec.project_id IS NULL THEN
3732: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3728: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
3729: END IF;
3730:
3731: IF p_x_line_rec.project_id IS NULL THEN
3732: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3733: END IF;
3734:
3735: IF p_x_line_rec.promise_date IS NULL THEN
3736: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
3732: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3733: END IF;
3734:
3735: IF p_x_line_rec.promise_date IS NULL THEN
3736: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
3737: END IF;
3738:
3739: IF p_x_line_rec.re_source_flag IS NULL THEN
3740: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
3736: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
3737: END IF;
3738:
3739: IF p_x_line_rec.re_source_flag IS NULL THEN
3740: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
3741: END IF;
3742:
3743: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
3744: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
3740: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
3741: END IF;
3742:
3743: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
3744: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
3745: END IF;
3746:
3747: IF p_x_line_rec.reference_header_id IS NULL THEN
3748: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
3744: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
3745: END IF;
3746:
3747: IF p_x_line_rec.reference_header_id IS NULL THEN
3748: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
3749: END IF;
3750:
3751: IF p_x_line_rec.reference_line_id IS NULL THEN
3752: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
3748: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
3749: END IF;
3750:
3751: IF p_x_line_rec.reference_line_id IS NULL THEN
3752: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
3753: END IF;
3754:
3755: IF p_x_line_rec.reference_type IS NULL THEN
3756: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
3752: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
3753: END IF;
3754:
3755: IF p_x_line_rec.reference_type IS NULL THEN
3756: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
3757: END IF;
3758:
3759:
3760:
3758:
3759:
3760:
3761: IF p_x_line_rec.request_date IS NULL THEN
3762: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
3763: END IF;
3764:
3765: IF p_x_line_rec.request_id IS NULL THEN
3766: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
3762: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
3763: END IF;
3764:
3765: IF p_x_line_rec.request_id IS NULL THEN
3766: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
3767: END IF;
3768:
3769: IF p_x_line_rec.return_attribute1 IS NULL THEN
3770: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
3766: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
3767: END IF;
3768:
3769: IF p_x_line_rec.return_attribute1 IS NULL THEN
3770: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
3771: END IF;
3772:
3773: IF p_x_line_rec.return_attribute10 IS NULL THEN
3774: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
3770: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
3771: END IF;
3772:
3773: IF p_x_line_rec.return_attribute10 IS NULL THEN
3774: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
3775: END IF;
3776:
3777: IF p_x_line_rec.return_attribute11 IS NULL THEN
3778: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
3774: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
3775: END IF;
3776:
3777: IF p_x_line_rec.return_attribute11 IS NULL THEN
3778: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
3779: END IF;
3780:
3781: IF p_x_line_rec.return_attribute12 IS NULL THEN
3782: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
3778: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
3779: END IF;
3780:
3781: IF p_x_line_rec.return_attribute12 IS NULL THEN
3782: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
3783: END IF;
3784:
3785: IF p_x_line_rec.return_attribute13 IS NULL THEN
3786: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
3782: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
3783: END IF;
3784:
3785: IF p_x_line_rec.return_attribute13 IS NULL THEN
3786: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
3787: END IF;
3788:
3789: IF p_x_line_rec.return_attribute14 IS NULL THEN
3790: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
3786: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
3787: END IF;
3788:
3789: IF p_x_line_rec.return_attribute14 IS NULL THEN
3790: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
3791: END IF;
3792:
3793: IF p_x_line_rec.return_attribute15 IS NULL THEN
3794: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
3791: END IF;
3792:
3793: IF p_x_line_rec.return_attribute15 IS NULL THEN
3794: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
3795: END IF;
3796:
3797: IF p_x_line_rec.return_attribute2 IS NULL THEN
3798: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
3795: END IF;
3796:
3797: IF p_x_line_rec.return_attribute2 IS NULL THEN
3798: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
3799: END IF;
3800:
3801: IF p_x_line_rec.return_attribute3 IS NULL THEN
3802: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
3799: END IF;
3800:
3801: IF p_x_line_rec.return_attribute3 IS NULL THEN
3802: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
3803: END IF;
3804:
3805: IF p_x_line_rec.return_attribute4 IS NULL THEN
3806: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
3802: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
3803: END IF;
3804:
3805: IF p_x_line_rec.return_attribute4 IS NULL THEN
3806: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
3807: END IF;
3808:
3809: IF p_x_line_rec.return_attribute5 IS NULL THEN
3810: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
3806: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
3807: END IF;
3808:
3809: IF p_x_line_rec.return_attribute5 IS NULL THEN
3810: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
3811: END IF;
3812:
3813: IF p_x_line_rec.return_attribute6 IS NULL THEN
3814: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
3810: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
3811: END IF;
3812:
3813: IF p_x_line_rec.return_attribute6 IS NULL THEN
3814: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
3815: END IF;
3816:
3817: IF p_x_line_rec.return_attribute7 IS NULL THEN
3818: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
3814: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
3815: END IF;
3816:
3817: IF p_x_line_rec.return_attribute7 IS NULL THEN
3818: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
3819: END IF;
3820:
3821: IF p_x_line_rec.return_attribute8 IS NULL THEN
3822: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
3818: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
3819: END IF;
3820:
3821: IF p_x_line_rec.return_attribute8 IS NULL THEN
3822: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
3823: END IF;
3824:
3825: IF p_x_line_rec.return_attribute9 IS NULL THEN
3826: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
3822: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
3823: END IF;
3824:
3825: IF p_x_line_rec.return_attribute9 IS NULL THEN
3826: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
3827: END IF;
3828:
3829: IF p_x_line_rec.return_context IS NULL THEN
3830: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
3826: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
3827: END IF;
3828:
3829: IF p_x_line_rec.return_context IS NULL THEN
3830: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
3831: END IF;
3832: IF p_x_line_rec.return_reason_code IS NULL THEN
3833: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3834: END IF;
3829: IF p_x_line_rec.return_context IS NULL THEN
3830: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
3831: END IF;
3832: IF p_x_line_rec.return_reason_code IS NULL THEN
3833: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3834: END IF;
3835: IF p_x_line_rec.salesrep_id IS NULL THEN
3836: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3837: END IF;
3832: IF p_x_line_rec.return_reason_code IS NULL THEN
3833: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3834: END IF;
3835: IF p_x_line_rec.salesrep_id IS NULL THEN
3836: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3837: END IF;
3838:
3839: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
3840: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
3836: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3837: END IF;
3838:
3839: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
3840: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
3841: END IF;
3842:
3843: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
3844: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
3840: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
3841: END IF;
3842:
3843: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
3844: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
3845: END IF;
3846:
3847: IF p_x_line_rec.schedule_ship_date IS NULL THEN
3848: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
3844: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
3845: END IF;
3846:
3847: IF p_x_line_rec.schedule_ship_date IS NULL THEN
3848: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
3849: END IF;
3850:
3851: IF p_x_line_rec.schedule_action_code IS NULL THEN
3852: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
3848: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
3849: END IF;
3850:
3851: IF p_x_line_rec.schedule_action_code IS NULL THEN
3852: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
3853: END IF;
3854:
3855: IF p_x_line_rec.schedule_status_code IS NULL THEN
3856: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
3852: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
3853: END IF;
3854:
3855: IF p_x_line_rec.schedule_status_code IS NULL THEN
3856: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
3857: END IF;
3858:
3859: IF p_x_line_rec.shipment_number IS NULL THEN
3860: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
3856: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
3857: END IF;
3858:
3859: IF p_x_line_rec.shipment_number IS NULL THEN
3860: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
3861: END IF;
3862:
3863: IF p_x_line_rec.shipment_priority_code IS NULL THEN
3864: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3860: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
3861: END IF;
3862:
3863: IF p_x_line_rec.shipment_priority_code IS NULL THEN
3864: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3865: END IF;
3866:
3867: IF p_x_line_rec.shipped_quantity IS NULL THEN
3868: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
3864: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3865: END IF;
3866:
3867: IF p_x_line_rec.shipped_quantity IS NULL THEN
3868: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
3869: END IF;
3870:
3871: IF p_x_line_rec.shipped_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
3872: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
3868: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
3869: END IF;
3870:
3871: IF p_x_line_rec.shipped_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
3872: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
3873: END IF;
3874:
3875: IF p_x_line_rec.shipping_method_code IS NULL THEN
3876: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3872: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
3873: END IF;
3874:
3875: IF p_x_line_rec.shipping_method_code IS NULL THEN
3876: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3877: END IF;
3878:
3879: IF p_x_line_rec.shipping_quantity IS NULL THEN
3880: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
3876: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3877: END IF;
3878:
3879: IF p_x_line_rec.shipping_quantity IS NULL THEN
3880: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
3881: END IF;
3882:
3883: IF p_x_line_rec.shipping_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
3884: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
3880: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
3881: END IF;
3882:
3883: IF p_x_line_rec.shipping_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
3884: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
3885: END IF;
3886:
3887: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
3888: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
3884: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
3885: END IF;
3886:
3887: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
3888: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
3889: END IF;
3890:
3891: IF p_x_line_rec.ship_from_org_id IS NULL THEN
3892: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3888: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
3889: END IF;
3890:
3891: IF p_x_line_rec.ship_from_org_id IS NULL THEN
3892: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3893: END IF;
3894:
3895: IF p_x_line_rec.subinventory IS NULL THEN
3896: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
3892: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3893: END IF;
3894:
3895: IF p_x_line_rec.subinventory IS NULL THEN
3896: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
3897: END IF;
3898:
3899: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
3900: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
3896: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
3897: END IF;
3898:
3899: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
3900: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
3901: END IF;
3902:
3903: IF p_x_line_rec.ship_set_id IS NULL THEN
3904: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
3900: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
3901: END IF;
3902:
3903: IF p_x_line_rec.ship_set_id IS NULL THEN
3904: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
3905: END IF;
3906:
3907: -- Start: Fix of 8530507
3908: -------------------
3918: FROM oe_order_lines_all l
3919: WHERE l.line_id = p_x_line_rec.line_id;
3920: oe_debug_pub.ADD(' cnv line null to miss: l_old_ship_set = ' || l_old_ship_set_id);
3921:
3922: IF Nvl(l_old_ship_set_id, Fnd_Api.G_Miss_Num) <> Fnd_Api.G_Miss_Num
3923: THEN
3924: -- The line has already been a part of shipset. The user really
3925: -- intended to remove it from the shipset, if at all they had set
3926: -- p_x_line_rec.ship_set to a NULL. Explicitly check for this case
3944: -- Stamp the derived ship_set_id on p_x_line_rec.ship_set_id
3945: p_x_line_rec.ship_set_id := l_old_ship_set_id;
3946: -- 10171747
3947: ELSE -- that is, when p_x_line_rec.ship_set is null.
3948: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3949: -- 10171747
3950: END IF;
3951: END IF; -- Check on l_old_ship_set_id
3952: EXCEPTION
3951: END IF; -- Check on l_old_ship_set_id
3952: EXCEPTION
3953: WHEN Others THEN
3954: IF p_x_line_rec.ship_set_id IS NULL THEN
3955: p_x_line_rec.ship_set_id := fnd_api.g_miss_num;
3956: END IF;
3957: -- 10171747
3958: IF p_x_line_rec.ship_set IS NULL THEN
3959: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3955: p_x_line_rec.ship_set_id := fnd_api.g_miss_num;
3956: END IF;
3957: -- 10171747
3958: IF p_x_line_rec.ship_set IS NULL THEN
3959: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3960: END IF;
3961: -- 10171747
3962: oe_debug_pub.ADD('Exception occurred at OEXUGNIB Loc 4: ' || SQLERRM);
3963: END;
3963: END;
3964: ELSE -- For entity operations other than UPDATE.
3965: oe_debug_pub.ADD(' cnv line null to miss: Location 5...');
3966: IF p_x_line_rec.ship_set_id IS NULL THEN
3967: p_x_line_rec.ship_set_id := Fnd_Api.G_Miss_Num;
3968: END IF;
3969: -- 10171747
3970: IF p_x_line_rec.ship_set IS NULL THEN
3971: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3967: p_x_line_rec.ship_set_id := Fnd_Api.G_Miss_Num;
3968: END IF;
3969: -- 10171747
3970: IF p_x_line_rec.ship_set IS NULL THEN
3971: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3972: END IF;
3973: -- 10171747
3974: END IF; -- Operation code check for UPDATE.
3975: -------------------
3994: AND l.line_id = p_x_line_rec.line_id;
3995:
3996: -- If existing value and incoming value are same, set it to miss char
3997: IF l_old_ship_set = p_x_line_rec.ship_set THEN
3998: p_x_line_rec.ship_set := Fnd_Api.G_Miss_Char;
3999: END IF;
4000:
4001: EXCEPTION
4002: -- If there is no ship set before and incoming value is also null
4002: -- If there is no ship set before and incoming value is also null
4003: -- set it to miss Char
4004: WHEN Others THEN -- including NO_DATA_FOUND
4005: IF p_x_line_rec.ship_set IS NULL THEN
4006: p_x_line_rec.ship_set := fnd_api.g_miss_Char;
4007: END IF;
4008: END;
4009: END IF; -- Additional operation code check for UPDATE.
4010: */
4012: -- End: 9874630 Fix
4013:
4014:
4015: IF p_x_line_rec.ship_tolerance_above IS NULL THEN
4016: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
4017: END IF;
4018:
4019: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
4020: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
4016: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
4017: END IF;
4018:
4019: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
4020: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
4021: END IF;
4022:
4023: IF p_x_line_rec.shippable_flag IS NULL THEN
4024: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
4020: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
4021: END IF;
4022:
4023: IF p_x_line_rec.shippable_flag IS NULL THEN
4024: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
4025: END IF;
4026:
4027: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
4028: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
4024: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
4025: END IF;
4026:
4027: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
4028: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
4029: END IF;
4030:
4031: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
4032: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
4028: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
4029: END IF;
4030:
4031: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
4032: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
4033: END IF;
4034:
4035: IF p_x_line_rec.ship_to_org_id IS NULL THEN
4036: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
4032: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
4033: END IF;
4034:
4035: IF p_x_line_rec.ship_to_org_id IS NULL THEN
4036: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
4037: END IF;
4038:
4039: IF p_x_line_rec.sold_from_org_id IS NULL THEN
4040: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
4036: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
4037: END IF;
4038:
4039: IF p_x_line_rec.sold_from_org_id IS NULL THEN
4040: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
4041: END IF;
4042:
4043: IF p_x_line_rec.sold_to_org_id IS NULL THEN
4044: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
4040: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
4041: END IF;
4042:
4043: IF p_x_line_rec.sold_to_org_id IS NULL THEN
4044: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
4045: END IF;
4046:
4047: IF p_x_line_rec.sort_order IS NULL THEN
4048: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
4044: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
4045: END IF;
4046:
4047: IF p_x_line_rec.sort_order IS NULL THEN
4048: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
4049: END IF;
4050:
4051: IF p_x_line_rec.source_document_id IS NULL THEN
4052: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
4048: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
4049: END IF;
4050:
4051: IF p_x_line_rec.source_document_id IS NULL THEN
4052: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
4053: END IF;
4054:
4055: IF p_x_line_rec.source_document_line_id IS NULL THEN
4056: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
4052: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
4053: END IF;
4054:
4055: IF p_x_line_rec.source_document_line_id IS NULL THEN
4056: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
4057: END IF;
4058:
4059: IF p_x_line_rec.source_document_type_id IS NULL THEN
4060: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
4056: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
4057: END IF;
4058:
4059: IF p_x_line_rec.source_document_type_id IS NULL THEN
4060: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
4061: END IF;
4062:
4063: IF p_x_line_rec.source_type_code IS NULL THEN
4064: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
4060: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
4061: END IF;
4062:
4063: IF p_x_line_rec.source_type_code IS NULL THEN
4064: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
4065: END IF;
4066: IF p_x_line_rec.split_from_line_id IS NULL THEN
4067: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
4068: END IF;
4063: IF p_x_line_rec.source_type_code IS NULL THEN
4064: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
4065: END IF;
4066: IF p_x_line_rec.split_from_line_id IS NULL THEN
4067: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
4068: END IF;
4069: IF p_x_line_rec.line_set_id IS NULL THEN
4070: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
4071: END IF;
4066: IF p_x_line_rec.split_from_line_id IS NULL THEN
4067: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
4068: END IF;
4069: IF p_x_line_rec.line_set_id IS NULL THEN
4070: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
4071: END IF;
4072:
4073: IF p_x_line_rec.split_by IS NULL THEN
4074: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
4070: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
4071: END IF;
4072:
4073: IF p_x_line_rec.split_by IS NULL THEN
4074: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
4075: END IF;
4076: IF p_x_line_rec.model_remnant_flag IS NULL THEN
4077: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
4078: END IF;
4073: IF p_x_line_rec.split_by IS NULL THEN
4074: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
4075: END IF;
4076: IF p_x_line_rec.model_remnant_flag IS NULL THEN
4077: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
4078: END IF;
4079: IF p_x_line_rec.task_id IS NULL THEN
4080: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
4081: END IF;
4076: IF p_x_line_rec.model_remnant_flag IS NULL THEN
4077: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
4078: END IF;
4079: IF p_x_line_rec.task_id IS NULL THEN
4080: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
4081: END IF;
4082:
4083: IF p_x_line_rec.tax_code IS NULL THEN
4084: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
4080: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
4081: END IF;
4082:
4083: IF p_x_line_rec.tax_code IS NULL THEN
4084: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
4085: END IF;
4086:
4087: IF p_x_line_rec.tax_date IS NULL THEN
4088: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
4084: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
4085: END IF;
4086:
4087: IF p_x_line_rec.tax_date IS NULL THEN
4088: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
4089: END IF;
4090:
4091: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
4092: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
4088: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
4089: END IF;
4090:
4091: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
4092: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
4093: END IF;
4094:
4095: IF p_x_line_rec.tax_exempt_number IS NULL THEN
4096: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
4092: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
4093: END IF;
4094:
4095: IF p_x_line_rec.tax_exempt_number IS NULL THEN
4096: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
4097: END IF;
4098:
4099: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
4100: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
4096: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
4097: END IF;
4098:
4099: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
4100: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
4101: END IF;
4102:
4103: IF p_x_line_rec.tax_point_code IS NULL THEN
4104: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
4100: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
4101: END IF;
4102:
4103: IF p_x_line_rec.tax_point_code IS NULL THEN
4104: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
4105: END IF;
4106:
4107: IF p_x_line_rec.tax_rate IS NULL THEN
4108: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
4104: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
4105: END IF;
4106:
4107: IF p_x_line_rec.tax_rate IS NULL THEN
4108: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
4109: END IF;
4110:
4111: IF p_x_line_rec.tax_value IS NULL THEN
4112: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
4108: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
4109: END IF;
4110:
4111: IF p_x_line_rec.tax_value IS NULL THEN
4112: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
4113: END IF;
4114:
4115: IF p_x_line_rec.top_model_line_id IS NULL THEN
4116: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
4112: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
4113: END IF;
4114:
4115: IF p_x_line_rec.top_model_line_id IS NULL THEN
4116: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
4117: END IF;
4118:
4119: IF p_x_line_rec.unit_list_price IS NULL THEN
4120: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
4116: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
4117: END IF;
4118:
4119: IF p_x_line_rec.unit_list_price IS NULL THEN
4120: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
4121: END IF;
4122:
4123: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
4124: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
4120: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
4121: END IF;
4122:
4123: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
4124: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
4125: END IF;
4126:
4127: IF p_x_line_rec.unit_selling_price IS NULL THEN
4128: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
4124: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
4125: END IF;
4126:
4127: IF p_x_line_rec.unit_selling_price IS NULL THEN
4128: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
4129: END IF;
4130:
4131: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
4132: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
4128: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
4129: END IF;
4130:
4131: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
4132: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
4133: END IF;
4134:
4135:
4136: IF p_x_line_rec.visible_demand_flag IS NULL THEN
4133: END IF;
4134:
4135:
4136: IF p_x_line_rec.visible_demand_flag IS NULL THEN
4137: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
4138: END IF;
4139: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
4140: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
4141: END IF;
4136: IF p_x_line_rec.visible_demand_flag IS NULL THEN
4137: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
4138: END IF;
4139: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
4140: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
4141: END IF;
4142:
4143: IF p_x_line_rec.first_ack_code IS NULL THEN
4144: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
4140: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
4141: END IF;
4142:
4143: IF p_x_line_rec.first_ack_code IS NULL THEN
4144: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
4145: END IF;
4146:
4147: IF p_x_line_rec.first_ack_date IS NULL THEN
4148: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
4144: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
4145: END IF;
4146:
4147: IF p_x_line_rec.first_ack_date IS NULL THEN
4148: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
4149: END IF;
4150:
4151: IF p_x_line_rec.last_ack_code IS NULL THEN
4152: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
4148: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
4149: END IF;
4150:
4151: IF p_x_line_rec.last_ack_code IS NULL THEN
4152: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
4153: END IF;
4154:
4155: IF p_x_line_rec.last_ack_date IS NULL THEN
4156: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
4152: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
4153: END IF;
4154:
4155: IF p_x_line_rec.last_ack_date IS NULL THEN
4156: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
4157: END IF;
4158:
4159:
4160: IF p_x_line_rec.end_item_unit_number IS NULL THEN
4157: END IF;
4158:
4159:
4160: IF p_x_line_rec.end_item_unit_number IS NULL THEN
4161: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
4162: END IF;
4163:
4164: IF p_x_line_rec.shipping_instructions IS NULL THEN
4165: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
4161: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
4162: END IF;
4163:
4164: IF p_x_line_rec.shipping_instructions IS NULL THEN
4165: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
4166: END IF;
4167:
4168: IF p_x_line_rec.packing_instructions IS NULL THEN
4169: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
4165: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
4166: END IF;
4167:
4168: IF p_x_line_rec.packing_instructions IS NULL THEN
4169: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
4170: END IF;
4171:
4172: -- Service related columns
4173:
4171:
4172: -- Service related columns
4173:
4174: IF p_x_line_rec.service_txn_reason_code IS NULL THEN
4175: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
4176: END IF;
4177:
4178: IF p_x_line_rec.service_txn_comments IS NULL THEN
4179: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
4175: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
4176: END IF;
4177:
4178: IF p_x_line_rec.service_txn_comments IS NULL THEN
4179: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
4180: END IF;
4181:
4182: IF p_x_line_rec.service_duration IS NULL THEN
4183: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
4179: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
4180: END IF;
4181:
4182: IF p_x_line_rec.service_duration IS NULL THEN
4183: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
4184: END IF;
4185:
4186: IF p_x_line_rec.service_period IS NULL THEN
4187: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
4183: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
4184: END IF;
4185:
4186: IF p_x_line_rec.service_period IS NULL THEN
4187: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
4188: END IF;
4189:
4190: IF p_x_line_rec.service_start_date IS NULL THEN
4191: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
4187: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
4188: END IF;
4189:
4190: IF p_x_line_rec.service_start_date IS NULL THEN
4191: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
4192: END IF;
4193:
4194: IF p_x_line_rec.service_end_date IS NULL THEN
4195: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
4191: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
4192: END IF;
4193:
4194: IF p_x_line_rec.service_end_date IS NULL THEN
4195: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
4196: END IF;
4197:
4198: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
4199: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
4195: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
4196: END IF;
4197:
4198: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
4199: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
4200: END IF;
4201:
4202:
4203: IF p_x_line_rec.unit_list_percent IS NULL THEN
4200: END IF;
4201:
4202:
4203: IF p_x_line_rec.unit_list_percent IS NULL THEN
4204: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
4205: END IF;
4206:
4207: IF p_x_line_rec.unit_selling_percent IS NULL THEN
4208: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
4204: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
4205: END IF;
4206:
4207: IF p_x_line_rec.unit_selling_percent IS NULL THEN
4208: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
4209: END IF;
4210:
4211: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
4212: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
4208: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
4209: END IF;
4210:
4211: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
4212: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
4213: END IF;
4214:
4215: IF p_x_line_rec.service_number IS NULL THEN
4216: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
4212: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
4213: END IF;
4214:
4215: IF p_x_line_rec.service_number IS NULL THEN
4216: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
4217: END IF;
4218:
4219: IF p_x_line_rec.service_reference_type_code IS NULL THEN
4220: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
4216: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
4217: END IF;
4218:
4219: IF p_x_line_rec.service_reference_type_code IS NULL THEN
4220: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
4221: END IF;
4222:
4223: IF p_x_line_rec.service_reference_line_id IS NULL THEN
4224: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
4220: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
4221: END IF;
4222:
4223: IF p_x_line_rec.service_reference_line_id IS NULL THEN
4224: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
4225: END IF;
4226:
4227: IF p_x_line_rec.service_reference_system_id IS NULL THEN
4228: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
4224: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
4225: END IF;
4226:
4227: IF p_x_line_rec.service_reference_system_id IS NULL THEN
4228: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
4229: END IF;
4230:
4231: /* Marketing source code related */
4232:
4230:
4231: /* Marketing source code related */
4232:
4233: IF p_x_line_rec.marketing_source_code_id IS NULL THEN
4234: p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
4235: END IF;
4236:
4237: /* End of Marketing source code related */
4238:
4236:
4237: /* End of Marketing source code related */
4238:
4239: IF p_x_line_rec.order_source_id IS NULL THEN
4240: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
4241: END IF;
4242:
4243: IF p_x_line_rec.flow_status_code IS NULL THEN
4244: p_x_line_rec.flow_status_code := 'ENTERED'; -- bug 15963000
4245: END IF;
4246:
4247: -- Commitment related
4248: IF p_x_line_rec.commitment_id IS NULL THEN
4249: p_x_line_rec.commitment_id := FND_API.G_MISS_NUM;
4250: END IF;
4251:
4252:
4253: -- Item Substitution changes.
4251:
4252:
4253: -- Item Substitution changes.
4254: IF p_x_line_rec.Original_Inventory_Item_Id IS NULL THEN
4255: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
4256: END IF;
4257:
4258: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
4259: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
4255: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
4256: END IF;
4257:
4258: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
4259: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
4260: END IF;
4261:
4262: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
4263: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
4259: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
4260: END IF;
4261:
4262: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
4263: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
4264: END IF;
4265:
4266: IF p_x_line_rec.Original_ordered_item IS NULL THEN
4267: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
4263: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
4264: END IF;
4265:
4266: IF p_x_line_rec.Original_ordered_item IS NULL THEN
4267: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
4268: END IF;
4269:
4270: IF p_x_line_rec.item_relationship_type IS NULL THEN
4271: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
4267: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
4268: END IF;
4269:
4270: IF p_x_line_rec.item_relationship_type IS NULL THEN
4271: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
4272: END IF;
4273:
4274: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
4275: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
4271: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
4272: END IF;
4273:
4274: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
4275: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
4276: END IF;
4277:
4278: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
4279: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
4275: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
4276: END IF;
4277:
4278: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
4279: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
4280: END IF;
4281:
4282: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
4283: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
4279: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
4280: END IF;
4281:
4282: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
4283: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
4284: END IF;
4285:
4286: -- Changes for Blanket Orders
4287:
4285:
4286: -- Changes for Blanket Orders
4287:
4288: IF p_x_line_rec.Blanket_Number IS NULL THEN
4289: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
4290: END IF;
4291:
4292: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
4293: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
4289: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
4290: END IF;
4291:
4292: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
4293: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
4294: END IF;
4295:
4296: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
4297: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
4293: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
4294: END IF;
4295:
4296: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
4297: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
4298: END IF;
4299:
4300: -- QUOTING changes
4301: IF p_x_line_rec.transaction_phase_code IS NULL THEN
4298: END IF;
4299:
4300: -- QUOTING changes
4301: IF p_x_line_rec.transaction_phase_code IS NULL THEN
4302: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
4303: END IF;
4304:
4305: IF p_x_line_rec.source_document_version_number IS NULL THEN
4306: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
4302: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
4303: END IF;
4304:
4305: IF p_x_line_rec.source_document_version_number IS NULL THEN
4306: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
4307: END IF;
4308: -- END QUOTING changes
4309: IF p_x_line_rec.Minisite_id IS NULL THEN
4310: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
4306: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
4307: END IF;
4308: -- END QUOTING changes
4309: IF p_x_line_rec.Minisite_id IS NULL THEN
4310: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
4311: END IF;
4312:
4313: IF p_x_line_rec.End_customer_id IS NULL THEN
4314: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
4310: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
4311: END IF;
4312:
4313: IF p_x_line_rec.End_customer_id IS NULL THEN
4314: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
4315: END IF;
4316:
4317: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
4318: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4314: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
4315: END IF;
4316:
4317: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
4318: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4319: END IF;
4320:
4321: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
4322: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4318: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4319: END IF;
4320:
4321: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
4322: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4323: END IF;
4324:
4325: IF p_x_line_rec.ib_owner IS NULL THEN
4326: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
4322: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4323: END IF;
4324:
4325: IF p_x_line_rec.ib_owner IS NULL THEN
4326: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
4327: END IF;
4328:
4329: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
4330: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
4326: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
4327: END IF;
4328:
4329: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
4330: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
4331: END IF;
4332:
4333: IF p_x_line_rec.ib_current_location IS NULL THEN
4334: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
4330: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
4331: END IF;
4332:
4333: IF p_x_line_rec.ib_current_location IS NULL THEN
4334: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
4335: END IF;
4336:
4337: --retro{
4338: IF p_x_line_rec.retrobill_request_id IS NULL THEN
4335: END IF;
4336:
4337: --retro{
4338: IF p_x_line_rec.retrobill_request_id IS NULL THEN
4339: p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
4340: END IF;
4341: --retro}
4342:
4343: IF p_x_line_rec.firm_demand_flag IS NULL THEN
4340: END IF;
4341: --retro}
4342:
4343: IF p_x_line_rec.firm_demand_flag IS NULL THEN
4344: p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
4345: END IF;
4346:
4347: --key Transaction Dates
4348: IF p_x_line_rec.order_firmed_date IS NULL THEN
4345: END IF;
4346:
4347: --key Transaction Dates
4348: IF p_x_line_rec.order_firmed_date IS NULL THEN
4349: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
4350: END IF;
4351:
4352: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
4353: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
4349: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
4350: END IF;
4351:
4352: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
4353: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
4354: END IF;
4355: --end
4356:
4357: /* IF p_x_line_rec.supplier_signature IS NULL THEN
4354: END IF;
4355: --end
4356:
4357: /* IF p_x_line_rec.supplier_signature IS NULL THEN
4358: p_x_line_rec.supplier_signature := FND_API.G_MISS_CHAR;
4359: END IF;
4360:
4361: IF p_x_line_rec.supplier_signature_date IS NULL THEN
4362: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4358: p_x_line_rec.supplier_signature := FND_API.G_MISS_CHAR;
4359: END IF;
4360:
4361: IF p_x_line_rec.supplier_signature_date IS NULL THEN
4362: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4363: END IF;
4364:
4365: IF p_x_line_rec.customer_signature IS NULL THEN
4366: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
4362: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4363: END IF;
4364:
4365: IF p_x_line_rec.customer_signature IS NULL THEN
4366: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
4367: END IF;
4368:
4369: IF p_x_line_rec.customer_signature_date IS NULL THEN
4370: p_x_line_rec.customer_signature_date := FND_API.G_MISS_CHAR;
4366: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
4367: END IF;
4368:
4369: IF p_x_line_rec.customer_signature_date IS NULL THEN
4370: p_x_line_rec.customer_signature_date := FND_API.G_MISS_CHAR;
4371: END IF;
4372: */
4373:
4374: --
4376: --
4377: -- Customer Acceptance Related Fields
4378: --
4379: IF p_x_line_rec.CONTINGENCY_ID IS NULL THEN
4380: p_x_line_rec.CONTINGENCY_ID := Fnd_Api.G_Miss_Num;
4381: END IF;
4382:
4383: IF p_x_line_rec.REVREC_EVENT_CODE IS NULL THEN
4384: p_x_line_rec.REVREC_EVENT_CODE := Fnd_Api.G_Miss_Char;
4380: p_x_line_rec.CONTINGENCY_ID := Fnd_Api.G_Miss_Num;
4381: END IF;
4382:
4383: IF p_x_line_rec.REVREC_EVENT_CODE IS NULL THEN
4384: p_x_line_rec.REVREC_EVENT_CODE := Fnd_Api.G_Miss_Char;
4385: END IF;
4386:
4387: IF p_x_line_rec.REVREC_EXPIRATION_DAYS IS NULL THEN
4388: p_x_line_rec.REVREC_EXPIRATION_DAYS := Fnd_Api.G_Miss_Num;
4384: p_x_line_rec.REVREC_EVENT_CODE := Fnd_Api.G_Miss_Char;
4385: END IF;
4386:
4387: IF p_x_line_rec.REVREC_EXPIRATION_DAYS IS NULL THEN
4388: p_x_line_rec.REVREC_EXPIRATION_DAYS := Fnd_Api.G_Miss_Num;
4389: END IF;
4390:
4391: IF p_x_line_rec.ACCEPTED_QUANTITY IS NULL THEN
4392: p_x_line_rec.ACCEPTED_QUANTITY := Fnd_Api.G_Miss_Num;
4388: p_x_line_rec.REVREC_EXPIRATION_DAYS := Fnd_Api.G_Miss_Num;
4389: END IF;
4390:
4391: IF p_x_line_rec.ACCEPTED_QUANTITY IS NULL THEN
4392: p_x_line_rec.ACCEPTED_QUANTITY := Fnd_Api.G_Miss_Num;
4393: END IF;
4394:
4395: IF p_x_line_rec.ACCEPTED_BY IS NULL THEN
4396: p_x_line_rec.ACCEPTED_BY := Fnd_Api.G_Miss_Num;
4392: p_x_line_rec.ACCEPTED_QUANTITY := Fnd_Api.G_Miss_Num;
4393: END IF;
4394:
4395: IF p_x_line_rec.ACCEPTED_BY IS NULL THEN
4396: p_x_line_rec.ACCEPTED_BY := Fnd_Api.G_Miss_Num;
4397: END IF;
4398:
4399: IF p_x_line_rec.REVREC_COMMENTS IS NULL THEN
4400: p_x_line_rec.REVREC_COMMENTS := Fnd_Api.G_Miss_Char;
4396: p_x_line_rec.ACCEPTED_BY := Fnd_Api.G_Miss_Num;
4397: END IF;
4398:
4399: IF p_x_line_rec.REVREC_COMMENTS IS NULL THEN
4400: p_x_line_rec.REVREC_COMMENTS := Fnd_Api.G_Miss_Char;
4401: END IF;
4402:
4403: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT IS NULL THEN
4404: p_x_line_rec.REVREC_REFERENCE_DOCUMENT := Fnd_Api.G_Miss_Char;
4400: p_x_line_rec.REVREC_COMMENTS := Fnd_Api.G_Miss_Char;
4401: END IF;
4402:
4403: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT IS NULL THEN
4404: p_x_line_rec.REVREC_REFERENCE_DOCUMENT := Fnd_Api.G_Miss_Char;
4405: END IF;
4406:
4407: IF p_x_line_rec.REVREC_SIGNATURE IS NULL THEN
4408: p_x_line_rec.REVREC_SIGNATURE := Fnd_Api.G_Miss_Char;
4404: p_x_line_rec.REVREC_REFERENCE_DOCUMENT := Fnd_Api.G_Miss_Char;
4405: END IF;
4406:
4407: IF p_x_line_rec.REVREC_SIGNATURE IS NULL THEN
4408: p_x_line_rec.REVREC_SIGNATURE := Fnd_Api.G_Miss_Char;
4409: END IF;
4410:
4411: IF p_x_line_rec.REVREC_SIGNATURE_DATE IS NULL THEN
4412: p_x_line_rec.REVREC_SIGNATURE_DATE := Fnd_Api.G_Miss_Date;
4408: p_x_line_rec.REVREC_SIGNATURE := Fnd_Api.G_Miss_Char;
4409: END IF;
4410:
4411: IF p_x_line_rec.REVREC_SIGNATURE_DATE IS NULL THEN
4412: p_x_line_rec.REVREC_SIGNATURE_DATE := Fnd_Api.G_Miss_Date;
4413: END IF;
4414:
4415: IF p_x_line_rec.REVREC_IMPLICIT_FLAG IS NULL THEN
4416: p_x_line_rec.REVREC_IMPLICIT_FLAG := Fnd_Api.G_Miss_Char;
4412: p_x_line_rec.REVREC_SIGNATURE_DATE := Fnd_Api.G_Miss_Date;
4413: END IF;
4414:
4415: IF p_x_line_rec.REVREC_IMPLICIT_FLAG IS NULL THEN
4416: p_x_line_rec.REVREC_IMPLICIT_FLAG := Fnd_Api.G_Miss_Char;
4417: END IF;
4418: --
4419: -- Customer Acceptance Related Fields
4420: --
4420: --
4421:
4422: -- New attributes added for DOO Integration
4423: IF p_x_line_rec.bypass_sch_flag IS NULL THEN
4424: p_x_line_rec.bypass_sch_flag := Fnd_Api.G_Miss_Char;
4425: END IF;
4426:
4427: IF p_x_line_rec. pre_exploded_flag IS NULL THEN
4428: p_x_line_rec. pre_exploded_flag := Fnd_Api.G_Miss_Char;
4424: p_x_line_rec.bypass_sch_flag := Fnd_Api.G_Miss_Char;
4425: END IF;
4426:
4427: IF p_x_line_rec. pre_exploded_flag IS NULL THEN
4428: p_x_line_rec. pre_exploded_flag := Fnd_Api.G_Miss_Char;
4429: END IF;
4430:
4431: if l_debug_level > 0 then
4432: oe_debug_pub.add('Exiting OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);