APPS.GME_TRANSFORM_BATCH dependencies on GME_PARAMETERS

Line 23: p_table_name => 'GME_PARAMETERS',

19: gma_common_logging.gma_migration_central_log
20: (p_run_id => p_migration_run_id,
21: p_log_level => fnd_log.level_procedure,
22: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
23: p_table_name => 'GME_PARAMETERS',
24: p_context => 'PROFILES',
25: p_app_short_name => 'GMA');
26: create_gme_parameters(p_migration_run_id => p_migration_run_id,
27: x_exception_count => x_failure_count);

Line 26: create_gme_parameters(p_migration_run_id => p_migration_run_id,

22: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
23: p_table_name => 'GME_PARAMETERS',
24: p_context => 'PROFILES',
25: p_app_short_name => 'GMA');
26: create_gme_parameters(p_migration_run_id => p_migration_run_id,
27: x_exception_count => x_failure_count);
28:
29: gma_common_logging.gma_migration_central_log
30: (p_run_id => p_migration_run_id,

Line 79: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,

75: BEGIN
76: RETURN fnd_profile.VALUE (v_profile_name);
77: END get_profile_value;
78:
79: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,
80: x_exception_count OUT NOCOPY NUMBER) IS
81: CURSOR get_plant_and_labs IS
82: SELECT sy.organization_id, sy.orgn_code plant_code
83: FROM sy_orgn_mst sy

Line 85: FROM gme_parameters

81: CURSOR get_plant_and_labs IS
82: SELECT sy.organization_id, sy.orgn_code plant_code
83: FROM sy_orgn_mst sy
84: WHERE NOT EXISTS (SELECT 1
85: FROM gme_parameters
86: WHERE organization_id = sy.organization_id)
87: AND sy.organization_id IS NOT NULL;
88:
89: CURSOR get_doc_numbering (v_doc_type IN VARCHAR2, v_plant_code IN VARCHAR2) IS

Line 109: INSERT INTO gme_parameters

105: OPEN get_doc_numbering ('PROD', rec.plant_code);
106: FETCH get_doc_numbering INTO l_batch_assignment, l_batch_number;
107: CLOSE get_doc_numbering;
108:
109: INSERT INTO gme_parameters
110: (organization_id, auto_consume_supply_sub_only,
111: supply_subinventory, supply_locator_id,
112: yield_subinventory, yield_locator_id,
113: delete_material_ind,

Line 168: p_table_name => 'GME_PARAMETERS',

164: l_count := l_count + 1;
165: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,
166: p_log_level => fnd_log.level_procedure,
167: p_message_token => 'GME_CREATE_PARAMS_SUCCESS',
168: p_table_name => 'GME_PARAMETERS',
169: p_context => 'PROFILES',
170: p_token1 => 'ORG_CODE',
171: p_param1 => rec.plant_code,
172: p_app_short_name => 'GME');

Line 180: p_table_name => 'GME_PARAMETERS',

176: gma_common_logging.gma_migration_central_log
177: (p_run_id => p_migration_run_id,
178: p_log_level => fnd_log.level_unexpected,
179: p_message_token => 'GMA_MIGRATION_DB_ERROR',
180: p_table_name => 'GME_PARAMETERS',
181: p_context => 'PROFILES',
182: p_db_error => SQLERRM,
183: p_app_short_name => 'GMA');
184: gma_common_logging.gma_migration_central_log

Line 188: p_table_name => 'GME_PARAMETERS',

184: gma_common_logging.gma_migration_central_log
185: (p_run_id => p_migration_run_id,
186: p_log_level => fnd_log.level_unexpected,
187: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
188: p_table_name => 'GME_PARAMETERS',
189: p_context => 'PROFILES',
190: p_app_short_name => 'GMA');
191: END;
192: END LOOP;

Line 197: p_table_name => 'GME_PARAMETERS',

193: gma_common_logging.gma_migration_central_log
194: (p_run_id => p_migration_run_id,
195: p_log_level => fnd_log.level_procedure,
196: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
197: p_table_name => 'GME_PARAMETERS',
198: p_context => 'PROFILES',
199: p_param1 => l_count,
200: p_app_short_name => 'GMA');
201: EXCEPTION

Line 208: p_table_name => 'GME_PARAMETERS',

204: gma_common_logging.gma_migration_central_log
205: (p_run_id => p_migration_run_id,
206: p_log_level => fnd_log.level_unexpected,
207: p_message_token => 'GMA_MIGRATION_DB_ERROR',
208: p_table_name => 'GME_PARAMETERS',
209: p_context => 'PROFILES',
210: p_db_error => SQLERRM,
211: p_app_short_name => 'GMA');
212: gma_common_logging.gma_migration_central_log

Line 216: p_table_name => 'GME_PARAMETERS',

212: gma_common_logging.gma_migration_central_log
213: (p_run_id => p_migration_run_id,
214: p_log_level => fnd_log.level_unexpected,
215: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
216: p_table_name => 'GME_PARAMETERS',
217: p_context => 'PROFILES',
218: p_app_short_name => 'GMA');
219: END create_gme_parameters;
220:

Line 219: END create_gme_parameters;

215: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
216: p_table_name => 'GME_PARAMETERS',
217: p_context => 'PROFILES',
218: p_app_short_name => 'GMA');
219: END create_gme_parameters;
220:
221: PROCEDURE update_batch_header(p_migration_run_id IN NUMBER,
222: x_exception_count OUT NOCOPY NUMBER) IS
223: BEGIN