[Home] [Help]
247: END IF;
248:
249: /* Validation 1. Check if this routing that is created does not exists
250: in the the database. The routing_id is the PK or Routing_no and version is
251: the unique key for this table (gmd_routings_b). */
252: GMDRTVAL_PUB.check_routing(pRouting_no => p_routings.routing_no
253: ,pRouting_vers => p_routings.routing_vers
254: ,xRouting_id => l_routing_id
255: ,xReturn_status => l_return_status);
659: END IF;
660:
661: /* Validation 1. Check if this routing that is updated does exists
662: in the the database. The routing_id is the PK or Routing_no and version is
663: the unique key for this table (gmd_routings_b). */
664: IF p_routing_id IS NOT NULL THEN
665: l_routing_id := p_routing_id;
666: ELSE
667: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
925: END IF;
926:
927: /* Validation :. Check if this routing that is deleted does exists
928: in the the database. The routing_id is the PK or Routing_no and version is
929: the unique key for this table (gmd_routings_b). */
930: IF p_routing_id IS NOT NULL THEN
931: l_routing_id := p_routing_id;
932: ELSE
933: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1090: END IF;
1091:
1092: /* Validation :. Check if this routing that is deleted does exists
1093: in the the database. The routing_id is the PK or Routing_no and version is
1094: the unique key for this table (gmd_routings_b). */
1095: IF p_routing_id IS NOT NULL THEN
1096: l_routing_id := p_routing_id;
1097: ELSE
1098: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1107: RAISE routing_undelete_failure;
1108: END IF;
1109: END IF;
1110:
1111: UPDATE gmd_routings_b
1112: SET delete_mark = 0
1113: WHERE routing_id = l_routing_id;
1114:
1115: fnd_msg_pub.count_and_get (