DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_GLOBAL

Line 1136: , created_by = fnd_global.user_id

1132: , width = NVL(p_width, NULL)
1133: , height = NVL(p_height, NULL)
1134: , dropping_order = NVL(p_dropping_order, NULL)
1135: , creation_date = SYSDATE
1136: , created_by = fnd_global.user_id
1137: , last_updated_by = fnd_global.user_id
1138: , last_update_date = SYSDATE
1139: , attribute_category = p_attribute_category
1140: , attribute1 = p_attribute1

Line 1137: , last_updated_by = fnd_global.user_id

1133: , height = NVL(p_height, NULL)
1134: , dropping_order = NVL(p_dropping_order, NULL)
1135: , creation_date = SYSDATE
1136: , created_by = fnd_global.user_id
1137: , last_updated_by = fnd_global.user_id
1138: , last_update_date = SYSDATE
1139: , attribute_category = p_attribute_category
1140: , attribute1 = p_attribute1
1141: , attribute2 = p_attribute2

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

1168: l_status_rec.status_id := l_status_id;
1169: l_status_rec.zone_code := p_subinventory_code;
1170: l_status_rec.locator_id := x_inventory_location_id;
1171: l_status_rec.creation_date := SYSDATE;
1172: l_status_rec.created_by := fnd_global.user_id;
1173: l_status_rec.last_update_date := SYSDATE;
1174: l_status_rec.last_update_login := fnd_global.user_id;
1175: l_status_rec.initial_status_flag := 'Y';
1176: l_status_rec.from_mobile_apps_flag := 'N';

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

1170: l_status_rec.locator_id := x_inventory_location_id;
1171: l_status_rec.creation_date := SYSDATE;
1172: l_status_rec.created_by := fnd_global.user_id;
1173: l_status_rec.last_update_date := SYSDATE;
1174: l_status_rec.last_update_login := fnd_global.user_id;
1175: l_status_rec.initial_status_flag := 'Y';
1176: l_status_rec.from_mobile_apps_flag := 'N';
1177: inv_material_status_pkg.insert_status_history(l_status_rec);
1178: END IF;

Line 1936: , last_updated_by = fnd_global.user_id

1932: , width = DECODE(p_width, fnd_api.g_miss_num, width, p_width)
1933: , height = DECODE(p_height, fnd_api.g_miss_num, height, p_height)
1934: , status_id = DECODE(p_status_id, fnd_api.g_miss_num, status_id, p_status_id)
1935: , dropping_order = DECODE(p_dropping_order, fnd_api.g_miss_num, dropping_order, p_dropping_order)
1936: , last_updated_by = fnd_global.user_id
1937: , last_update_date = SYSDATE
1938: , attribute_category = decode(p_attribute_category, NULL, attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category)
1939: , attribute1 = decode(p_attribute1, NULL, attribute1, fnd_api.g_miss_char, NULL, p_attribute1)
1940: , attribute2 = decode(p_attribute2, NULL, attribute2, fnd_api.g_miss_char, NULL, p_attribute2)

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

1968: l_status_rec.status_id := p_status_id;
1969: l_status_rec.zone_code := l_subinventory_code;
1970: l_status_rec.locator_id := l_inventory_location_id;
1971: l_status_rec.creation_date := SYSDATE;
1972: l_status_rec.created_by := fnd_global.user_id;
1973: l_status_rec.last_update_date := SYSDATE;
1974: l_status_rec.last_update_login := fnd_global.user_id;
1975: l_status_rec.initial_status_flag := 'N';
1976: l_status_rec.from_mobile_apps_flag := 'N';

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

1970: l_status_rec.locator_id := l_inventory_location_id;
1971: l_status_rec.creation_date := SYSDATE;
1972: l_status_rec.created_by := fnd_global.user_id;
1973: l_status_rec.last_update_date := SYSDATE;
1974: l_status_rec.last_update_login := fnd_global.user_id;
1975: l_status_rec.initial_status_flag := 'N';
1976: l_status_rec.from_mobile_apps_flag := 'N';
1977: --DBMS_output.put_line('Before updating staTUS');
1978: inv_material_status_pkg.insert_status_history(l_status_rec);

Line 2244: , fnd_global.user_id

2240: l_inventory_item_id
2241: , l_organization_id
2242: , p_subinventory_code
2243: , SYSDATE
2244: , fnd_global.user_id
2245: , SYSDATE
2246: , fnd_global.user_id
2247: , 6
2248: );

Line 2246: , fnd_global.user_id

2242: , p_subinventory_code
2243: , SYSDATE
2244: , fnd_global.user_id
2245: , SYSDATE
2246: , fnd_global.user_id
2247: , 6
2248: );
2249: END;
2250:

Line 2272: , fnd_global.user_id

2268: l_inventory_item_id
2269: , l_organization_id
2270: , l_locator_id
2271: , SYSDATE
2272: , fnd_global.user_id
2273: , SYSDATE
2274: , fnd_global.user_id
2275: , p_subinventory_code
2276: , p_status_id

Line 2274: , fnd_global.user_id

2270: , l_locator_id
2271: , SYSDATE
2272: , fnd_global.user_id
2273: , SYSDATE
2274: , fnd_global.user_id
2275: , p_subinventory_code
2276: , p_status_id
2277: , DECODE(l_planning_level, 1, p_par_level, NULL)
2278: );

Line 2297: , fnd_global.user_id

2293: l_inventory_item_id
2294: , l_organization_id
2295: , l_locator_id
2296: , SYSDATE
2297: , fnd_global.user_id
2298: , SYSDATE
2299: , fnd_global.user_id
2300: , p_subinventory_code
2301: , p_status_id

Line 2299: , fnd_global.user_id

2295: , l_locator_id
2296: , SYSDATE
2297: , fnd_global.user_id
2298: , SYSDATE
2299: , fnd_global.user_id
2300: , p_subinventory_code
2301: , p_status_id
2302: );
2303: END IF;