1 PACKAGE AMW_LOAD_SOD_DATA AS
2 /* $Header: amwsodws.pls 120.1.12000000.1 2007/01/16 20:41:20 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMW_LOAD_SOD_DATA
7 -- Purpose
8 -- To upload data from SOD interface table to our data after validation
9 -- History
10 -- This is to enable to user to insert huge data *3.1 million records.
11 -- Records will be inserted into the interface table thru SQL Loader.
12 -- NOTE
13 -- Ref bug # 5167649
14 -- End of Comments
15 -- ===============================================================
16 PROCEDURE insert_data(
17 errbuf OUT NOCOPY VARCHAR2
18 ,retcode OUT NOCOPY VARCHAR2
19 ,p_batch_id IN NUMBER
20 );
21
22
23 PROCEDURE update_interface_with_error (
24 p_err_msg IN VARCHAR2
25 ,p_interface_id IN NUMBER
26 );
27
28 -- ===============================================================
29 -- Procedure name
30 -- create_constraint_waivers
31 -- Purpose
32 -- import constraint waivers
33 -- from interface table to AMW_CONSTRAINT_WAIVERS_B and
34 -- AMW_CONSTRAINT_WAIVERS_TL
35 -- Notes
36 -- this procedure is called in Concurrent Executable
37 -- ===============================================================
38 PROCEDURE create_constraint_waivers (
39 ERRBUF OUT NOCOPY VARCHAR2,
40 RETCODE OUT NOCOPY VARCHAR2,
41 p_batch_id IN NUMBER := NULL,
42 p_del_after_import IN VARCHAR2 := 'Y'
43 );
44
45
46 -- ===============================================================
47 -- Procedure name
48 -- update_waiver_intf_with_error
49 -- Purpose
50 -- Updates error flag and interface status of
51 -- amw_cst_waiver_interface interface table
52 -- ===============================================================
53 PROCEDURE update_waiver_intf_with_error (
54 p_err_msg IN VARCHAR2
55 ,p_interface_id IN NUMBER
56 );
57
58 -- ===============================================================
59 -- Procedure name
60 -- cst_table_update_report
61 -- Purpose
62 -- Report the issues identified during updating of the following
63 -- columsn the application_id
64 -- 1. AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID
65 -- 2. AMW_CONSTRAINT_ENTRIES.APPLICATION_ID
66 -- 3. AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID
67 -- 4. AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
68 -- 5. AMW_CONSTRAINT_WAIVERS_B.PK2
69 -- Notes
70 -- this procedure is called in Concurrent Executable
71 -- ===============================================================
72 PROCEDURE cst_table_update_report (
73 ERRBUF OUT NOCOPY VARCHAR2,
74 RETCODE OUT NOCOPY VARCHAR2
75 );
76
77 END AMW_LOAD_SOD_DATA;