eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

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

88:
89: L_START_DATE := TO_DATE('01/08/2007', 'mm/dd/yyyy');
90: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
91: -- program_name will be used to store the file_name
92: -- this is bcos the file_name in fnd_lobs contains
93: -- the full patch of the doc and not just the file name
94: SELECT program_name
95: INTO l_file_name
96: FROM fnd_lobs

Line 96: FROM fnd_lobs

92: -- this is bcos the file_name in fnd_lobs contains
93: -- the full patch of the doc and not just the file name
94: SELECT program_name
95: INTO l_file_name
96: FROM fnd_lobs
97: WHERE file_id = p_file_id;
98:
99: -- the delete will ensure that the patch is rerunnable!
100: DELETE FROM per_gb_xdo_templates

Line 113: FROM fnd_lobs

109: effective_start_date,
110: effective_end_date)
111: SELECT p_file_id, l_file_name, 'Template for year 2007',
112: l_start_date, l_end_date
113: FROM fnd_lobs
114: WHERE file_id = p_file_id;
115: END end_date_2007;
116:
117: --

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

129:
130: L_START_DATE := TO_DATE('08/01/2010', 'mm/dd/yyyy');
131: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
132: -- program_name will be used to store the file_name
133: -- this is bcos the file_name in fnd_lobs contains
134: -- the full patch of the doc and not just the file name
135: SELECT program_name
136: INTO l_file_name
137: FROM fnd_lobs

Line 137: FROM fnd_lobs

133: -- this is bcos the file_name in fnd_lobs contains
134: -- the full patch of the doc and not just the file name
135: SELECT program_name
136: INTO l_file_name
137: FROM fnd_lobs
138: WHERE file_id = p_file_id;
139:
140: -- the delete will ensure that the patch is rerunnable!
141: DELETE FROM per_gb_xdo_templates

Line 154: FROM fnd_lobs

150: effective_start_date,
151: effective_end_date)
152: SELECT p_file_id, l_file_name, 'Template for year 2010',
153: l_start_date, l_end_date
154: FROM fnd_lobs
155: WHERE file_id = p_file_id;
156: END end_date_2010;
157: --
158:

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

170:
171: L_START_DATE := TO_DATE('10/01/2012', 'mm/dd/yyyy');
172: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
173: -- program_name will be used to store the file_name
174: -- this is bcos the file_name in fnd_lobs contains
175: -- the full patch of the doc and not just the file name
176: SELECT program_name
177: INTO l_file_name
178: FROM fnd_lobs

Line 178: FROM fnd_lobs

174: -- this is bcos the file_name in fnd_lobs contains
175: -- the full patch of the doc and not just the file name
176: SELECT program_name
177: INTO l_file_name
178: FROM fnd_lobs
179: WHERE file_id = p_file_id;
180:
181: -- the delete will ensure that the patch is rerunnable!
182: DELETE FROM per_gb_xdo_templates

Line 195: FROM fnd_lobs

191: effective_start_date,
192: effective_end_date)
193: SELECT p_file_id, l_file_name, 'Template for year 2012',
194: l_start_date, l_end_date
195: FROM fnd_lobs
196: WHERE file_id = p_file_id;
197: END end_date_2012;
198: --
199: