DBA Data[Home] [Help]

APPS.JTF_CHANGED_TERR_PKG dependencies on JTF_CHANGED_TERR_ALL

Line 73: INSERT INTO JTF_CHANGED_TERR_ALL(

69: p_ORG_ID NUMBER)
70:
71: IS
72: BEGIN
73: INSERT INTO JTF_CHANGED_TERR_ALL(
74: TERR_ID,
75: TERR_VALUE_ID,
76: TRIGGER_MODE,
77: ACTION,

Line 276: Update JTF_CHANGED_TERR_ALL

272: P_ORG_ID NUMBER)
273:
274: IS
275: BEGIN
276: Update JTF_CHANGED_TERR_ALL
277: SET
278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),

Line 353: DELETE FROM JTF_CHANGED_TERR_ALL

349: PROCEDURE Delete_Row(
350: p_TERR_ID NUMBER)
351: IS
352: BEGIN
353: DELETE FROM JTF_CHANGED_TERR_ALL
354: WHERE TERR_ID = p_TERR_ID;
355: If (SQL%NOTFOUND) then
356: RAISE NO_DATA_FOUND;
357: End If;