[Home] [Help]
PACKAGE: APPS.GMD_NPD_MIGRATE
Source
1 PACKAGE GMD_NPD_MIGRATE AUTHID CURRENT_USER AS
2 /* $Header: GMDPDMGS.pls 120.2 2005/07/21 10:46:42 rajreddy noship $ */
3
4
5 /*====================================================================
6 -- PROCEDURE:
7 -- Migrate_Profiles
8 --
9 -- DESCRIPTION:
10 -- This PL/SQL procedure is used to migrate the profile values as
11 -- product development parameters.
12 --
13 -- The following parameters are migrated from Site Level (pre-convergence)
14 -- to Global Orgn. level (post-convergence)
15 --
16 -- Formula Parameters
17 -- GMD: Formula Version Control
18 -- GMD: Byproduct Active
19 -- GMD: Allow Zero Ingredient Qty
20 -- GMD: Mass UOM Type
21 -- GMD: Volume UOM Type
22 -- GMD: Yield Type
23 --
24 -- Operation Parameter(s)
25 -- GMD: Operation Version Control
26 --
27 -- Routing Parameters
28 -- GMD: Routing Version Control
29 -- GMD: Enforce Step Dependency
30 -- GMD: Default Step Release Type
31 --
32 -- Recipe Parameters
33 -- GMD: Recipe Version Control
34 -- GMD: Process Instruction Paragraph
35 --
36 -- PARAMETERS:
37 -- P_migration_run_id - id to use to right to migration log
38 -- x_failure_count - Number of failures occurred.
39 --
40 -- SYNOPSIS:
41 -- Migrate_Profiles(p_migartion_id => l_migration_id,
42 -- p_commit => 'T',
43 -- x_failure_count => l_failure_count );
44 --
45 -- HISTORY
46 --====================================================================*/
47
48 PROCEDURE Migrate_Profiles (P_migration_run_id IN NUMBER,
49 P_commit IN VARCHAR2,
50 X_failure_count OUT NOCOPY NUMBER);
51
52 /*====================================================================
53 -- PROCEDURE:
54 -- Migrate_Plant_Lab_Ind
55 --
56 -- DESCRIPTION:
57 -- This PL/SQL procedure is used to migrate the plant and lab
58 -- indicators to product development parameters.
59 --
60 -- PARAMETERS:
61 -- P_migration_run_id - id to use to right to migration log
62 -- x_failure_count - Number of failures occurred.
63 --
64 -- SYNOPSIS:
65 -- Migrate_Plant_Lab_Ind(p_migartion_id => l_migration_id,
66 -- P_commit => 'T',
67 -- x_failure_count => l_failure_count );
68 --
69 -- HISTORY
70 --====================================================================*/
71
72 PROCEDURE Migrate_Plant_Lab_Ind (P_migration_run_id IN NUMBER,
73 P_commit IN VARCHAR2,
74 X_failure_count OUT NOCOPY NUMBER);
75
76
77 /*====================================================================
78 -- PROCEDURE:
79 -- Migrate_Recipe_Types
80 --
81 -- DESCRIPTION:
82 -- This PL/SQL procedure is used to migrate the recipe types.
83 --
84 -- Recipes migrated to the Master Inventory Organization would default to 'General' recipes,
85 -- while recipes migrated to all other inventory orgs would default to 'Site' recipes.
86 --
87 -- PARAMETERS:
88 -- P_migration_run_id - id to use to right to migration log
89 -- x_failure_count - Number of failures occurred.
90 --
91 -- SYNOPSIS:
92 -- Migrate_Recipe_Types(p_migartion_id => l_migration_id,
93 -- p_commit => 'T',
94 -- x_failure_count => l_failure_count );
95 --
96 -- HISTORY
97 --====================================================================*/
98
99 PROCEDURE Migrate_Recipe_Types (P_migration_run_id IN NUMBER,
100 P_commit IN VARCHAR2,
101 X_failure_count OUT NOCOPY NUMBER);
102
103 /*====================================================================
104 -- PROCEDURE:
105 -- update_lab_simulator
106 --
107 -- DESCRIPTION:
108 -- This PL/SQL procedure is used to update the lab_organization_id.
109 --
110 -- lab_organization_id column in lm_sprd_fls will be updated wih the profile
111 -- value gmd$default_lab_type organization_id.
112 --
113 -- PARAMETERS:
114 -- P_migration_run_id - id to use to right to migration log
115 -- x_failure_count - Number of failures occurred.
116 --
117 -- SYNOPSIS:
118 -- update_lab_simulator(p_migartion_id => l_migration_id,
119 -- p_commit => 'T',
120 -- x_failure_count => l_failure_count );
121 --
122 -- HISTORY
123 --====================================================================*/
124
125 PROCEDURE update_lab_simulator (P_migration_run_id IN NUMBER,
126 P_commit IN VARCHAR2,
127 X_failure_count OUT NOCOPY NUMBER);
128
129 END GMD_NPD_MIGRATE;
130