57: X_LAST_UPDATE_LOGIN IN NUMBER )
58: IS
59: CURSOR C
60: IS
61: SELECT ROWID FROM CSD_RECALL_HEADERS_B WHERE RECALL_ID = X_RECALL_ID ;
62: BEGIN
63: INSERT
64: INTO CSD_RECALL_HEADERS_B
65: (
60: IS
61: SELECT ROWID FROM CSD_RECALL_HEADERS_B WHERE RECALL_ID = X_RECALL_ID ;
62: BEGIN
63: INSERT
64: INTO CSD_RECALL_HEADERS_B
65: (
66: RECALL_ID,
67: RECALL_NUMBER,
68: REPORTED_DATE,
298: RECALL_REVISION,
299: ESTIMATED_NO_OF_UNITS,
300: CONSUMER_CONTACT,
301: DISCOVERY_DATE
302: FROM CSD_RECALL_HEADERS_B
303: WHERE RECALL_ID = X_RECALL_ID FOR UPDATE OF RECALL_ID nowait;
304:
305: recinfo c%rowtype;
306: CURSOR c1
451: X_LAST_UPDATED_BY IN NUMBER,
452: X_LAST_UPDATE_LOGIN IN NUMBER )
453: IS
454: BEGIN
455: UPDATE CSD_RECALL_HEADERS_B
456: SET RECALL_NUMBER = X_RECALL_NUMBER,
457: REPORTED_DATE = X_REPORTED_DATE,
458: INIT_DATE = X_INIT_DATE,
459: COMP_DATE = X_COMP_DATE,
526: DELETE FROM CSD_RECALL_HEADERS_TL WHERE RECALL_ID = X_RECALL_ID;
527: IF (sql%notfound) THEN
528: raise no_data_found;
529: END IF;
530: DELETE FROM CSD_RECALL_HEADERS_B WHERE RECALL_ID = X_RECALL_ID;
531: IF (sql%notfound) THEN
532: raise no_data_found;
533: END IF;
534: END DELETE_ROW;
538: BEGIN
539: DELETE
540: FROM CSD_RECALL_HEADERS_TL T
541: WHERE NOT EXISTS
542: (SELECT NULL FROM CSD_RECALL_HEADERS_B B WHERE B.RECALL_ID = T.RECALL_ID
543: );
544: UPDATE CSD_RECALL_HEADERS_TL T
545: SET
546: (