APPS.PAY_KW_XDO_TEMPLATE dependencies on FND_LOBS

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

12:
13: L_START_DATE := TO_DATE('01/01/2005', 'mm/dd/yyyy');
14: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
15: -- program_name will be used to store the file_name
16: -- this is bcos the file_name in fnd_lobs contains
17: -- the full patch of the doc and not just the file name
18: SELECT program_name
19: INTO l_file_name
20: FROM fnd_lobs

Line 20: FROM fnd_lobs

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

Line 37: FROM fnd_lobs

33: effective_start_date,
34: effective_end_date)
35: SELECT p_file_id, l_file_name, 'Template for year 2005',
36: l_start_date, l_end_date
37: FROM fnd_lobs
38: WHERE file_id = p_file_id;
39: END end_date_2005;
40: --
41: PROCEDURE end_date_2006(p_file_id NUMBER)

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

49:
50: L_START_DATE := TO_DATE('01/01/2006', 'mm/dd/yyyy');
51: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
52: -- program_name will be used to store the file_name
53: -- this is bcos the file_name in fnd_lobs contains
54: -- the full patch of the doc and not just the file name
55: SELECT program_name
56: INTO l_file_name
57: FROM fnd_lobs

Line 57: FROM fnd_lobs

53: -- this is bcos the file_name in fnd_lobs contains
54: -- the full patch of the doc and not just the file name
55: SELECT program_name
56: INTO l_file_name
57: FROM fnd_lobs
58: WHERE file_id = p_file_id;
59:
60: -- the delete will ensure that the patch is rerunnable!
61: DELETE FROM per_gb_xdo_templates

Line 74: FROM fnd_lobs

70: effective_start_date,
71: effective_end_date)
72: SELECT p_file_id, l_file_name, 'Template for year 2006',
73: l_start_date, l_end_date
74: FROM fnd_lobs
75: WHERE file_id = p_file_id;
76: END end_date_2006;
77: --
78: END;