APPS.JTF_TERR_CNR_GROUPS_PKG dependencies on JTF_TERR_CNR_GROUPS

Line 1: PACKAGE BODY JTF_TERR_CNR_GROUPS_PKG AS

1: PACKAGE BODY JTF_TERR_CNR_GROUPS_PKG AS
2: /* $Header: jtfvtcgb.pls 120.0 2005/06/02 18:22:38 appldev ship $ */
3:
4: -- 01/23/01 Amit Patel - Created package body for JTF_TERR_CNR_GROUPS_PKG
5:

Line 4: -- 01/23/01 Amit Patel - Created package body for JTF_TERR_CNR_GROUPS_PKG

1: PACKAGE BODY JTF_TERR_CNR_GROUPS_PKG AS
2: /* $Header: jtfvtcgb.pls 120.0 2005/06/02 18:22:38 appldev ship $ */
3:
4: -- 01/23/01 Amit Patel - Created package body for JTF_TERR_CNR_GROUPS_PKG
5:
6: PROCEDURE Insert_Row(
7: x_Rowid IN OUT NOCOPY VARCHAR2,
8: x_CNR_GROUP_ID IN OUT NOCOPY NUMBER,

Line 33: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUPS

29: x_ATTRIBUTE13 IN VARCHAR2,
30: x_ATTRIBUTE14 IN VARCHAR2,
31: x_ATTRIBUTE15 IN VARCHAR2
32: )IS
33: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUPS
34: WHERE CNR_GROUP_ID = x_CNR_GROUP_ID;
35: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUPS_s.nextval FROM sys.dual;
36: BEGIN
37: If (x_CNR_GROUP_ID IS NULL) then

Line 35: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUPS_s.nextval FROM sys.dual;

31: x_ATTRIBUTE15 IN VARCHAR2
32: )IS
33: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUPS
34: WHERE CNR_GROUP_ID = x_CNR_GROUP_ID;
35: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUPS_s.nextval FROM sys.dual;
36: BEGIN
37: If (x_CNR_GROUP_ID IS NULL) then
38: OPEN C2;
39: FETCH C2 INTO x_CNR_GROUP_ID;

Line 42: INSERT INTO JTF_TERR_CNR_GROUPS(

38: OPEN C2;
39: FETCH C2 INTO x_CNR_GROUP_ID;
40: CLOSE C2;
41: End If;
42: INSERT INTO JTF_TERR_CNR_GROUPS(
43: CNR_GROUP_ID,
44: LAST_UPDATED_BY,
45: LAST_UPDATE_DATE,
46: CREATED_BY,

Line 105: DELETE FROM JTF_TERR_CNR_GROUPS

101:
102: PROCEDURE Delete_Row( x_CNR_GROUP_ID IN NUMBER
103: ) IS
104: BEGIN
105: DELETE FROM JTF_TERR_CNR_GROUPS
106: WHERE CNR_GROUP_ID = x_CNR_GROUP_ID;
107: If (SQL%NOTFOUND) then
108: RAISE NO_DATA_FOUND;
109: End If;

Line 142: Update JTF_TERR_CNR_GROUPS

138: x_ATTRIBUTE14 IN VARCHAR2,
139: x_ATTRIBUTE15 IN VARCHAR2
140: ) IS
141: BEGIN
142: Update JTF_TERR_CNR_GROUPS
143: SET
144: CNR_GROUP_ID = decode( x_CNR_GROUP_ID, FND_API.G_MISS_NUM,CNR_GROUP_ID,x_CNR_GROUP_ID),
145: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
146: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

Line 206: FROM JTF_TERR_CNR_GROUPS

202: x_ATTRIBUTE15 IN VARCHAR2
203: ) IS
204: CURSOR C IS
205: SELECT *
206: FROM JTF_TERR_CNR_GROUPS
207: WHERE CNR_GROUP_ID = x_CNR_GROUP_ID
208: FOR UPDATE of CNR_GROUP_ID NOWAIT;
209: Recinfo C%ROWTYPE;
210: BEGIN

Line 300: END JTF_TERR_CNR_GROUPS_PKG;

296: APP_EXCEPTION.RAISE_EXCEPTION;
297: End If;
298: END Lock_Row;
299:
300: END JTF_TERR_CNR_GROUPS_PKG;