APPS.AMS_PS_POSTING_PVT dependencies on AMS_IBA_PS_POSTINGS_TL

Line 129: from AMS_IBA_PS_POSTINGS_TL ptl

125: END IF;
126:
127: BEGIN
128: select 'X' into l_tempchar
129: from AMS_IBA_PS_POSTINGS_TL ptl
130: where ptl.posting_name = p_ps_posting_rec.posting_name
131: and ptl.language = userenv('LANG');
132:
133: EXCEPTION

Line 408: from AMS_IBA_PS_POSTINGS_TL ptl

404: END IF;
405:
406: BEGIN
407: select 'X' into l_tempchar
408: from AMS_IBA_PS_POSTINGS_TL ptl
409: where ptl.posting_name = p_ps_posting_rec.posting_name
410: and ptl.language = userenv('LANG')
411: and p_ps_posting_rec.posting_id <> ptl.posting_id;
412:

Line 427: UPDATE AMS_IBA_PS_POSTINGS_TL SET

423: END IF;
424: RAISE FND_API.g_exc_error;
425: END IF;
426:
427: UPDATE AMS_IBA_PS_POSTINGS_TL SET
428: posting_name = decode( p_ps_posting_rec.posting_name, FND_API.G_MISS_CHAR, posting_name, p_ps_posting_rec.posting_name),
429: display_name = decode( p_ps_posting_rec.display_name, FND_API.G_MISS_CHAR, display_name, p_ps_posting_rec.display_name),
430: posting_description = decode( p_ps_posting_rec.posting_description, FND_API.G_MISS_CHAR, posting_description, p_ps_posting_rec.posting_description),
431: last_update_date = SYSDATE,

Line 596: DELETE FROM AMS_IBA_PS_POSTINGS_TL

592: END IF;
593: RAISE FND_API.g_exc_error;
594: END IF;
595:
596: DELETE FROM AMS_IBA_PS_POSTINGS_TL
597: WHERE posting_id = p_posting_id;
598:
599: IF (SQL%NOTFOUND) THEN
600: RAISE FND_API.g_exc_error;