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.20.12020000.4 2013/04/01 02:40:16 shalchen ship $ */
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 766: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,

762: x_batch_header.organization_id := p_batch_header_mig.organization_id;
763: x_batch_header.terminate_reason_id := p_batch_header_mig.terminate_reason_id;
764: END build_batch_hdr;
765:
766: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,
767: x_mtl_dtl OUT NOCOPY gme_common_pvt.material_details_tab) IS
768: BEGIN
769: FOR i IN 1..p_mtl_dtl_mig.count LOOP
770: x_mtl_dtl(i).material_detail_id := p_mtl_dtl_mig(i).material_detail_id;

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

844: x_mtl_dtl(i).subinventory := p_mtl_dtl_mig(i).subinventory;
845: END LOOP;
846: END build_mtl_dtl;
847:
848: PROCEDURE build_steps(p_steps_mig IN gme_post_migration.steps_mig_tab,
849: x_steps OUT NOCOPY gme_common_pvt.steps_tab) IS
850: BEGIN
851: FOR i IN 1..p_steps_mig.count LOOP
852: x_steps(i).batch_id := p_steps_mig(i).batch_id;

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

925: x_steps(i).volume_ref_um := p_steps_mig(i).volume_ref_um;
926: END LOOP;
927: END build_steps;
928:
929: PROCEDURE build_activities(p_activities_mig IN gme_post_migration.activ_mig_tab,
930: x_activities IN OUT NOCOPY gme_common_pvt.activities_tab) IS
931: l_cnt NUMBER := 0;
932: BEGIN
933: l_cnt := x_activities.count;

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

989: x_activities(l_cnt).material_ind := p_activities_mig(i).material_ind;
990: END LOOP;
991: END build_activities;
992:
993: PROCEDURE build_resources(p_resources_mig IN gme_post_migration.rsrc_mig_tab,
994: x_resources IN OUT NOCOPY gme_common_pvt.resources_tab) IS
995: l_cnt NUMBER := 0;
996: BEGIN
997: l_cnt := x_resources.count;

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

1079: x_resources(l_cnt).usage_um := p_resources_mig(i).usage_um;
1080: END LOOP;
1081: END build_resources;
1082:
1083: PROCEDURE build_parameters(p_parameters_mig IN gme_post_migration.process_param_mig_tab,
1084: x_parameters IN OUT NOCOPY gme_post_migration.process_param_tab) IS
1085: l_cnt NUMBER := 0;
1086: BEGIN
1087: l_cnt := x_parameters.count;

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

1080: END LOOP;
1081: END build_resources;
1082:
1083: PROCEDURE build_parameters(p_parameters_mig IN gme_post_migration.process_param_mig_tab,
1084: x_parameters IN OUT NOCOPY gme_post_migration.process_param_tab) IS
1085: l_cnt NUMBER := 0;
1086: BEGIN
1087: l_cnt := x_parameters.count;
1088: FOR i IN 1..p_parameters_mig.count LOOP

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

1139: x_parameters(l_cnt).parameter_uom := p_parameters_mig(i).parameter_uom;
1140: END LOOP;
1141: END build_parameters;
1142:
1143: PROCEDURE build_rsrc_txns(p_rsrc_txns_mig IN gme_post_migration.rsrc_txns_mig_tab,
1144: x_rsrc_txns IN OUT NOCOPY gme_post_migration.rsrc_txns_tab) IS
1145: l_cnt NUMBER := 0;
1146: BEGIN
1147: l_cnt := x_rsrc_txns.count;

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

1140: END LOOP;
1141: END build_parameters;
1142:
1143: PROCEDURE build_rsrc_txns(p_rsrc_txns_mig IN gme_post_migration.rsrc_txns_mig_tab,
1144: x_rsrc_txns IN OUT NOCOPY gme_post_migration.rsrc_txns_tab) IS
1145: l_cnt NUMBER := 0;
1146: BEGIN
1147: l_cnt := x_rsrc_txns.count;
1148: FOR i IN 1..p_rsrc_txns_mig.count LOOP

Line 4129: END gme_post_migration;

4125: IF (g_debug <= gme_debug.g_log_procedure) THEN
4126: gme_debug.put_line('End procedure '||l_api_name);
4127: END IF;
4128: END insert_lab_lots;
4129: END gme_post_migration;