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.OKL_PURGE_STRM_INTF_PVT dependencies on FND_FILE

Line 48: FND_FILE.Put_Line(FND_FILE.LOG,'Lease and Finance Management: Streams Interface Tables purge concurrent program');

44: --EXECUTE IMMEDIATE ('ALTER SESSION FORCE PARALLEL QUERY'); -- commented out for test patch 5560534
45: -- EXECUTE IMMEDIATE ('ALTER SESSION ENABLE PARALLEL DML'); -- commented out for test patch 5560534
46:
47: x_retcode := 0;
48: FND_FILE.Put_Line(FND_FILE.LOG,'Lease and Finance Management: Streams Interface Tables purge concurrent program');
49: --l_end_date := TO_DATE(p_end_date,'YYYY/MM/DD HH:MI:SS');
50: l_end_date := fnd_date.canonical_to_date(p_end_date);
51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);
52:

Line 51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);

47: x_retcode := 0;
48: FND_FILE.Put_Line(FND_FILE.LOG,'Lease and Finance Management: Streams Interface Tables purge concurrent program');
49: --l_end_date := TO_DATE(p_end_date,'YYYY/MM/DD HH:MI:SS');
50: l_end_date := fnd_date.canonical_to_date(p_end_date);
51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);
52:
53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');
54:
55: DELETE FROM OKL_SIF_FEES

Line 53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');

49: --l_end_date := TO_DATE(p_end_date,'YYYY/MM/DD HH:MI:SS');
50: l_end_date := fnd_date.canonical_to_date(p_end_date);
51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);
52:
53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');
54:
55: DELETE FROM OKL_SIF_FEES
56: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
57: WHERE creation_date < l_end_date

Line 61: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_LINES');

57: WHERE creation_date < l_end_date
58: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
59: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
60: commit;
61: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_LINES');
62:
63: DELETE FROM OKL_SIF_LINES
64: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
65: WHERE creation_date < l_end_date

Line 70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');

66: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
67: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
68: commit;
69:
70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');
71:
72:
73: DELETE FROM OKL_SIF_STREAM_TYPES
74: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

Line 80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');

76: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
77: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
78: commit;
79:
80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');
81:
82: DELETE FROM OKL_SIF_YIELDS
83: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
84: WHERE creation_date < l_end_date

Line 89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');

85: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
86: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
87: commit;
88:
89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');
90:
91: DELETE FROM OKL_SIF_PRICING_PARAMS
92: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
93: WHERE creation_date < l_end_date

Line 98: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_TRX_PARMS');

94: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
95: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
96: commit;
97:
98: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_TRX_PARMS');
99:
100: DELETE FROM OKL_SIF_TRX_PARMS
101: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
102: WHERE creation_date < l_end_date

Line 107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');

103: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
104: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
105: commit;
106:
107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');
108:
109:
110: DELETE FROM OKL_SIF_RET_LEVELS
111: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

Line 118: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_ERRORS');

114: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
115: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
116: commit;
117:
118: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_ERRORS');
119:
120: DELETE FROM OKL_SIF_RET_ERRORS
121: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
122: WHERE rets.transaction_number = str.transaction_number

Line 128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');

124: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
125: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
126: commit;
127:
128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');
129:
130:
131: DELETE FROM OKL_SIF_RET_STRMS
132: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

Line 140: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from okl_stream_trx_data');

136: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
137: commit;
138:
139: --Added by bkatraga
140: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from okl_stream_trx_data');
141:
142: DELETE FROM okl_stream_trx_data
143: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
144: WHERE creation_date < l_end_date

Line 151: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RETS');

147:
148: commit;
149: --end bkatraga
150:
151: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RETS');
152:
153: DELETE FROM OKL_SIF_RETS
154: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
155: WHERE creation_date < l_end_date

Line 160: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_STREAM_INTERFACES');

156: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
157: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
158: commit;
159:
160: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_STREAM_INTERFACES');
161:
162: DELETE FROM OKL_STREAM_INTERFACES
163: WHERE creation_date < l_end_date
164: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',

Line 169: FND_FILE.Put_Line(FND_FILE.LOG, '');

165: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED');
166:
167: commit;
168:
169: FND_FILE.Put_Line(FND_FILE.LOG, '');
170: FND_FILE.Put_Line(FND_FILE.LOG,'End of Message Purge Concurrent Program');
171: x_retcode := 0;
172: x_errbuf := 'Successful';
173: --commit;

Line 170: FND_FILE.Put_Line(FND_FILE.LOG,'End of Message Purge Concurrent Program');

166:
167: commit;
168:
169: FND_FILE.Put_Line(FND_FILE.LOG, '');
170: FND_FILE.Put_Line(FND_FILE.LOG,'End of Message Purge Concurrent Program');
171: x_retcode := 0;
172: x_errbuf := 'Successful';
173: --commit;
174: EXCEPTION