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.CE_UK_VALIDATIONS_DATA_LDR dependencies on CE_UK_VAL_SUBS_CODES

Line 159: | table to actual table CE_UK_VAL_SUBS_CODES |

155: | transfer_sub_codes |
156: | |
157: | DESCRIPTION |
158: | This procedure Transfer substitute sort codes from interface |
159: | table to actual table CE_UK_VAL_SUBS_CODES |
160: | CALLED BY |
161: | |
162: | HISTORY |
163: | 18-Dec-2012 rtumati Created |

Line 170: -- Delete data from CE_UK_VAL_SUBS_CODES table.

166: BEGIN
167: G_debug_proc := 'transfer_sub_codes';
168: log_msg('begin transfer_sub_codes');
169:
170: -- Delete data from CE_UK_VAL_SUBS_CODES table.
171: log_msg('Removing existing data from table');
172: DELETE FROM CE_UK_VAL_SUBS_CODES;
173: log_msg(SQL%Rowcount||' record(s) deleted.');
174:

Line 172: DELETE FROM CE_UK_VAL_SUBS_CODES;

168: log_msg('begin transfer_sub_codes');
169:
170: -- Delete data from CE_UK_VAL_SUBS_CODES table.
171: log_msg('Removing existing data from table');
172: DELETE FROM CE_UK_VAL_SUBS_CODES;
173: log_msg(SQL%Rowcount||' record(s) deleted.');
174:
175: -- Insert data into CE_UK_VAL_SUBS_CODES table.
176: log_msg('Inserting new data into table');

Line 175: -- Insert data into CE_UK_VAL_SUBS_CODES table.

171: log_msg('Removing existing data from table');
172: DELETE FROM CE_UK_VAL_SUBS_CODES;
173: log_msg(SQL%Rowcount||' record(s) deleted.');
174:
175: -- Insert data into CE_UK_VAL_SUBS_CODES table.
176: log_msg('Inserting new data into table');
177: INSERT INTO CE_UK_VAL_SUBS_CODES(
178: SUBSTITUTION_ID,
179: ORIG_SORT_CODE,

Line 177: INSERT INTO CE_UK_VAL_SUBS_CODES(

173: log_msg(SQL%Rowcount||' record(s) deleted.');
174:
175: -- Insert data into CE_UK_VAL_SUBS_CODES table.
176: log_msg('Inserting new data into table');
177: INSERT INTO CE_UK_VAL_SUBS_CODES(
178: SUBSTITUTION_ID,
179: ORIG_SORT_CODE,
180: SUBS_SORT_CODE,
181: REQUEST_ID,

Line 211: | table CE_UK_VAL_SUBS_CODES after succesful load |

207: | List_sub_codes |
208: | |
209: | DESCRIPTION |
210: | This procedure lists the substitute sort codes stored in the |
211: | table CE_UK_VAL_SUBS_CODES after succesful load |
212: | |
213: | HISTORY |
214: | 18-Dec-2012 rtumati Created |
215: --------------------------------------------------------------------- */

Line 229: FROM CE_UK_VAL_SUBS_CODES ORDER BY SUBSTITUTION_ID)

225: SUBSTITUTION_ID,
226: ORIG_SORT_CODE,
227: SUBS_SORT_CODE,
228: LAST_UPDATE_DATE
229: FROM CE_UK_VAL_SUBS_CODES ORDER BY SUBSTITUTION_ID)
230: LOOP
231: log_msg('Listing SUBSTITUTION_ID='||subsCodeRec.SUBSTITUTION_ID);
232:
233: put_starttag('subsCodeRec');

Line 706: -- actual table CE_UK_VAL_SUBS_CODES

702: -- Validate substitute sort codes data being loaded
703: validate_sub_codes;
704:
705: -- Transfer substitute sort codes from interface table to
706: -- actual table CE_UK_VAL_SUBS_CODES
707: transfer_sub_codes;
708:
709: -- Write data to XML
710: list_sub_codes;