APPS.JTF_RS_SALESREPS_PKG dependencies on JTF_RS_SALESREPS

Line 1: package body JTF_RS_SALESREPS_PKG as

1: package body JTF_RS_SALESREPS_PKG as
2: /* $Header: jtfrstsb.pls 120.1 2005/06/23 22:46:47 baianand ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SALESREP_ID in NUMBER,

Line 45: cursor C is select ROWID from JTF_RS_SALESREPS

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from JTF_RS_SALESREPS
46: where SALESREP_ID = X_SALESREP_ID
47: ;
48: begin
49:

Line 52: insert into JTF_RS_SALESREPS (

48: begin
49:
50: --dbms_output.put_line ('Inside Table Handler');
51:
52: insert into JTF_RS_SALESREPS (
53: SALESREP_ID,
54: RESOURCE_ID,
55: LAST_UPDATE_DATE,
56: LAST_UPDATED_BY,

Line 154: from JTF_RS_SALESREPS

150: X_OBJECT_VERSION_NUMBER in NUMBER
151: ) is
152: cursor c1 is select
153: OBJECT_VERSION_NUMBER
154: from JTF_RS_SALESREPS
155: where SALESREP_ID = X_SALESREP_ID
156: and NVL(ORG_ID,-99) = NVL(X_ORG_ID,-99)
157: for update of SALESREP_ID nowait;
158: tlinfo c1%rowtype ;

Line 220: update JTF_RS_SALESREPS set

216: X_LAST_UPDATED_BY in NUMBER,
217: X_LAST_UPDATE_LOGIN in NUMBER
218: ) is
219: begin
220: update JTF_RS_SALESREPS set
221: RESOURCE_ID = X_RESOURCE_ID,
222: SALES_CREDIT_TYPE_ID = X_SALES_CREDIT_TYPE_ID,
223: NAME = X_NAME,
224: STATUS = X_STATUS,

Line 270: delete from JTF_RS_SALESREPS

266: X_SALESREP_ID in NUMBER,
267: X_ORG_ID in NUMBER
268: ) is
269: begin
270: delete from JTF_RS_SALESREPS
271: where SALESREP_ID = X_SALESREP_ID
272: and NVL(ORG_ID,-99) = NVL(X_ORG_ID,-99);
273:
274: if (sql%notfound) then

Line 280: end JTF_RS_SALESREPS_PKG;

276: end if;
277:
278: end DELETE_ROW;
279:
280: end JTF_RS_SALESREPS_PKG;