[Home] [Help]
258: END IF;
259:
260: /* Validation 1. Check if this routing that is created does not exists
261: in the the database. The routing_id is the PK or Routing_no and version is
262: the unique key for this table (gmd_routings_b). */
263: GMDRTVAL_PUB.check_routing(pRouting_no => p_routings.routing_no
264: ,pRouting_vers => p_routings.routing_vers
265: ,xRouting_id => l_routing_id
266: ,xReturn_status => l_return_status);
695: END IF;
696:
697: /* Validation 1. Check if this routing that is updated does exists
698: in the the database. The routing_id is the PK or Routing_no and version is
699: the unique key for this table (gmd_routings_b). */
700: IF p_routing_id IS NOT NULL THEN
701: l_routing_id := p_routing_id;
702: ELSE
703: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
972: END IF;
973:
974: /* Validation :. Check if this routing that is deleted does exists
975: in the the database. The routing_id is the PK or Routing_no and version is
976: the unique key for this table (gmd_routings_b). */
977: IF p_routing_id IS NOT NULL THEN
978: l_routing_id := p_routing_id;
979: ELSE
980: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1137: END IF;
1138:
1139: /* Validation :. Check if this routing that is deleted does exists
1140: in the the database. The routing_id is the PK or Routing_no and version is
1141: the unique key for this table (gmd_routings_b). */
1142: IF p_routing_id IS NOT NULL THEN
1143: l_routing_id := p_routing_id;
1144: ELSE
1145: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1154: RAISE routing_undelete_failure;
1155: END IF;
1156: END IF;
1157:
1158: UPDATE gmd_routings_b
1159: SET delete_mark = 0
1160: WHERE routing_id = l_routing_id;
1161:
1162: fnd_msg_pub.count_and_get (