APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on WMS_DOCK_APPOINTMENTS_TL

Line 112: UPDATE wms_dock_appointments_tl

108: WHERE
109: DOCK_APPOINTMENT_ID = p_dock_appointments_v_rec.DOCK_APPOINTMENT_ID;
110:
111:
112: UPDATE wms_dock_appointments_tl
113: SET
114: SUBJECT = p_dock_appointments_v_rec.SUBJECT,
115: DESCRIPTION = p_dock_appointments_v_rec.DESCRIPTION,
116: SOURCE_LANG = USERENV('LANG'),

Line 177: UPDATE wms_dock_appointments_tl

173: WHERE
174: REP_ORIGIN = p_orig_id;
175:
176:
177: UPDATE wms_dock_appointments_tl
178: SET
179: SUBJECT = p_dock_appointments_v_rec.SUBJECT,
180: DESCRIPTION = p_dock_appointments_v_rec.DESCRIPTION,
181: SOURCE_LANG = USERENV('LANG'),

Line 268: INSERT INTO wms_dock_appointments_tl

264: p_dock_appointments_v_rec.REP_END_DATE,
265: p_dock_appointments_v_rec.DOCK_APPOINTMENT_ID,
266: p_dock_appointments_v_rec.APPOINTMENT_STATUS);
267:
268: INSERT INTO wms_dock_appointments_tl
269: (DOCK_APPOINTMENT_ID,
270: SUBJECT,
271: DESCRIPTION,
272: LANGUAGE,

Line 294: FROM wms_dock_appointments_tl t

290: FROM fnd_languages l
291: WHERE l.installed_flag IN ('I', 'B')
292: AND NOT exists
293: (SELECT NULL
294: FROM wms_dock_appointments_tl t
295: WHERE t.dock_appointment_id = p_dock_appointments_v_rec.dock_appointment_id
296: AND t.language = l.language_code);
297:
298: EXCEPTION

Line 372: INSERT INTO wms_dock_appointments_tl

368: p_dock_appointments_v_rec.REP_END_DATE,
369: p_rep_orig_id,
370: p_dock_appointments_v_rec.APPOINTMENT_STATUS);
371:
372: INSERT INTO wms_dock_appointments_tl
373: (DOCK_APPOINTMENT_ID,
374: SUBJECT,
375: DESCRIPTION,
376: LANGUAGE,

Line 398: FROM wms_dock_appointments_tl t

394: FROM fnd_languages l
395: WHERE l.installed_flag IN ('I', 'B')
396: AND NOT exists
397: (SELECT NULL
398: FROM wms_dock_appointments_tl t
399: WHERE t.dock_appointment_id = p_dock_appointments_v_rec.dock_appointment_id
400: AND t.language = l.language_code);
401:
402: EXCEPTION

Line 434: DELETE wms_dock_appointments_tl

430:
431: DELETE wms_dock_appointments_b
432: WHERE DOCK_APPOINTMENT_ID = p_dock_appointment_id;
433:
434: DELETE wms_dock_appointments_tl
435: WHERE DOCK_APPOINTMENT_ID = p_dock_appointment_id;
436:
437: EXCEPTION
438: WHEN OTHERS THEN

Line 465: DELETE wms_dock_appointments_tl

461: SAVEPOINT delete_rep_dock_sp;
462: -- Initialize API return status to success
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: DELETE wms_dock_appointments_tl
466: WHERE dock_appointment_id IN
467: (SELECT dock_appointment_id
468: FROM wms_dock_appointments_b
469: WHERE REP_ORIGIN = p_rep_orig_id);

Line 491: DELETE FROM WMS_DOCK_APPOINTMENTS_TL T

487:
488: PROCEDURE ADD_LANGUAGE
489: IS
490: BEGIN
491: DELETE FROM WMS_DOCK_APPOINTMENTS_TL T
492: WHERE NOT exists
493: (SELECT NULL
494: FROM WMS_DOCK_APPOINTMENTS_B B
495: WHERE B.DOCK_APPOINTMENT_ID = T.DOCK_APPOINTMENT_ID

Line 498: UPDATE WMS_DOCK_APPOINTMENTS_TL T

494: FROM WMS_DOCK_APPOINTMENTS_B B
495: WHERE B.DOCK_APPOINTMENT_ID = T.DOCK_APPOINTMENT_ID
496: );
497:
498: UPDATE WMS_DOCK_APPOINTMENTS_TL T
499: SET (
500: SUBJECT,
501: DESCRIPTION
502: ) = (SELECT

Line 505: FROM WMS_DOCK_APPOINTMENTS_TL B

501: DESCRIPTION
502: ) = (SELECT
503: B.SUBJECT,
504: B.DESCRIPTION
505: FROM WMS_DOCK_APPOINTMENTS_TL B
506: WHERE B.DOCK_APPOINTMENT_ID = T.DOCK_APPOINTMENT_ID
507: AND B.LANGUAGE = T.SOURCE_LANG)
508: WHERE (
509: T.DOCK_APPOINTMENT_ID,

Line 514: FROM WMS_DOCK_APPOINTMENTS_TL SUBB, WMS_DOCK_APPOINTMENTS_TL SUBT

510: T.LANGUAGE
511: ) IN (SELECT
512: SUBT.DOCK_APPOINTMENT_ID,
513: SUBT.LANGUAGE
514: FROM WMS_DOCK_APPOINTMENTS_TL SUBB, WMS_DOCK_APPOINTMENTS_TL SUBT
515: WHERE SUBB.DOCK_APPOINTMENT_ID = SUBT.DOCK_APPOINTMENT_ID
516: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
517: AND (SUBB.SUBJECT <> SUBT.SUBJECT
518: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 524: INSERT INTO WMS_DOCK_APPOINTMENTS_TL

520: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
521: )
522: );
523:
524: INSERT INTO WMS_DOCK_APPOINTMENTS_TL
525: (DOCK_APPOINTMENT_ID,
526: SUBJECT,
527: DESCRIPTION,
528: CREATED_BY,

Line 546: FROM WMS_DOCK_APPOINTMENTS_TL B, FND_LANGUAGES L

542: B.LAST_UPDATE_DATE,
543: B.LAST_UPDATE_LOGIN,
544: L.LANGUAGE_CODE,
545: B.SOURCE_LANG
546: FROM WMS_DOCK_APPOINTMENTS_TL B, FND_LANGUAGES L
547: WHERE L.INSTALLED_FLAG IN ('I', 'B')
548: AND B.LANGUAGE = userenv('LANG')
549: AND NOT exists
550: (SELECT NULL

Line 551: FROM WMS_DOCK_APPOINTMENTS_TL T

547: WHERE L.INSTALLED_FLAG IN ('I', 'B')
548: AND B.LANGUAGE = userenv('LANG')
549: AND NOT exists
550: (SELECT NULL
551: FROM WMS_DOCK_APPOINTMENTS_TL T
552: WHERE T.DOCK_APPOINTMENT_ID = B.DOCK_APPOINTMENT_ID
553: AND T.LANGUAGE = L.LANGUAGE_CODE);
554:
555: END ADD_LANGUAGE;

Line 605: from WMS_DOCK_APPOINTMENTS_TL

601: cursor c1 is select
602: SUBJECT,
603: DESCRIPTION,
604: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
605: from WMS_DOCK_APPOINTMENTS_TL
606: where DOCK_APPOINTMENT_ID = X_DOCK_APPOINTMENT_ID
607: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
608: for update of DOCK_APPOINTMENT_ID nowait;
609: begin