1: PACKAGE BODY gme_create_step_pvt AS
2: /* $Header: GMEVCRSB.pls 120.25.12020000.3 2012/11/07 14:19:48 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_create_step_pvt';
5:
1: PACKAGE BODY gme_create_step_pvt AS
2: /* $Header: GMEVCRSB.pls 120.25.12020000.3 2012/11/07 14:19:48 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'gme_create_step_pvt';
5:
6: PROCEDURE create_batch_steps (
7: p_recipe_rout_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
8: ,p_recipe_rout_act_tbl IN gmd_recipe_fetch_pub.oprn_act_tbl
20: ,p_step_cmplt_date IN DATE := NULL
21: ,p_step_due_date IN DATE := NULL)
22: IS
23: -- Local variables
24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
21: ,p_step_due_date IN DATE := NULL)
22: IS
23: -- Local variables
24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
23: -- Local variables
24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
41: ();
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
41: ();
42: l_step_charge_rsrc_tab gme_create_step_pvt.step_charge_rsrc_tab;
43:
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
41: ();
42: l_step_charge_rsrc_tab gme_create_step_pvt.step_charge_rsrc_tab;
43:
44: TYPE l_batchstep_ids IS TABLE OF NUMBER
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
41: ();
42: l_step_charge_rsrc_tab gme_create_step_pvt.step_charge_rsrc_tab;
43:
44: TYPE l_batchstep_ids IS TABLE OF NUMBER
45: INDEX BY BINARY_INTEGER;
46:
1316: END IF;
1317:
1318: IF ( p_recipe_rout_step_tbl.COUNT = 1
1319: AND p_recipe_rout_step_tbl (1).routingstep_id IS NULL) THEN
1320: gme_create_step_pvt.calc_dates
1321: (p_gme_batch_header_rec => p_gme_batch_header_rec
1322: ,p_use_workday_cal => p_use_workday_cal
1323: ,p_contiguity_override => p_contiguity_override
1324: ,p_return_status => l_return_status
1329: IF l_return_status <> x_return_status THEN
1330: RAISE error_calc_dates;
1331: END IF;
1332: ELSE
1333: gme_create_step_pvt.calc_dates
1334: (p_gme_batch_header_rec => p_gme_batch_header_rec
1335: ,p_use_workday_cal => p_use_workday_cal
1336: ,p_contiguity_override => p_contiguity_override
1337: ,p_return_status => l_return_status);
1627: END create_batch_steps;
1628:
1629: PROCEDURE update_charges (
1630: p_batch_id IN NUMBER
1631: ,p_step_charge_rsrc_tab IN gme_create_step_pvt.step_charge_rsrc_tab
1632: ,x_return_status OUT NOCOPY VARCHAR2)
1633: IS
1634: x_charge_tab charge_tab;
1635: x_num_steps PLS_INTEGER;
3937: END IF;
3938:
3939: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3940: END insert_resource_txns;
3941: END gme_create_step_pvt;