APPS.CSD_RT_TRAN_RESPS_PKG dependencies on CSD_RT_TRAN_RESPS

Line 1: package body CSD_RT_TRAN_RESPS_PKG as

1: package body CSD_RT_TRAN_RESPS_PKG as
2: /* $Header: csdtrtrb.pls 120.1 2005/07/29 16:36:09 vkjain noship $ */
3:
4: procedure INSERT_ROW (
5: -- P_ROWID in out nocopy VARCHAR2,

Line 19: cursor C is select ROWID from CSD_RT_TRAN_RESPS

15: ) is
16:
17: P_ROWID ROWID;
18:
19: cursor C is select ROWID from CSD_RT_TRAN_RESPS
20: where RT_TRAN_RESP_ID = PX_RT_TRAN_RESP_ID
21: ;
22:
23: begin

Line 25: select CSD_RT_TRAN_RESPS_S1.nextval

21: ;
22:
23: begin
24:
25: select CSD_RT_TRAN_RESPS_S1.nextval
26: into PX_RT_TRAN_RESP_ID
27: from dual;
28:
29: insert into CSD_RT_TRAN_RESPS (

Line 29: insert into CSD_RT_TRAN_RESPS (

25: select CSD_RT_TRAN_RESPS_S1.nextval
26: into PX_RT_TRAN_RESP_ID
27: from dual;
28:
29: insert into CSD_RT_TRAN_RESPS (
30: RT_TRAN_RESP_ID,
31: RT_TRAN_ID,
32: RESPONSIBILITY_ID,
33: OBJECT_VERSION_NUMBER,

Line 67: from CSD_RT_TRAN_RESPS

63: P_OBJECT_VERSION_NUMBER in NUMBER
64: ) is
65: cursor c is select
66: OBJECT_VERSION_NUMBER
67: from CSD_RT_TRAN_RESPS
68: where RT_TRAN_RESP_ID = P_RT_TRAN_RESP_ID
69: for update of RT_TRAN_RESP_ID nowait;
70: recinfo c%rowtype;
71:

Line 103: update CSD_RT_TRAN_RESPS set

99: P_LAST_UPDATED_BY in NUMBER,
100: P_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update CSD_RT_TRAN_RESPS set
104: RT_TRAN_ID = P_RT_TRAN_ID,
105: RESPONSIBILITY_ID = P_RESPONSIBILITY_ID,
106: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER + 1,
107: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 127: delete from CSD_RT_TRAN_RESPS

123: P_RT_TRAN_RESP_ID in NUMBER
124: ) is
125: begin
126:
127: delete from CSD_RT_TRAN_RESPS
128: where RT_TRAN_RESP_ID = P_RT_TRAN_RESP_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 135: end CSD_RT_TRAN_RESPS_PKG;

131: raise no_data_found;
132: end if;
133: end DELETE_ROW;
134:
135: end CSD_RT_TRAN_RESPS_PKG;