DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_POST_MIGRATION

Line 1: PACKAGE BODY gme_post_migration AS

1: PACKAGE BODY gme_post_migration AS
2: /* $Header: GMEVRCBB.pls 120.9 2007/01/26 23:05:29 snene noship $ */
3: g_migration_run_id NUMBER;
4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
5: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,

Line 11: l_mtl_dtl_mig_tbl gme_post_migration.mtl_dtl_mig_tab;

7: l_api_name VARCHAR2(30) := 'RECREATE_OPEN_BATCHES';
8: l_item_rec mtl_system_items_vl%ROWTYPE;
9: l_batch_header gme_batch_header%ROWTYPE;
10: l_batch_tbl gme_common_pvt.batch_headers_tab;
11: l_mtl_dtl_mig_tbl gme_post_migration.mtl_dtl_mig_tab;
12: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
13: l_in_mtl_dtl_tbl gme_common_pvt.material_details_tab;
14: l_steps_mig_tbl gme_post_migration.steps_mig_tab;
15: l_steps_tbl gme_common_pvt.steps_tab;

Line 14: l_steps_mig_tbl gme_post_migration.steps_mig_tab;

10: l_batch_tbl gme_common_pvt.batch_headers_tab;
11: l_mtl_dtl_mig_tbl gme_post_migration.mtl_dtl_mig_tab;
12: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
13: l_in_mtl_dtl_tbl gme_common_pvt.material_details_tab;
14: l_steps_mig_tbl gme_post_migration.steps_mig_tab;
15: l_steps_tbl gme_common_pvt.steps_tab;
16: l_activities_mig_tbl gme_post_migration.activ_mig_tab;
17: l_activities_tbl gme_common_pvt.activities_tab;
18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;

Line 16: l_activities_mig_tbl gme_post_migration.activ_mig_tab;

12: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
13: l_in_mtl_dtl_tbl gme_common_pvt.material_details_tab;
14: l_steps_mig_tbl gme_post_migration.steps_mig_tab;
15: l_steps_tbl gme_common_pvt.steps_tab;
16: l_activities_mig_tbl gme_post_migration.activ_mig_tab;
17: l_activities_tbl gme_common_pvt.activities_tab;
18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;
19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;

Line 18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;

14: l_steps_mig_tbl gme_post_migration.steps_mig_tab;
15: l_steps_tbl gme_common_pvt.steps_tab;
16: l_activities_mig_tbl gme_post_migration.activ_mig_tab;
17: l_activities_tbl gme_common_pvt.activities_tab;
18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;
19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;
21: l_proc_param_tbl gme_post_migration.process_param_tab;
22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;

Line 20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;

16: l_activities_mig_tbl gme_post_migration.activ_mig_tab;
17: l_activities_tbl gme_common_pvt.activities_tab;
18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;
19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;
21: l_proc_param_tbl gme_post_migration.process_param_tab;
22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;
23: l_rsrc_txns_tbl gme_post_migration.rsrc_txns_tab;
24: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 21: l_proc_param_tbl gme_post_migration.process_param_tab;

17: l_activities_tbl gme_common_pvt.activities_tab;
18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;
19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;
21: l_proc_param_tbl gme_post_migration.process_param_tab;
22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;
23: l_rsrc_txns_tbl gme_post_migration.rsrc_txns_tab;
24: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
25: l_wip_entity_id NUMBER;

Line 22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;

18: l_resources_mig_tbl gme_post_migration.rsrc_mig_tab;
19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;
21: l_proc_param_tbl gme_post_migration.process_param_tab;
22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;
23: l_rsrc_txns_tbl gme_post_migration.rsrc_txns_tab;
24: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
25: l_wip_entity_id NUMBER;
26: l_organization_id NUMBER;

Line 23: l_rsrc_txns_tbl gme_post_migration.rsrc_txns_tab;

19: l_resources_tbl gme_common_pvt.resources_tab;
20: l_proc_param_mig_tbl gme_post_migration.process_param_mig_tab;
21: l_proc_param_tbl gme_post_migration.process_param_tab;
22: l_rsrc_txns_mig_tbl gme_post_migration.rsrc_txns_mig_tab;
23: l_rsrc_txns_tbl gme_post_migration.rsrc_txns_tab;
24: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
25: l_wip_entity_id NUMBER;
26: l_organization_id NUMBER;
27: l_old_batchstep_id NUMBER;

Line 644: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,

640: x_batch_header.organization_id := p_batch_header_mig.organization_id;
641: x_batch_header.terminate_reason_id := p_batch_header_mig.terminate_reason_id;
642: END build_batch_hdr;
643:
644: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,
645: x_mtl_dtl OUT NOCOPY gme_common_pvt.material_details_tab) IS
646: BEGIN
647: FOR i IN 1..p_mtl_dtl_mig.count LOOP
648: x_mtl_dtl(i).material_detail_id := p_mtl_dtl_mig(i).material_detail_id;

Line 726: PROCEDURE build_steps(p_steps_mig IN gme_post_migration.steps_mig_tab,

722: x_mtl_dtl(i).subinventory := p_mtl_dtl_mig(i).subinventory;
723: END LOOP;
724: END build_mtl_dtl;
725:
726: PROCEDURE build_steps(p_steps_mig IN gme_post_migration.steps_mig_tab,
727: x_steps OUT NOCOPY gme_common_pvt.steps_tab) IS
728: BEGIN
729: FOR i IN 1..p_steps_mig.count LOOP
730: x_steps(i).batch_id := p_steps_mig(i).batch_id;

Line 807: PROCEDURE build_activities(p_activities_mig IN gme_post_migration.activ_mig_tab,

803: x_steps(i).volume_ref_um := p_steps_mig(i).volume_ref_um;
804: END LOOP;
805: END build_steps;
806:
807: PROCEDURE build_activities(p_activities_mig IN gme_post_migration.activ_mig_tab,
808: x_activities IN OUT NOCOPY gme_common_pvt.activities_tab) IS
809: l_cnt NUMBER := 0;
810: BEGIN
811: l_cnt := x_activities.count;

Line 871: PROCEDURE build_resources(p_resources_mig IN gme_post_migration.rsrc_mig_tab,

867: x_activities(l_cnt).material_ind := p_activities_mig(i).material_ind;
868: END LOOP;
869: END build_activities;
870:
871: PROCEDURE build_resources(p_resources_mig IN gme_post_migration.rsrc_mig_tab,
872: x_resources IN OUT NOCOPY gme_common_pvt.resources_tab) IS
873: l_cnt NUMBER := 0;
874: BEGIN
875: l_cnt := x_resources.count;

Line 961: PROCEDURE build_parameters(p_parameters_mig IN gme_post_migration.process_param_mig_tab,

957: x_resources(l_cnt).usage_um := p_resources_mig(i).usage_um;
958: END LOOP;
959: END build_resources;
960:
961: PROCEDURE build_parameters(p_parameters_mig IN gme_post_migration.process_param_mig_tab,
962: x_parameters IN OUT NOCOPY gme_post_migration.process_param_tab) IS
963: l_cnt NUMBER := 0;
964: BEGIN
965: l_cnt := x_parameters.count;

Line 962: x_parameters IN OUT NOCOPY gme_post_migration.process_param_tab) IS

958: END LOOP;
959: END build_resources;
960:
961: PROCEDURE build_parameters(p_parameters_mig IN gme_post_migration.process_param_mig_tab,
962: x_parameters IN OUT NOCOPY gme_post_migration.process_param_tab) IS
963: l_cnt NUMBER := 0;
964: BEGIN
965: l_cnt := x_parameters.count;
966: FOR i IN 1..p_parameters_mig.count LOOP

Line 1021: PROCEDURE build_rsrc_txns(p_rsrc_txns_mig IN gme_post_migration.rsrc_txns_mig_tab,

1017: x_parameters(l_cnt).parameter_uom := p_parameters_mig(i).parameter_uom;
1018: END LOOP;
1019: END build_parameters;
1020:
1021: PROCEDURE build_rsrc_txns(p_rsrc_txns_mig IN gme_post_migration.rsrc_txns_mig_tab,
1022: x_rsrc_txns IN OUT NOCOPY gme_post_migration.rsrc_txns_tab) IS
1023: l_cnt NUMBER := 0;
1024: BEGIN
1025: l_cnt := x_rsrc_txns.count;

Line 1022: x_rsrc_txns IN OUT NOCOPY gme_post_migration.rsrc_txns_tab) IS

1018: END LOOP;
1019: END build_parameters;
1020:
1021: PROCEDURE build_rsrc_txns(p_rsrc_txns_mig IN gme_post_migration.rsrc_txns_mig_tab,
1022: x_rsrc_txns IN OUT NOCOPY gme_post_migration.rsrc_txns_tab) IS
1023: l_cnt NUMBER := 0;
1024: BEGIN
1025: l_cnt := x_rsrc_txns.count;
1026: FOR i IN 1..p_rsrc_txns_mig.count LOOP

Line 3579: END gme_post_migration;

3575: IF (g_debug <= gme_debug.g_log_procedure) THEN
3576: gme_debug.put_line('End procedure '||l_api_name);
3577: END IF;
3578: END insert_lab_lots;
3579: END gme_post_migration;