APPS.PER_GB_P11D_TEMPLATE dependencies on FND_LOBS

Line 12: -- this is bcos the file_name in fnd_lobs contains

8: l_start_date DATE := TO_DATE('01/01/1900', 'dd/mm/yyyy');
9: l_end_date DATE := TO_DATE('05/04/2003', 'dd/mm/yyyy');
10: BEGIN
11: -- program_name will be used to store the file_name
12: -- this is bcos the file_name in fnd_lobs contains
13: -- the full patch of the doc and not just the file name
14: SELECT program_name
15: INTO l_file_name
16: FROM fnd_lobs

Line 16: FROM fnd_lobs

12: -- this is bcos the file_name in fnd_lobs contains
13: -- the full patch of the doc and not just the file name
14: SELECT program_name
15: INTO l_file_name
16: FROM fnd_lobs
17: WHERE file_id = p_file_id;
18:
19: -- the delete will ensure that the patch is rerunnable!
20: DELETE FROM per_gb_xdo_templates

Line 33: FROM fnd_lobs

29: effective_start_date,
30: effective_end_date)
31: SELECT p_file_id, l_file_name, 'Template for year 2002-2003',
32: l_start_date, l_end_date
33: FROM fnd_lobs
34: WHERE file_id = p_file_id;
35: END;
36: --
37: PROCEDURE end_date_2004(p_file_id NUMBER)

Line 46: -- this is bcos the file_name in fnd_lobs contains

42: l_start_date DATE := TO_DATE('06/04/2003', 'dd/mm/yyyy');
43: l_end_date DATE := TO_DATE('05/04/2004', 'dd/mm/yyyy');
44: BEGIN
45: -- program_name will be used to store the file_name
46: -- this is bcos the file_name in fnd_lobs contains
47: -- the full patch of the doc and not just the file name
48: SELECT program_name
49: INTO l_file_name
50: FROM fnd_lobs

Line 50: FROM fnd_lobs

46: -- this is bcos the file_name in fnd_lobs contains
47: -- the full patch of the doc and not just the file name
48: SELECT program_name
49: INTO l_file_name
50: FROM fnd_lobs
51: WHERE file_id = p_file_id;
52:
53: -- the delete will ensure that the patch is rerunnable!
54: DELETE FROM per_gb_xdo_templates

Line 67: FROM fnd_lobs

63: effective_start_date,
64: effective_end_date)
65: SELECT p_file_id, l_file_name, 'Template for year 2003-2004',
66: l_start_date, l_end_date
67: FROM fnd_lobs
68: WHERE file_id = p_file_id;
69: END;
70: --
71: PROCEDURE end_date_2005(p_file_id NUMBER)

Line 80: -- this is bcos the file_name in fnd_lobs contains

76: l_start_date DATE := TO_DATE('06/04/2004', 'dd/mm/yyyy');
77: l_end_date DATE := TO_DATE('05/04/2005', 'dd/mm/yyyy');
78: BEGIN
79: -- program_name will be used to store the file_name
80: -- this is bcos the file_name in fnd_lobs contains
81: -- the full patch of the doc and not just the file name
82: SELECT program_name
83: INTO l_file_name
84: FROM fnd_lobs

Line 84: FROM fnd_lobs

80: -- this is bcos the file_name in fnd_lobs contains
81: -- the full patch of the doc and not just the file name
82: SELECT program_name
83: INTO l_file_name
84: FROM fnd_lobs
85: WHERE file_id = p_file_id;
86:
87: -- the delete will ensure that the patch is rerunnable!
88: DELETE FROM per_gb_xdo_templates

Line 101: FROM fnd_lobs

97: effective_start_date,
98: effective_end_date)
99: SELECT p_file_id, l_file_name, 'Template for year 2004-2005',
100: l_start_date, l_end_date
101: FROM fnd_lobs
102: WHERE file_id = p_file_id;
103: END;
104: --
105: END;