DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_ITEM_PUB

Line 1974: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

1970: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
1971: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
1972: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
1973: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
1974: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
1975: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
1976: l_dyn_sql := l_dyn_sql || ') ';
1977:
1978: Write_Debug(l_dyn_sql);

Line 1983: l_dyn_sql := l_dyn_sql || ' SET MSII.PRIMARY_UOM_CODE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

1979: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
1980:
1981: -- populating MSII with PRIMARY_UOM_CODE if special char for null out exists
1982: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
1983: l_dyn_sql := l_dyn_sql || ' SET MSII.PRIMARY_UOM_CODE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
1984: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
1985: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
1986: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
1987: l_dyn_sql := l_dyn_sql || '( ';

Line 1992: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

1988: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
1989: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
1990: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
1991: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
1992: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
1993: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
1994: l_dyn_sql := l_dyn_sql || ') ';
1995:
1996: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2047: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2043: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2044: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2045: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2046: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2047: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2048: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2049: l_dyn_sql := l_dyn_sql || ') ';
2050:
2051: Write_Debug(l_dyn_sql);

Line 2055: l_dyn_sql := l_dyn_sql || ' SET MSII.ITEM_TYPE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2051: Write_Debug(l_dyn_sql);
2052: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2053:
2054: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2055: l_dyn_sql := l_dyn_sql || ' SET MSII.ITEM_TYPE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2056: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2057: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2058: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2059: l_dyn_sql := l_dyn_sql || '( ';

Line 2064: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2060: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2061: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2062: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2063: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2064: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2065: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2066: l_dyn_sql := l_dyn_sql || ') ';
2067:
2068: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2099: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2095: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2096: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2097: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2098: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2099: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2100: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2101: l_dyn_sql := l_dyn_sql || ') ';
2102:
2103: Write_Debug(l_dyn_sql);

Line 2107: l_dyn_sql := l_dyn_sql || ' SET MSII.BOM_ITEM_TYPE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2103: Write_Debug(l_dyn_sql);
2104: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2105:
2106: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2107: l_dyn_sql := l_dyn_sql || ' SET MSII.BOM_ITEM_TYPE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2108: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2109: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2110: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2111: l_dyn_sql := l_dyn_sql || '( ';

Line 2116: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2112: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2113: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2114: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2115: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2116: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2117: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2118: l_dyn_sql := l_dyn_sql || ') ';
2119:
2120: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2145: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2141: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2142: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2143: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2144: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2145: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2146: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2147: l_dyn_sql := l_dyn_sql || ') ';
2148:
2149: Write_Debug(l_dyn_sql);

Line 2153: l_dyn_sql := l_dyn_sql || ' SET MSII.TRADE_ITEM_DESCRIPTOR = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2149: Write_Debug(l_dyn_sql);
2150: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2151:
2152: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2153: l_dyn_sql := l_dyn_sql || ' SET MSII.TRADE_ITEM_DESCRIPTOR = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2154: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2155: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2156: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2157: l_dyn_sql := l_dyn_sql || '( ';

Line 2162: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2158: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2159: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2160: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2161: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2162: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2163: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2164: l_dyn_sql := l_dyn_sql || ') ';
2165:
2166: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2197: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2193: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2194: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2195: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2196: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2197: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2198: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2199: l_dyn_sql := l_dyn_sql || ') ';
2200:
2201: Write_Debug(l_dyn_sql);

Line 2205: l_dyn_sql := l_dyn_sql || ' SET MSII.ENG_ITEM_FLAG = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2201: Write_Debug(l_dyn_sql);
2202: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2203:
2204: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2205: l_dyn_sql := l_dyn_sql || ' SET MSII.ENG_ITEM_FLAG = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2206: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2207: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2208: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2209: l_dyn_sql := l_dyn_sql || '( ';

Line 2214: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2210: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2211: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2212: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2213: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2214: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2215: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2216: l_dyn_sql := l_dyn_sql || ') ';
2217:
2218: Write_Debug(l_dyn_sql);

Line 2251: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2247: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2248: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2249: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2250: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2251: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2252: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2253: l_dyn_sql := l_dyn_sql || ') ';
2254:
2255: Write_Debug(l_dyn_sql);

Line 2268: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2264: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2265: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2266: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2267: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2268: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2269: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2270: l_dyn_sql := l_dyn_sql || ') ';
2271:
2272: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

Line 2272: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

2268: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2269: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2270: l_dyn_sql := l_dyn_sql || ') ';
2271:
2272: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;
2273: Write_Debug('MSII: Updated the Conversions.');
2274:
2275: ----------------------------------------------------------------------------------
2276: -- Transfer the Conversions attribute information from EBI to MSII

Line 2303: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2299: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2300: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2301: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2302: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2303: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2304: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2305: l_dyn_sql := l_dyn_sql || ') ';
2306:
2307: Write_Debug(l_dyn_sql);

Line 2320: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2316: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2317: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2318: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2319: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2320: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2321: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2322: l_dyn_sql := l_dyn_sql || ') ';
2323:
2324: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

Line 2324: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

2320: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2321: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2322: l_dyn_sql := l_dyn_sql || ') ';
2323:
2324: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;
2325: Write_Debug('MSII: Updated the Conversions.');
2326:
2327: ----------------------------------------------------------------------------------
2328: -- Transfer the Conversions attribute information from EBI to MSII

Line 2355: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2351: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2352: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2353: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2354: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2355: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2356: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2357: l_dyn_sql := l_dyn_sql || ') ';
2358:
2359: Write_Debug(l_dyn_sql);

Line 2372: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2368: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2369: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2370: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2371: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2372: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2373: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2374: l_dyn_sql := l_dyn_sql || ') ';
2375:
2376: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

Line 2376: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

2372: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2373: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2374: l_dyn_sql := l_dyn_sql || ') ';
2375:
2376: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;
2377: Write_Debug('MSII: Updated the Conversions.');
2378:
2379: ----------------------------------------------------------------------------------
2380: -- Transfer the Conversions attribute information from EBI to MSII

Line 2406: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2402: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2403: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2404: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2405: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2406: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2407: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2408: l_dyn_sql := l_dyn_sql || ') ';
2409:
2410: Write_Debug(l_dyn_sql);

Line 2414: l_dyn_sql := l_dyn_sql || ' SET MSII.SECONDARY_UOM_CODE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2410: Write_Debug(l_dyn_sql);
2411: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2412:
2413: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2414: l_dyn_sql := l_dyn_sql || ' SET MSII.SECONDARY_UOM_CODE = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2415: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2416: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2417: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2418: l_dyn_sql := l_dyn_sql || '( ';

Line 2423: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2419: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2420: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2421: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2422: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2423: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2424: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2425: l_dyn_sql := l_dyn_sql || ') ';
2426:
2427: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2458: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2454: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2455: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2456: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2457: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2458: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2459: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2460: l_dyn_sql := l_dyn_sql || ') ';
2461:
2462: Write_Debug(l_dyn_sql);

Line 2466: l_dyn_sql := l_dyn_sql || ' SET MSII.TRACKING_QUANTITY_IND = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2462: Write_Debug(l_dyn_sql);
2463: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2464:
2465: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2466: l_dyn_sql := l_dyn_sql || ' SET MSII.TRACKING_QUANTITY_IND = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2467: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2468: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2469: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2470: l_dyn_sql := l_dyn_sql || '( ';

Line 2475: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2471: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2472: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2473: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2474: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2475: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2476: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2477: l_dyn_sql := l_dyn_sql || ') ';
2478:
2479: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2509: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2505: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2506: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2507: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2508: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2509: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2510: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2511: l_dyn_sql := l_dyn_sql || ') ';
2512:
2513: Write_Debug(l_dyn_sql);

Line 2517: l_dyn_sql := l_dyn_sql || ' SET MSII.TRACKING_QUANTITY_IND = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2513: Write_Debug(l_dyn_sql);
2514: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
2515:
2516: l_dyn_sql := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII ';
2517: l_dyn_sql := l_dyn_sql || ' SET MSII.TRACKING_QUANTITY_IND = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2518: l_dyn_sql := l_dyn_sql || ' WHERE MSII.SET_PROCESS_ID = ' || l_msii_set_process_id;
2519: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG = ' || G_PROCESS_STATUS;
2520: l_dyn_sql := l_dyn_sql || ' AND EXISTS ';
2521: l_dyn_sql := l_dyn_sql || '( ';

Line 2526: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2522: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2523: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2524: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2525: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2526: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2527: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2528: l_dyn_sql := l_dyn_sql || ') ';
2529:
2530: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;

Line 2696: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_col_val||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2692: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2693: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2694: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2695: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_col_val||' IS NOT NULL';
2696: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_col_val||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2697: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2698: l_dyn_sql := l_dyn_sql || ') ';
2699:
2700: Write_Debug(l_dyn_sql);

Line 2713: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_col_val||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2709: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2710: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2711: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2712: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2713: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_col_val||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2714: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2715: l_dyn_sql := l_dyn_sql || ') ';
2716:
2717: Write_Debug(l_dyn_sql);

Line 2718: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

2714: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2715: l_dyn_sql := l_dyn_sql || ') ';
2716:
2717: Write_Debug(l_dyn_sql);
2718: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;
2719:
2720: Write_Debug('MSII: Updated the Lifecycle IDs.');
2721:
2722: END IF; --end: IF (l_lifecycle_col_val IS NOT NULL ...

Line 2750: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2746: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2747: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2748: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2749: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' IS NOT NULL';
2750: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' <> '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2751: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2752: l_dyn_sql := l_dyn_sql || ') ';
2753:
2754: Write_Debug(l_dyn_sql);

Line 2767: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';

2763: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
2764: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2765: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2766: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2767: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2768: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2769: l_dyn_sql := l_dyn_sql || ') ';
2770:
2771: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

Line 2771: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;

2767: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_lifecycle_phase_col_val||' = '''||EGO_ITEM_PUB.G_INTF_NULL_CHAR||'''';
2768: l_dyn_sql := l_dyn_sql || ' AND EBI.PROCESS_STATUS = 1 ';
2769: l_dyn_sql := l_dyn_sql || ') ';
2770:
2771: EXECUTE IMMEDIATE l_dyn_sql USING EGO_ITEM_PUB.G_INTF_NULL_NUM, p_resultfmt_usage_id;
2772: Write_Debug('MSII: Updated the Lifecycle Phase IDs.');
2773:
2774: END IF; --end: IF (l_lifecycle_phase_col_val IS NOT NULL ...
2775:

Line 2781: SET start_date_active = DECODE(start_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,start_date_active),

2777: --
2778: -- convert all date fields values from Excel Null to INTF Null
2779: --
2780: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2781: SET start_date_active = DECODE(start_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,start_date_active),
2782: end_date_active = DECODE(end_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,end_date_active),
2783: engineering_date = DECODE(engineering_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,engineering_date)
2784: WHERE MSII.SET_PROCESS_ID = l_msii_set_process_id
2785: AND MSII.PROCESS_FLAG = G_PROCESS_STATUS

Line 2782: end_date_active = DECODE(end_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,end_date_active),

2778: -- convert all date fields values from Excel Null to INTF Null
2779: --
2780: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2781: SET start_date_active = DECODE(start_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,start_date_active),
2782: end_date_active = DECODE(end_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,end_date_active),
2783: engineering_date = DECODE(engineering_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,engineering_date)
2784: WHERE MSII.SET_PROCESS_ID = l_msii_set_process_id
2785: AND MSII.PROCESS_FLAG = G_PROCESS_STATUS
2786: AND (MSII.start_date_active IS NOT NULL

Line 2783: engineering_date = DECODE(engineering_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,engineering_date)

2779: --
2780: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2781: SET start_date_active = DECODE(start_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,start_date_active),
2782: end_date_active = DECODE(end_date_active,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,end_date_active),
2783: engineering_date = DECODE(engineering_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,engineering_date)
2784: WHERE MSII.SET_PROCESS_ID = l_msii_set_process_id
2785: AND MSII.PROCESS_FLAG = G_PROCESS_STATUS
2786: AND (MSII.start_date_active IS NOT NULL
2787: OR

Line 4099: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),

4095: --
4096: -- convert all date fields values from Excel Null to INTF Null
4097: --
4098: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
4099: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),
4100: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),
4101: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)
4102: WHERE MIRI.TRANSACTION_ID IN
4103: ( SELECT EBI.TRANSACTION_ID

Line 4100: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),

4096: -- convert all date fields values from Excel Null to INTF Null
4097: --
4098: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
4099: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),
4100: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),
4101: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)
4102: WHERE MIRI.TRANSACTION_ID IN
4103: ( SELECT EBI.TRANSACTION_ID
4104: FROM EGO_BULKLOAD_INTF EBI

Line 4101: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)

4097: --
4098: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
4099: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),
4100: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),
4101: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)
4102: WHERE MIRI.TRANSACTION_ID IN
4103: ( SELECT EBI.TRANSACTION_ID
4104: FROM EGO_BULKLOAD_INTF EBI
4105: WHERE EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id

Line 5185: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,EGO_ITEM_PUB.G_INTF_NULL_CHAR) <> EGO_ITEM_PUB.G_INTF_NULL_CHAR) THEN

5181:
5182: ------------------------------------------------------------------------
5183: -- Populate l_varchar_data, to later populate in ATTR_DISP_VALUE
5184: ------------------------------------------------------------------------
5185: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,EGO_ITEM_PUB.G_INTF_NULL_CHAR) <> EGO_ITEM_PUB.G_INTF_NULL_CHAR) THEN
5186: -- l_varchar_data := l_usr_attr_data_tbl(i).ATTR_VALUE_STR;
5187: -- ELSE
5188: -- l_varchar_data := NULL;
5189: -- END IF;

Line 5191: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,EGO_ITEM_PUB.G_INTF_NULL_CHAR) <> EGO_ITEM_PUB.G_INTF_NULL_CHAR ) THEN

5187: -- ELSE
5188: -- l_varchar_data := NULL;
5189: -- END IF;
5190: IF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'C') THEN
5191: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,EGO_ITEM_PUB.G_INTF_NULL_CHAR) <> EGO_ITEM_PUB.G_INTF_NULL_CHAR ) THEN
5192: l_varchar_data := NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,l_usr_attr_data_tbl(i).ATTR_DISP_VALUE);
5193: -- END IF;
5194: ELSIF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'N') THEN
5195: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM,EGO_ITEM_PUB.G_INTF_NULL_NUM) <> EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN

Line 5195: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM,EGO_ITEM_PUB.G_INTF_NULL_NUM) <> EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN

5191: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,EGO_ITEM_PUB.G_INTF_NULL_CHAR) <> EGO_ITEM_PUB.G_INTF_NULL_CHAR ) THEN
5192: l_varchar_data := NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_STR,l_usr_attr_data_tbl(i).ATTR_DISP_VALUE);
5193: -- END IF;
5194: ELSIF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'N') THEN
5195: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM,EGO_ITEM_PUB.G_INTF_NULL_NUM) <> EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN
5196: l_varchar_data := NVL(To_char(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM),l_usr_attr_data_tbl(i).ATTR_DISP_VALUE);
5197: BEGIN
5198: IF (TO_NUMBER(l_varchar_data) = EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN
5199: l_varchar_data := EGO_USER_ATTRS_BULK_PVT.G_NULL_NUM_VAL_STR;

Line 5198: IF (TO_NUMBER(l_varchar_data) = EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN

5194: ELSIF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'N') THEN
5195: -- IF (NVL(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM,EGO_ITEM_PUB.G_INTF_NULL_NUM) <> EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN
5196: l_varchar_data := NVL(To_char(l_usr_attr_data_tbl(i).ATTR_VALUE_NUM),l_usr_attr_data_tbl(i).ATTR_DISP_VALUE);
5197: BEGIN
5198: IF (TO_NUMBER(l_varchar_data) = EGO_ITEM_PUB.G_INTF_NULL_NUM) THEN
5199: l_varchar_data := EGO_USER_ATTRS_BULK_PVT.G_NULL_NUM_VAL_STR;
5200: END IF;
5201: EXCEPTION
5202: WHEN OTHERS THEN

Line 5210: l_varchar_data := To_Char(EGO_ITEM_PUB.G_INTF_NULL_DATE,G_DATE_FORMAT);

5206: Write_Debug(l_api_name || 'l_varchar_data => ' || l_varchar_data);
5207: -- END IF;
5208: ELSIF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'D') THEN
5209: IF (l_usr_attr_data_tbl(i).ATTR_VALUE_DATE = G_EXCEL_NULL_DATE) THEN
5210: l_varchar_data := To_Char(EGO_ITEM_PUB.G_INTF_NULL_DATE,G_DATE_FORMAT);
5211: ELSE
5212: l_varchar_data := NVL(To_Char(l_usr_attr_data_tbl(i).ATTR_VALUE_DATE , G_DATE_FORMAT),l_usr_attr_data_tbl(i).ATTR_DISP_VALUE);
5213: END IF;
5214: END IF; --end: IF (l_usr_attr_data_tbl(i).ATTR_DATATYPE_CODE = 'C') THEN

Line 5811: l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR THEN

5807: );
5808:
5809: IF l_attr_disp_val_table(i) IS NOT NULL AND l_attr_int_val_table(i) IS NULL THEN
5810: IF l_attr_metadata_obj.data_type_code = 'C' AND
5811: l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR THEN
5812: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5813: ELSIF l_attr_metadata_obj.data_type_code = 'N' THEN
5814: BEGIN
5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR

Line 5812: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

5808:
5809: IF l_attr_disp_val_table(i) IS NOT NULL AND l_attr_int_val_table(i) IS NULL THEN
5810: IF l_attr_metadata_obj.data_type_code = 'C' AND
5811: l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR THEN
5812: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5813: ELSIF l_attr_metadata_obj.data_type_code = 'N' THEN
5814: BEGIN
5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5816: TO_NUMBER(l_attr_disp_val_table(i)) = EGO_ITEM_PUB.G_INTF_NULL_NUM

Line 5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR

5811: l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR THEN
5812: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5813: ELSIF l_attr_metadata_obj.data_type_code = 'N' THEN
5814: BEGIN
5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5816: TO_NUMBER(l_attr_disp_val_table(i)) = EGO_ITEM_PUB.G_INTF_NULL_NUM
5817: ) THEN
5818: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_NUM;
5819: END IF;

Line 5816: TO_NUMBER(l_attr_disp_val_table(i)) = EGO_ITEM_PUB.G_INTF_NULL_NUM

5812: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5813: ELSIF l_attr_metadata_obj.data_type_code = 'N' THEN
5814: BEGIN
5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5816: TO_NUMBER(l_attr_disp_val_table(i)) = EGO_ITEM_PUB.G_INTF_NULL_NUM
5817: ) THEN
5818: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_NUM;
5819: END IF;
5820: EXCEPTION

Line 5818: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_NUM;

5814: BEGIN
5815: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5816: TO_NUMBER(l_attr_disp_val_table(i)) = EGO_ITEM_PUB.G_INTF_NULL_NUM
5817: ) THEN
5818: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_NUM;
5819: END IF;
5820: EXCEPTION
5821: WHEN OTHERS THEN
5822: -- the value needs to be checked against value set

Line 5827: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR

5823: NULL;
5824: END;
5825: ELSIF l_attr_metadata_obj.data_type_code IN ('X','Y') THEN
5826: BEGIN
5827: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5828: TO_DATE(l_attr_disp_val_table(i),G_DATE_FORMAT) = EGO_ITEM_PUB.G_INTF_NULL_DATE
5829: ) THEN
5830: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_DATE;
5831: END IF;

Line 5828: TO_DATE(l_attr_disp_val_table(i),G_DATE_FORMAT) = EGO_ITEM_PUB.G_INTF_NULL_DATE

5824: END;
5825: ELSIF l_attr_metadata_obj.data_type_code IN ('X','Y') THEN
5826: BEGIN
5827: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5828: TO_DATE(l_attr_disp_val_table(i),G_DATE_FORMAT) = EGO_ITEM_PUB.G_INTF_NULL_DATE
5829: ) THEN
5830: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_DATE;
5831: END IF;
5832: EXCEPTION

Line 5830: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_DATE;

5826: BEGIN
5827: IF (l_attr_disp_val_table(i) = EGO_ITEM_PUB.G_INTF_NULL_CHAR OR
5828: TO_DATE(l_attr_disp_val_table(i),G_DATE_FORMAT) = EGO_ITEM_PUB.G_INTF_NULL_DATE
5829: ) THEN
5830: l_attr_int_val_table(i) := EGO_ITEM_PUB.G_INTF_NULL_DATE;
5831: END IF;
5832: EXCEPTION
5833: WHEN OTHERS THEN
5834: -- the value needs to be checked against value set