APPS.JTF_TERR_CNR_GROUP_VALUES_PKG dependencies on JTF_TERR_CNR_GROUP_VALUES

Line 1: PACKAGE BODY JTF_TERR_CNR_GROUP_VALUES_PKG AS

1: PACKAGE BODY JTF_TERR_CNR_GROUP_VALUES_PKG AS
2: /* $Header: jtfvtcvb.pls 120.0 2005/06/02 18:22:40 appldev ship $ */
3:
4: -- 05/15/01 ARPATEL Created table handlers
5: -- 05/16/01 ARPATEL Added start_date_active and end_date_active

Line 24: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUP_VALUES

20: x_START_DATE_ACTIVE IN DATE,
21: x_END_DATE_ACTIVE IN DATE,
22: x_ORG_ID IN NUMBER
23: ) IS
24: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUP_VALUES
25: WHERE CNR_GROUP_VALUE_ID = x_CNR_GROUP_VALUE_ID;
26: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUP_VALUES_s.nextval FROM sys.dual;
27: BEGIN
28: If (x_CNR_GROUP_VALUE_ID IS NULL) then

Line 26: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUP_VALUES_s.nextval FROM sys.dual;

22: x_ORG_ID IN NUMBER
23: ) IS
24: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUP_VALUES
25: WHERE CNR_GROUP_VALUE_ID = x_CNR_GROUP_VALUE_ID;
26: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUP_VALUES_s.nextval FROM sys.dual;
27: BEGIN
28: If (x_CNR_GROUP_VALUE_ID IS NULL) then
29: OPEN C2;
30: FETCH C2 INTO x_CNR_GROUP_VALUE_ID;

Line 33: INSERT INTO JTF_TERR_CNR_GROUP_VALUES(

29: OPEN C2;
30: FETCH C2 INTO x_CNR_GROUP_VALUE_ID;
31: CLOSE C2;
32: End If;
33: INSERT INTO JTF_TERR_CNR_GROUP_VALUES(
34: CNR_GROUP_VALUE_ID,
35: LAST_UPDATED_BY,
36: LAST_UPDATE_DATE,
37: CREATED_BY,

Line 76: DELETE FROM JTF_TERR_CNR_GROUP_VALUES

72:
73: PROCEDURE Delete_Row( x_CNR_GROUP_VALUE_ID IN NUMBER
74: ) IS
75: BEGIN
76: DELETE FROM JTF_TERR_CNR_GROUP_VALUES
77: WHERE CNR_GROUP_VALUE_ID = x_CNR_GROUP_VALUE_ID;
78: If (SQL%NOTFOUND) then
79: RAISE NO_DATA_FOUND;
80: End If;

Line 102: Update JTF_TERR_CNR_GROUP_VALUES

98: x_END_DATE_ACTIVE IN DATE,
99: x_ORG_ID IN NUMBER
100: ) IS
101: BEGIN
102: Update JTF_TERR_CNR_GROUP_VALUES
103: SET
104: CNR_GROUP_VALUE_ID = decode( x_CNR_GROUP_VALUE_ID, FND_API.G_MISS_NUM,CNR_GROUP_VALUE_ID,x_CNR_GROUP_VALUE_ID),
105: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
106: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

Line 144: FROM JTF_TERR_CNR_GROUP_VALUES

140: x_ORG_ID IN NUMBER
141: ) IS
142: CURSOR C IS
143: SELECT *
144: FROM JTF_TERR_CNR_GROUP_VALUES
145: WHERE CNR_GROUP_VALUE_ID = x_CNR_GROUP_VALUE_ID
146: FOR UPDATE of CNR_GROUP_VALUE_ID NOWAIT;
147: Recinfo C%ROWTYPE;
148: BEGIN

Line 206: END JTF_TERR_CNR_GROUP_VALUES_PKG;

202: End If;
203: END Lock_Row;
204:
205:
206: END JTF_TERR_CNR_GROUP_VALUES_PKG;