APPS.JTF_RS_SRP_TERRITORIES_PKG dependencies on JTF_RS_SRP_TERRITORIES

Line 1: package body JTF_RS_SRP_TERRITORIES_PKG as

1: package body JTF_RS_SRP_TERRITORIES_PKG as
2: /* $Header: jtfrstib.pls 120.0 2005/05/11 08:22:17 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SALESREP_TERRITORY_ID in NUMBER,

Line 34: cursor C is select ROWID from JTF_RS_SRP_TERRITORIES

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from JTF_RS_SRP_TERRITORIES
35: where SALESREP_TERRITORY_ID = X_SALESREP_TERRITORY_ID
36: ;
37: begin
38: insert into JTF_RS_SRP_TERRITORIES (

Line 38: insert into JTF_RS_SRP_TERRITORIES (

34: cursor C is select ROWID from JTF_RS_SRP_TERRITORIES
35: where SALESREP_TERRITORY_ID = X_SALESREP_TERRITORY_ID
36: ;
37: begin
38: insert into JTF_RS_SRP_TERRITORIES (
39: SALESREP_TERRITORY_ID,
40: LAST_UPDATE_DATE,
41: LAST_UPDATED_BY,
42: CREATION_DATE,

Line 115: from JTF_RS_SRP_TERRITORIES

111: X_OBJECT_VERSION_NUMBER in NUMBER
112: ) is
113: cursor c1 is select
114: OBJECT_VERSION_NUMBER
115: from JTF_RS_SRP_TERRITORIES
116: where SALESREP_TERRITORY_ID = X_SALESREP_TERRITORY_ID
117: for update of SALESREP_TERRITORY_ID nowait;
118: tlinfo c1%rowtype ;
119: begin

Line 169: update JTF_RS_SRP_TERRITORIES set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update JTF_RS_SRP_TERRITORIES set
170: SALESREP_ID = X_SALESREP_ID,
171: TERRITORY_ID = X_TERRITORY_ID,
172: STATUS = X_STATUS,
173: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 207: delete from JTF_RS_SRP_TERRITORIES

203: procedure DELETE_ROW (
204: X_SALESREP_TERRITORY_ID in NUMBER
205: ) is
206: begin
207: delete from JTF_RS_SRP_TERRITORIES
208: where SALESREP_TERRITORY_ID = X_SALESREP_TERRITORY_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 216: end JTF_RS_SRP_TERRITORIES_PKG;

212: end if;
213:
214: end DELETE_ROW;
215:
216: end JTF_RS_SRP_TERRITORIES_PKG;