APPS.PAY_SD_CREATE_TEMPLATES dependencies on PER_SOLUTION_CMPT_NAMES

Line 21: l_file_name per_solution_cmpt_names.name%type;

17: FROM fnd_lobs
18: WHERE file_id = p_file_id;
19: --
20: l_count NUMBER(1);
21: l_file_name per_solution_cmpt_names.name%type;
22: l_proc varchar2(72) := g_package || 'POST_INSERT';
23: BEGIN
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: FOR cur_fnd_lob_rec IN csr_fnd_lob(file_id)

Line 33: FROM per_solution_cmpt_names

29: l_file_name := SUBSTR(SUBSTR(cur_fnd_lob_rec.file_name,
30: INSTR(cur_fnd_lob_rec.file_name,'/',-1)+1),
31: INSTR(cur_fnd_lob_rec.file_name,'\',-1)+1);
32: SELECT count(1) INTO l_count
33: FROM per_solution_cmpt_names
34: WHERE name = l_file_name;
35: --
36: IF l_count > 0 THEN
37: hr_utility.set_location(l_proc, 30);

Line 38: UPDATE per_solution_cmpt_names SET template_file = cur_fnd_lob_rec.file_data

34: WHERE name = l_file_name;
35: --
36: IF l_count > 0 THEN
37: hr_utility.set_location(l_proc, 30);
38: UPDATE per_solution_cmpt_names SET template_file = cur_fnd_lob_rec.file_data
39: WHERE name = l_file_name;
40: END IF;
41: END LOOP;
42: COMMIT;