[Home] [Help]
PACKAGE: APPS.INV_MIGRATE_PROCESS_ORG
Source
1 PACKAGE INV_MIGRATE_PROCESS_ORG AS
2 /* $Header: INVPOMGS.pls 120.0 2005/06/29 13:42 jgogna noship $ */
3
4 /*====================================================================
5 -- PROCEDURE:
6 -- update_organization
7 --
8 -- DESCRIPTION:
9 -- This PL/SQL procedure is used to update the exisitng Organization
10 -- values .
11 --
12 --
13 -- PARAMETERS:
14 -- P_migration_run_id - id to use to right to migration log
15 -- x_failure_count - Number of failures occurred.
16 --
17 -- SYNOPSIS:
18 -- update_organization(p_migartion_id => l_migration_id,
19 -- p_commit => 'T',
20 -- x_failure_count => l_failure_count );
21 --
22 -- HISTORY
23 --====================================================================*/
24
25 PROCEDURE update_organization (P_migration_run_id IN NUMBER,
26 P_commit IN VARCHAR2,
27 X_failure_count OUT NOCOPY NUMBER);
28
29 /*====================================================================
30 -- PROCEDURE:
31 -- create_location
32 --
33 -- DESCRIPTION:
34 -- This PL/SQL procedure is used to create the location in
35 -- Discrete tables .
36 --
37 -- PARAMETERS:
38 -- P_migration_run_id - id to use to right to migration log
39 -- p_organization_id --Organization id.
40 -- p_subinventory_code --Subinventory for location.
41 -- p_location --location name.
42 -- P_loct_desc --Location Name.
43 -- P_statrt_date_active - Start date
44 -- x_failure_count - Number of failures occurred.
45 --
46 -- SYNOPSIS:
47 -- create_location(P_migration_run_id => l_migration_id
48 -- p_organization_id => l_organization_id,
49 -- p_subinventory_code => l_subinventory_code,
50 -- p_location => l_location,
51 -- p_loct_desc => l_loct_desc,
52 -- p_start_date_active => l_start_date_active,
53 -- p_commit => 'Y',
54 -- x_failure_count => l_failure_count);
55 --
56 -- HISTORY
57 --====================================================================*/
58
59 PROCEDURE create_location (P_migration_run_id IN NUMBER,
60 P_organization_id IN NUMBER,
61 P_subinventory_code IN VARCHAR2,
62 P_location IN VARCHAR2,
63 P_loct_desc IN VARCHAR2,
64 P_start_date_active IN DATE,
65 P_commit IN VARCHAR2,
66 X_location_id OUT NOCOPY NUMBER,
67 X_failure_count OUT NOCOPY NUMBER,
68 P_disable_date IN DATE DEFAULT NULL,
69 P_segment2 IN VARCHAR2 DEFAULT NULL,
70 P_segment3 IN VARCHAR2 DEFAULT NULL,
71 P_segment4 IN VARCHAR2 DEFAULT NULL,
72 P_segment5 IN VARCHAR2 DEFAULT NULL,
73 P_segment6 IN VARCHAR2 DEFAULT NULL,
74 P_segment7 IN VARCHAR2 DEFAULT NULL,
75 P_segment8 IN VARCHAR2 DEFAULT NULL,
76 P_segment9 IN VARCHAR2 DEFAULT NULL,
77 P_segment10 IN VARCHAR2 DEFAULT NULL,
78 P_segment11 IN VARCHAR2 DEFAULT NULL,
79 P_segment12 IN VARCHAR2 DEFAULT NULL,
80 P_segment13 IN VARCHAR2 DEFAULT NULL,
81 P_segment14 IN VARCHAR2 DEFAULT NULL,
82 P_segment15 IN VARCHAR2 DEFAULT NULL,
83 P_segment16 IN VARCHAR2 DEFAULT NULL,
84 P_segment17 IN VARCHAR2 DEFAULT NULL,
85 P_segment18 IN VARCHAR2 DEFAULT NULL,
86 P_segment19 IN VARCHAR2 DEFAULT NULL,
87 P_segment20 IN VARCHAR2 DEFAULT NULL);
88
89 /*====================================================================
90 -- PROCEDURE:
91 -- migrate_organization
92 --
93 -- DESCRIPTION:
94 -- This PL/SQL procedure is used to migrate the Organizations to
95 -- Discrete tables .
96 --
97 --
98 -- PARAMETERS:
99 -- P_migration_run_id - id to use to right to migration log
100 -- x_failure_count - Number of failures occurred.
101 --
102 -- SYNOPSIS:
103 -- migrate_organization(p_migartion_id => l_migration_id,
104 -- p_commit => 'T',
105 -- x_failure_count => l_failure_count );
106 --
107 -- HISTORY
108 --====================================================================*/
109
110 PROCEDURE migrate_organization (P_migration_run_id IN NUMBER,
111 P_commit IN VARCHAR2,
112 X_failure_count OUT NOCOPY NUMBER);
113
114 END INV_MIGRATE_PROCESS_ORG;
115