APPS.ECE_UTILITIES dependencies on ECE_INTERFACE_TABLES

Line 77: from ece_interface_tables t,

73: column specified.
74: **********************************************/
75: select distinct cat.xref_category_code
76: into cCategory_code
77: from ece_interface_tables t,
78: ece_interface_columns col,
79: ece_xref_categories cat
80: where t.interface_table_id = col.interface_table_id
81: and cat.xref_category_id = col.xref_category_id

Line 185: from ece_interface_tables eit,

181: eic.base_table_name,
182: eic.base_column_nAme,
183: eic.data_type,
184: eic.width
185: from ece_interface_tables eit,
186: ece_interface_columns eic
187: where eit.interface_table_id = eic.interface_table_id
188: and eit.transaction_type = UPPER(cTransaction_code)
189: order by eit.interface_table_name;

Line 200: ece_interface_tables eit

196: eit.start_number,
197: eit.output_level,
198: eit.key_column_name
199: from
200: ece_interface_tables eit
201: where
202: eit.transaction_type = UPPER(cTransaction_code);
203:
204: eit_rec c_int_table%ROWTYPE;

Line 241: from ece_interface_tables

237:
238: begin
239: select direction
240: into xDirection
241: from ece_interface_tables
242: where transaction_type = cTransaction_code
243: and output_level = '1';
244:
245: if xDirection = 'I' then

Line 311: in the ece_interface_tables table have corresponding

307:
308:
309: /******************************************************
310: First verify that all of the output levels defined
311: in the ece_interface_tables table have corresponding
312: lookup records in ece_lookup_values.
313: ******************************************************/
314: OPEN c_int_table;
315: LOOP

Line 355: Start verifying the seeded data in ece_interface_tables,

351:
352: END LOOP; -- c_int_table loop
353:
354: /**********************************************************
355: Start verifying the seeded data in ece_interface_tables,
356: ece_interface_columns, and ece_source_data_loc against
357: the database.
358: **********************************************************/
359: OPEN c_inc;

Line 750: ece_interface_tables eit,

746: eic.conversion_group_id,
747: eic.data_type,
748: eic.width data_length
749: FROM ece_interface_columns eic,
750: ece_interface_tables eit,
751: ece_level_matrices elm,
752: ece_external_levels eel
753: WHERE eit.interface_table_id = eic.interface_table_id AND
754: eit.transaction_type = p_trans_type AND

Line 929: FROM ece_interface_tables

925:
926: /* Make sure transaction type passed in exists */
927: xProgress := 'UTILB-10-1050';
928: SELECT installed_flag INTO c_installed_flag
929: FROM ece_interface_tables
930: WHERE transaction_Type = p_transaction AND
931: output_level = 1 AND
932: ROWNUM = 1;
933:

Line 937: -- Oops, it looks like the transaction is not found in ECE_INTERFACE_TABLES.

933:
934: EXCEPTION
935: WHEN NO_DATA_FOUND THEN
936: -- dbms_output.put_line('ERR: Transaction Code not found');
937: -- Oops, it looks like the transaction is not found in ECE_INTERFACE_TABLES.
938: not_in_main_flag := 'Y';
939:
940: WHEN OTHERS THEN
941: -- dbms_output.put_line(xProgress);

Line 996: UPDATE ece_interface_tables

992: WHERE transaction_type = p_transaction;
993: END IF;
994:
995: IF not_in_main_flag = 'N' THEN
996: UPDATE ece_interface_tables
997: SET installed_flag = new_status
998: WHERE transaction_type = p_transaction;
999: END IF;
1000: