APPS.CSD_RT_TRANS_PKG dependencies on CSD_RT_TRANS_B

Line 24: cursor C is select ROWID from CSD_RT_TRANS_B

20: ) is
21:
22: P_ROWID ROWID;
23:
24: cursor C is select ROWID from CSD_RT_TRANS_B
25: where RT_TRAN_ID = PX_RT_TRAN_ID
26: ;
27:
28: begin

Line 34: insert into CSD_RT_TRANS_B (

30: select CSD_RT_TRANS_S1.nextval
31: into PX_RT_TRAN_ID
32: from dual;
33:
34: insert into CSD_RT_TRANS_B (
35: FROM_REPAIR_TYPE_ID,
36: TO_REPAIR_TYPE_ID,
37: COMMON_FLOW_STATUS_ID,
38: REASON_REQUIRED_FLAG,

Line 108: from CSD_RT_TRANS_B

104: P_OBJECT_VERSION_NUMBER in NUMBER
105: ) is
106: cursor c is select
107: OBJECT_VERSION_NUMBER
108: from CSD_RT_TRANS_B
109: where RT_TRAN_ID = P_RT_TRAN_ID
110: for update of RT_TRAN_ID nowait;
111: recinfo c%rowtype;
112:

Line 164: update CSD_RT_TRANS_B set

160: P_LAST_UPDATED_BY in NUMBER,
161: P_LAST_UPDATE_LOGIN in NUMBER
162: ) is
163: begin
164: update CSD_RT_TRANS_B set
165: FROM_REPAIR_TYPE_ID = P_FROM_REPAIR_TYPE_ID,
166: TO_REPAIR_TYPE_ID = P_TO_REPAIR_TYPE_ID,
167: COMMON_FLOW_STATUS_ID = P_COMMON_FLOW_STATUS_ID,
168: REASON_REQUIRED_FLAG = P_REASON_REQUIRED_FLAG,

Line 207: delete from CSD_RT_TRANS_B

203: if (sql%notfound) then
204: raise no_data_found;
205: end if;
206:
207: delete from CSD_RT_TRANS_B
208: where RT_TRAN_ID = P_RT_TRAN_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 221: from CSD_RT_TRANS_B B

217: begin
218: delete from CSD_RT_TRANS_TL T
219: where not exists
220: (select NULL
221: from CSD_RT_TRANS_B B
222: where B.RT_TRAN_ID = T.RT_TRAN_ID
223: );
224:
225: update CSD_RT_TRANS_TL T set (