DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_GLOBAL

Line 1050: , created_by = fnd_global.user_id

1046: , width = NVL(p_width, NULL)
1047: , height = NVL(p_height, NULL)
1048: , dropping_order = NVL(p_dropping_order, NULL)
1049: , creation_date = SYSDATE
1050: , created_by = fnd_global.user_id
1051: , last_updated_by = fnd_global.user_id
1052: , last_update_date = SYSDATE
1053: , attribute_category = p_attribute_category
1054: , attribute1 = p_attribute1

Line 1051: , last_updated_by = fnd_global.user_id

1047: , height = NVL(p_height, NULL)
1048: , dropping_order = NVL(p_dropping_order, NULL)
1049: , creation_date = SYSDATE
1050: , created_by = fnd_global.user_id
1051: , last_updated_by = fnd_global.user_id
1052: , last_update_date = SYSDATE
1053: , attribute_category = p_attribute_category
1054: , attribute1 = p_attribute1
1055: , attribute2 = p_attribute2

Line 1086: l_status_rec.created_by := fnd_global.user_id;

1082: l_status_rec.status_id := l_status_id;
1083: l_status_rec.zone_code := p_subinventory_code;
1084: l_status_rec.locator_id := x_inventory_location_id;
1085: l_status_rec.creation_date := SYSDATE;
1086: l_status_rec.created_by := fnd_global.user_id;
1087: l_status_rec.last_update_date := SYSDATE;
1088: l_status_rec.last_update_login := fnd_global.user_id;
1089: l_status_rec.initial_status_flag := 'Y';
1090: l_status_rec.from_mobile_apps_flag := 'N';

Line 1088: l_status_rec.last_update_login := fnd_global.user_id;

1084: l_status_rec.locator_id := x_inventory_location_id;
1085: l_status_rec.creation_date := SYSDATE;
1086: l_status_rec.created_by := fnd_global.user_id;
1087: l_status_rec.last_update_date := SYSDATE;
1088: l_status_rec.last_update_login := fnd_global.user_id;
1089: l_status_rec.initial_status_flag := 'Y';
1090: l_status_rec.from_mobile_apps_flag := 'N';
1091: inv_material_status_pkg.insert_status_history(l_status_rec);
1092: END IF;

Line 1840: , last_updated_by = fnd_global.user_id

1836: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1837: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1838: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1839: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1840: , last_updated_by = fnd_global.user_id
1841: , last_update_date = SYSDATE
1842: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1843: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1844: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)

Line 1876: l_status_rec.created_by := fnd_global.user_id;

1872: l_status_rec.status_id := p_status_id;
1873: l_status_rec.zone_code := l_subinventory_code;
1874: l_status_rec.locator_id := l_inventory_location_id;
1875: l_status_rec.creation_date := SYSDATE;
1876: l_status_rec.created_by := fnd_global.user_id;
1877: l_status_rec.last_update_date := SYSDATE;
1878: l_status_rec.last_update_login := fnd_global.user_id;
1879: l_status_rec.initial_status_flag := 'N';
1880: l_status_rec.from_mobile_apps_flag := 'N';

Line 1878: l_status_rec.last_update_login := fnd_global.user_id;

1874: l_status_rec.locator_id := l_inventory_location_id;
1875: l_status_rec.creation_date := SYSDATE;
1876: l_status_rec.created_by := fnd_global.user_id;
1877: l_status_rec.last_update_date := SYSDATE;
1878: l_status_rec.last_update_login := fnd_global.user_id;
1879: l_status_rec.initial_status_flag := 'N';
1880: l_status_rec.from_mobile_apps_flag := 'N';
1881: --DBMS_output.put_line('Before updating staTUS');
1882: inv_material_status_pkg.insert_status_history(l_status_rec);

Line 2148: , fnd_global.user_id

2144: l_inventory_item_id
2145: , l_organization_id
2146: , p_subinventory_code
2147: , SYSDATE
2148: , fnd_global.user_id
2149: , SYSDATE
2150: , fnd_global.user_id
2151: , 6
2152: );

Line 2150: , fnd_global.user_id

2146: , p_subinventory_code
2147: , SYSDATE
2148: , fnd_global.user_id
2149: , SYSDATE
2150: , fnd_global.user_id
2151: , 6
2152: );
2153: END;
2154:

Line 2176: , fnd_global.user_id

2172: l_inventory_item_id
2173: , l_organization_id
2174: , l_locator_id
2175: , SYSDATE
2176: , fnd_global.user_id
2177: , SYSDATE
2178: , fnd_global.user_id
2179: , p_subinventory_code
2180: , p_status_id

Line 2178: , fnd_global.user_id

2174: , l_locator_id
2175: , SYSDATE
2176: , fnd_global.user_id
2177: , SYSDATE
2178: , fnd_global.user_id
2179: , p_subinventory_code
2180: , p_status_id
2181: , DECODE(l_planning_level, 1, p_par_level, NULL)
2182: );

Line 2201: , fnd_global.user_id

2197: l_inventory_item_id
2198: , l_organization_id
2199: , l_locator_id
2200: , SYSDATE
2201: , fnd_global.user_id
2202: , SYSDATE
2203: , fnd_global.user_id
2204: , p_subinventory_code
2205: , p_status_id

Line 2203: , fnd_global.user_id

2199: , l_locator_id
2200: , SYSDATE
2201: , fnd_global.user_id
2202: , SYSDATE
2203: , fnd_global.user_id
2204: , p_subinventory_code
2205: , p_status_id
2206: );
2207: END IF;