1 PACKAGE ECE_UTILITIES AS
2 -- $Header: ECEUTILS.pls 120.3 2005/09/29 08:55:47 arsriniv ship $
3
4
5 PROCEDURE TEST_XREF_API (
6 cDirection IN VARCHAR2,
7 cTransaction_code IN VARCHAR2,
8 cView_name IN VARCHAR2,
9 cView_column IN VARCHAR2,
10 cInternal_value IN OUT NOCOPY VARCHAR2,
11 cKey1_value IN VARCHAR2,
12 cKey2_value IN VARCHAR2,
13 cKey3_value IN VARCHAR2,
14 cKey4_value IN VARCHAR2,
15 cKey5_value IN VARCHAR2,
16 cExt1_value IN OUT NOCOPY VARCHAR2,
17 cExt2_value IN OUT NOCOPY VARCHAR2,
18 cExt3_value IN OUT NOCOPY VARCHAR2,
19 cExt4_value IN OUT NOCOPY VARCHAR2,
20 cExt5_value IN OUT NOCOPY VARCHAR2);
21
22 PROCEDURE SEED_DATA_CHECK (
23 cTransaction_code IN VARCHAR2,
24 bErrors_found OUT NOCOPY BOOLEAN,
25 iRun_id OUT NOCOPY NUMBER,
26 bCheckLength IN BOOLEAN DEFAULT FALSE,
27 bCheckDatatype IN BOOLEAN DEFAULT FALSE,
28 bInsertErrors IN BOOLEAN DEFAULT FALSE);
29
30 PROCEDURE TEST_TP_LOOKUP (
31 p_Entity_site_id IN NUMBER,
32 p_Entity_type IN VARCHAR2,
33 p_location_code OUT NOCOPY VARCHAR2,
34 p_reference_ext1 OUT NOCOPY VARCHAR2,
35 p_reference_ext2 OUT NOCOPY VARCHAR2);
36
37
38 PROCEDURE TEST_LOCATION_CODE (
39 p_Translator_code IN VARCHAR2,
40 p_Location_code IN VARCHAR2,
41 p_Entity_type IN VARCHAR2,
42 l_entity_id OUT NOCOPY NUMBER,
43 l_entity_address_id OUT NOCOPY NUMBER);
44
45 PROCEDURE verify_flatfile(
46 p_run_id IN NUMBER,
47 p_map_id IN NUMBER,
48 p_Transaction_Type IN VARCHAR2,
49 p_File_path IN VARCHAR2,
50 p_Filename IN VARCHAR2);
51
52 PROCEDURE set_installation(
53 p_transaction IN VARCHAR2,
54 p_short_name IN VARCHAR2,
55 p_status IN VARCHAR2);
56
57
58 end ECE_UTILITIES;
59