APPS.CSD_RECALL_HEADERS_PKG dependencies on CSD_RECALL_HEADERS_TL

Line 155: INTO CSD_RECALL_HEADERS_TL

151: X_LAST_UPDATED_BY,
152: X_LAST_UPDATE_LOGIN
153: );
154: INSERT
155: INTO CSD_RECALL_HEADERS_TL
156: (
157: RECALL_ID,
158: DESCRIPTION,
159: DISCOVERY_METHOD,

Line 200: FROM CSD_RECALL_HEADERS_TL T

196: FROM FND_LANGUAGES L
197: WHERE L.INSTALLED_FLAG IN ('I', 'B')
198: AND NOT EXISTS
199: (SELECT NULL
200: FROM CSD_RECALL_HEADERS_TL T
201: WHERE T.RECALL_ID = X_RECALL_ID
202: AND T.LANGUAGE = L.LANGUAGE_CODE
203: );
204:

Line 319: FROM CSD_RECALL_HEADERS_TL

315: RECALL_NAME,
316: RECALL_REASON,
317: RECALL_RISK,
318: DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
319: FROM CSD_RECALL_HEADERS_TL
320: WHERE RECALL_ID = X_RECALL_ID
321: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG) FOR UPDATE OF RECALL_ID nowait;
322: BEGIN
323: OPEN c;

Line 499: UPDATE CSD_RECALL_HEADERS_TL

495: WHERE RECALL_ID = X_RECALL_ID;
496: IF (sql%notfound) THEN
497: raise no_data_found;
498: END IF;
499: UPDATE CSD_RECALL_HEADERS_TL
500: SET DESCRIPTION = X_DESCRIPTION,
501: DISCOVERY_METHOD = X_DISCOVERY_METHOD,
502: INCIDENTS_AND_ISSUES = X_INCIDENTS_AND_ISSUES,
503: CONSEQUENCE = X_CONSEQUENCE,

Line 526: DELETE FROM CSD_RECALL_HEADERS_TL WHERE RECALL_ID = X_RECALL_ID;

522: (
523: X_RECALL_ID IN NUMBER )
524: IS
525: BEGIN
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;

Line 540: FROM CSD_RECALL_HEADERS_TL T

536: PROCEDURE ADD_LANGUAGE
537: IS
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

Line 544: UPDATE CSD_RECALL_HEADERS_TL T

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: (
547: DESCRIPTION,
548: DISCOVERY_METHOD,

Line 569: FROM CSD_RECALL_HEADERS_TL B

565: B.REG_AGENCY_COMMENTS,
566: B.RECALL_NAME,
567: B.RECALL_REASON,
568: B.RECALL_RISK
569: FROM CSD_RECALL_HEADERS_TL B
570: WHERE B.RECALL_ID = T.RECALL_ID
571: AND B.LANGUAGE = T.SOURCE_LANG
572: )
573: WHERE ( T.RECALL_ID, T.LANGUAGE ) IN

Line 576: FROM CSD_RECALL_HEADERS_TL SUBB,

572: )
573: WHERE ( T.RECALL_ID, T.LANGUAGE ) IN
574: (SELECT SUBT.RECALL_ID,
575: SUBT.LANGUAGE
576: FROM CSD_RECALL_HEADERS_TL SUBB,
577: CSD_RECALL_HEADERS_TL SUBT
578: WHERE SUBB.RECALL_ID = SUBT.RECALL_ID
579: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
580: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 577: CSD_RECALL_HEADERS_TL SUBT

573: WHERE ( T.RECALL_ID, T.LANGUAGE ) IN
574: (SELECT SUBT.RECALL_ID,
575: SUBT.LANGUAGE
576: FROM CSD_RECALL_HEADERS_TL SUBB,
577: CSD_RECALL_HEADERS_TL SUBT
578: WHERE SUBB.RECALL_ID = SUBT.RECALL_ID
579: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
580: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
581: OR (SUBB.DESCRIPTION IS NULL

Line 633: INTO CSD_RECALL_HEADERS_TL

629: AND SUBT.RECALL_RISK IS NULL) )
630: );
631:
632: INSERT
633: INTO CSD_RECALL_HEADERS_TL
634: (
635: RECALL_ID,
636: DESCRIPTION,
637: DISCOVERY_METHOD,

Line 676: FROM CSD_RECALL_HEADERS_TL B,

672: B.LAST_UPDATE_DATE,
673: B.LAST_UPDATE_LOGIN,
674: L.LANGUAGE_CODE,
675: B.SOURCE_LANG
676: FROM CSD_RECALL_HEADERS_TL B,
677: FND_LANGUAGES L
678: WHERE L.INSTALLED_FLAG IN ('I', 'B')
679: AND B.LANGUAGE = userenv('LANG')
680: AND NOT EXISTS

Line 682: FROM CSD_RECALL_HEADERS_TL T

678: WHERE L.INSTALLED_FLAG IN ('I', 'B')
679: AND B.LANGUAGE = userenv('LANG')
680: AND NOT EXISTS
681: (SELECT NULL
682: FROM CSD_RECALL_HEADERS_TL T
683: WHERE T.RECALL_ID = B.RECALL_ID
684: AND T.LANGUAGE = L.LANGUAGE_CODE
685: );
686: