APPS.GMD_ROUTING_DESIGNER_PKG dependencies on GMD_ROUTINGS_PUB

Line 247: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

243: l_message_list VARCHAR2(2000);
244: l_message VARCHAR2(1000);
245: l_dummy NUMBER;
246: INSERT_STEP_DEP_EXCEPTION EXCEPTION;
247: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
248:
249: BEGIN
250:
251: x_return_code := 'S';

Line 361: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

357: l_message VARCHAR2(1000);
358: l_dummy NUMBER;
359: UPDATE_STEP_DEP_EXCEPTION EXCEPTION;
360: RECORD_CHANGED_EXCEPTION EXCEPTION;
361: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
362:
363: CURSOR Cur_Get_Step_Dep IS
364: SELECT *
365: FROM fm_rout_dep

Line 619: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

615: UPDATE_ROUTING_EXCEPTION EXCEPTION;
616: RECORD_CHANGED_EXCEPTION EXCEPTION;
617: l_rec Cur_get_routing%ROWTYPE;
618: l_enforce_step_dep NUMBER;
619: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
620: l_return_status VARCHAR2(2);
621: l_msg_count NUMBER;
622: l_msg_data VARCHAR2(2000);
623: l_message_count NUMBER;

Line 697: GMD_ROUTINGS_PUB.update_routing

693: l_update_table(17).p_col_to_update := 'last_update_login';
694: l_update_table(17).p_value := p_user_id;
695:
696:
697: GMD_ROUTINGS_PUB.update_routing
698: ( p_api_version => 1
699: , p_init_msg_list => TRUE
700: , p_commit => FALSE
701: , p_routing_id => p_routing_id

Line 909: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

905: l_message_list VARCHAR2(2000);
906: l_message VARCHAR2(1000);
907: l_dummy NUMBER;
908: INSERT_STEP_EXCEPTION EXCEPTION;
909: l_routings_step_dep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
910:
911: BEGIN
912:
913: x_error_msg := '';

Line 1016: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;

1012: l_message_count NUMBER;
1013: l_message_list VARCHAR2(2000);
1014: l_message VARCHAR2(1000);
1015: l_dummy NUMBER;
1016: l_update_table GMD_ROUTINGS_PUB.update_tbl_type;
1017: UPDATE_STEP_EXCEPTION EXCEPTION;
1018: RECORD_CHANGED_EXCEPTION EXCEPTION;
1019:
1020: CURSOR Cur_get_step IS

Line 2300: GMD_ROUTINGS_PUB.delete_routing

2296: END IF;
2297:
2298: CLOSE Cur_get_routing;
2299:
2300: GMD_ROUTINGS_PUB.delete_routing
2301: ( p_api_version => 1
2302: , p_init_msg_list => TRUE
2303: , p_commit => TRUE
2304: , p_routing_id => p_routing_id

Line 2397: GMD_ROUTINGS_PUB.undelete_routing

2393: RAISE RECORD_CHANGED_EXCEPTION;
2394: END IF;
2395: CLOSE Cur_get_routing;
2396:
2397: GMD_ROUTINGS_PUB.undelete_routing
2398: ( p_api_version => 1
2399: , p_init_msg_list => TRUE
2400: , p_commit => TRUE
2401: , p_routing_id => p_routing_id