24:
25: BEGIN
26: l_status := 9;
27:
28: IF (l_source_header_id = fnd_api.g_miss_num) THEN
29: l_source_header_id := NULL;
30: END IF;
31:
32: IF (l_source_line_id = fnd_api.g_miss_num) THEN
28: IF (l_source_header_id = fnd_api.g_miss_num) THEN
29: l_source_header_id := NULL;
30: END IF;
31:
32: IF (l_source_line_id = fnd_api.g_miss_num) THEN
33: l_source_line_id := NULL;
34: END IF;
35:
36: IF (l_source_line_detail = fnd_api.g_miss_num) THEN
32: IF (l_source_line_id = fnd_api.g_miss_num) THEN
33: l_source_line_id := NULL;
34: END IF;
35:
36: IF (l_source_line_detail = fnd_api.g_miss_num) THEN
37: l_source_line_detail := NULL;
38: END IF;
39:
40: /* Bug# 13641346 if source type id passed g_miss_num,
39:
40: /* Bug# 13641346 if source type id passed g_miss_num,
41: the lock name exceed 128 which is the max length
42: defined in DB */
43: IF (l_source_type_id = fnd_api.g_miss_num) THEN
44: l_source_type_id := NULL;
45: END IF;
46:
47: l_lock_name := 'INV_RSV_' ||