1: PACKAGE BODY gme_create_step_pvt AS
2: /* $Header: GMEVCRSB.pls 120.16.12010000.1 2008/07/25 10:29:57 appldev 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.16.12010000.1 2008/07/25 10:29:57 appldev 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:
1231: END IF;
1232:
1233: IF ( p_recipe_rout_step_tbl.COUNT = 1
1234: AND p_recipe_rout_step_tbl (1).routingstep_id IS NULL) THEN
1235: gme_create_step_pvt.calc_dates
1236: (p_gme_batch_header_rec => p_gme_batch_header_rec
1237: ,p_use_workday_cal => p_use_workday_cal
1238: ,p_contiguity_override => p_contiguity_override
1239: ,p_return_status => l_return_status
1244: IF l_return_status <> x_return_status THEN
1245: RAISE error_calc_dates;
1246: END IF;
1247: ELSE
1248: gme_create_step_pvt.calc_dates
1249: (p_gme_batch_header_rec => p_gme_batch_header_rec
1250: ,p_use_workday_cal => p_use_workday_cal
1251: ,p_contiguity_override => p_contiguity_override
1252: ,p_return_status => l_return_status);
1542: END create_batch_steps;
1543:
1544: PROCEDURE update_charges (
1545: p_batch_id IN NUMBER
1546: ,p_step_charge_rsrc_tab IN gme_create_step_pvt.step_charge_rsrc_tab
1547: ,x_return_status OUT NOCOPY VARCHAR2)
1548: IS
1549: x_charge_tab charge_tab;
1550: x_num_steps PLS_INTEGER;
3428: END IF;
3429:
3430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3431: END insert_resource_txns;
3432: END gme_create_step_pvt;