DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB dependencies on GMD_ROUTINGS_PUB

Line 296: l_routings_step_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_tab;

292: IS
293: l_routings_insert gmd_routings%ROWTYPE;
294: l_routings_step_rec fm_rout_dtl%ROWTYPE;
295: l_routings_step_dep_rec fm_rout_dep%ROWTYPE;
296: l_routings_step_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_tab;
297: l_routings_step_dep_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
298: l_routings_step_insert_ctr NUMBER :=1;
299: l_routings_step_dep_insert_ctr NUMBER :=1;
300: l_msg_count NUMBER;

Line 297: l_routings_step_dep_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

293: l_routings_insert gmd_routings%ROWTYPE;
294: l_routings_step_rec fm_rout_dtl%ROWTYPE;
295: l_routings_step_dep_rec fm_rout_dep%ROWTYPE;
296: l_routings_step_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_tab;
297: l_routings_step_dep_tbl_insert GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
298: l_routings_step_insert_ctr NUMBER :=1;
299: l_routings_step_dep_insert_ctr NUMBER :=1;
300: l_msg_count NUMBER;
301: l_msg VARCHAR2(1000);

Line 303: l_rout_tbl GMD_ROUTINGS_PUB.update_tbl_type;

299: l_routings_step_dep_insert_ctr NUMBER :=1;
300: l_msg_count NUMBER;
301: l_msg VARCHAR2(1000);
302: l_ret_status VARCHAR2(3);
303: l_rout_tbl GMD_ROUTINGS_PUB.update_tbl_type;
304: l_rout_rec GMD_ROUTINGS_PUB.update_table_rec_type;
305: BEGIN
306: IF p_routing_obj.ROUTING_ID IS NULL THEN
307: l_routings_insert.ROUTING_STATUS := p_routing_obj.ROUTING_STATUS;

Line 304: l_rout_rec GMD_ROUTINGS_PUB.update_table_rec_type;

300: l_msg_count NUMBER;
301: l_msg VARCHAR2(1000);
302: l_ret_status VARCHAR2(3);
303: l_rout_tbl GMD_ROUTINGS_PUB.update_tbl_type;
304: l_rout_rec GMD_ROUTINGS_PUB.update_table_rec_type;
305: BEGIN
306: IF p_routing_obj.ROUTING_ID IS NULL THEN
307: l_routings_insert.ROUTING_STATUS := p_routing_obj.ROUTING_STATUS;
308: l_routings_insert.ENFORCE_STEP_DEPENDENCY := p_routing_obj.ENFORCE_STEP_DEPENDENCY;

Line 440: GMD_ROUTINGS_PUB.insert_routing(

436: l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
437: l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
438: END LOOP;
439:
440: GMD_ROUTINGS_PUB.insert_routing(
441: p_api_version => 1
442: , p_init_msg_list => TRUE
443: , p_commit => FALSE
444: , p_routings => l_routings_insert

Line 634: GMD_ROUTINGS_PUB.update_routing

630: l_rout_rec.p_col_to_update := 'attribute30';
631: l_rout_rec.p_value := p_routing_obj.flex_obj.attribute30;
632: l_rout_tbl(59) := l_rout_rec;
633:
634: GMD_ROUTINGS_PUB.update_routing
635: ( p_api_version => 1
636: , p_init_msg_list => TRUE
637: , p_commit => FALSE
638: , p_routing_id => p_routing_obj.ROUTING_ID