APPS.JTF_CHANGED_TERR_PKG dependencies on JTF_CHANGED_TERR

Line 1: PACKAGE BODY JTF_CHANGED_TERR_PKG AS

1: PACKAGE BODY JTF_CHANGED_TERR_PKG AS
2: /* $Header: jtfvctrb.pls 115.7 2000/06/05 17:00:38 pkm ship $ */
3:
4: PROCEDURE Insert_Row(
5: px_TERR_ID IN OUT NUMBER,

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;

Line 430: FROM JTF_CHANGED_TERR

426:
427: IS
428: CURSOR C IS
429: SELECT *
430: FROM JTF_CHANGED_TERR
431: WHERE TERR_ID = p_TERR_ID
432: FOR UPDATE of TERR_ID NOWAIT;
433: Recinfo C%ROWTYPE;
434: BEGIN

Line 645: End JTF_CHANGED_TERR_PKG;

641: APP_EXCEPTION.RAISE_EXCEPTION;
642: End If;
643: END Lock_Row;
644:
645: End JTF_CHANGED_TERR_PKG;