1 PACKAGE GR_MIGRATE_TO_12 AS
2 /* $Header: GRMIG12S.pls 120.0.12010000.1 2008/07/30 07:14:38 appldev ship $ */
3
4
5 FUNCTION get_inventory_item_id
6 (
7 -- Organization id to use to retrieve the value
8 p_organization_id IN NUMBER,
9 -- Item_code to use to retrieve the value
10 p_item_code IN VARCHAR2,
11 -- Returns the status of the procedure
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 -- Returns message data
14 x_msg_data OUT NOCOPY VARCHAR2
15 )
16 RETURN NUMBER;
17
18
19 FUNCTION get_hazard_class_id
20 (
21 -- Item code to retrieve Hazard class id for
22 p_item_code IN VARCHAR2,
23 -- Returns the status of the procedure
24 x_return_status OUT NOCOPY VARCHAR2 ,
25 -- Returns message data
26 x_msg_data OUT NOCOPY VARCHAR2
27 )
28 RETURN NUMBER;
29
30
31 FUNCTION get_un_number_id
32 (
33 -- Item code to retrieve UN Number id for
34 p_item_code IN VARCHAR2,
35 -- Returns the status of the procedure
36 x_return_status OUT NOCOPY VARCHAR2 ,
37 -- Returns message data
38 x_msg_data OUT NOCOPY VARCHAR2
39 )
40 RETURN NUMBER;
41
42
43 PROCEDURE create_item_mig_records
44 (
45 -- Migration run id to be used for writing message to the message log
46 p_migration_run_id IN NUMBER,
47 -- Indicates if commit should be issued after logical unit is migrated
48 p_commit IN VARCHAR2,
49 -- Returns the number of failures that occurred during migration
50 x_failure_count OUT NOCOPY NUMBER
51 );
52
53
54 PROCEDURE migrate_regulatory_items
55 (
56 -- Migration run id to be used for writing message to the message log
57 p_migration_run_id IN NUMBER,
58 -- Indicates if commit should be issued after logical unit is migrated
59 p_commit IN VARCHAR2,
60 -- Returns the number of failures that occurred during migration
61 x_failure_count OUT NOCOPY NUMBER
62 );
63
64
65 PROCEDURE migrate_standalone_formulas
66 (
67 -- Migration run id to be used for writing message to the message log
68 p_migration_run_id IN NUMBER,
69 -- Indicates if commit should be issued after logical unit is migrated
70 p_commit IN VARCHAR2,
71 -- Returns the number of failures that occurred during migration
72 x_failure_count OUT NOCOPY NUMBER
73 );
74
75
76 PROCEDURE update_dispatch_history
77 (
78 -- Migration run id to be used for writing message to the message log
79 p_migration_run_id IN NUMBER,
80 -- Indicates if commit should be issued after logical unit is migrated
81 p_commit IN VARCHAR2,
82 -- Returns the number of failures that occurred during migration
83 x_failure_count OUT NOCOPY NUMBER
84 );
85
86 END GR_MIGRATE_TO_12;
87