APPS.CSD_FLWSTS_TRANS_PKG dependencies on CSD_FLWSTS_TRANS_B

Line 26: cursor C is select ROWID from CSD_FLWSTS_TRANS_B

22: ) is
23:
24: P_ROWID ROWID;
25:
26: cursor C is select ROWID from CSD_FLWSTS_TRANS_B
27: where FLWSTS_TRAN_ID = PX_FLWSTS_TRAN_ID
28: ;
29:
30: begin

Line 36: insert into CSD_FLWSTS_TRANS_B (

32: select CSD_FLWSTS_TRANS_S1.nextval
33: into PX_FLWSTS_TRAN_ID
34: from dual;
35:
36: insert into CSD_FLWSTS_TRANS_B (
37: REPAIR_TYPE_ID,
38: FROM_FLOW_STATUS_ID,
39: TO_FLOW_STATUS_ID,
40: WF_ITEM_TYPE,

Line 125: from CSD_FLWSTS_TRANS_B

121: */
122: ) is
123: cursor c is select
124: OBJECT_VERSION_NUMBER
125: from CSD_FLWSTS_TRANS_B
126: where FLWSTS_TRAN_ID = P_FLWSTS_TRAN_ID
127: for update of FLWSTS_TRAN_ID nowait;
128: recinfo c%rowtype;
129:

Line 183: update CSD_FLWSTS_TRANS_B set

179: P_LAST_UPDATED_BY in NUMBER,
180: P_LAST_UPDATE_LOGIN in NUMBER
181: ) is
182: begin
183: update CSD_FLWSTS_TRANS_B set
184: REPAIR_TYPE_ID = P_REPAIR_TYPE_ID,
185: FROM_FLOW_STATUS_ID = P_FROM_FLOW_STATUS_ID,
186: TO_FLOW_STATUS_ID = P_TO_FLOW_STATUS_ID,
187: WF_ITEM_TYPE = P_WF_ITEM_TYPE,

Line 228: delete from CSD_FLWSTS_TRANS_B

224: if (sql%notfound) then
225: raise no_data_found;
226: end if;
227:
228: delete from CSD_FLWSTS_TRANS_B
229: where FLWSTS_TRAN_ID = P_FLWSTS_TRAN_ID;
230:
231: if (sql%notfound) then
232: raise no_data_found;

Line 242: from CSD_FLWSTS_TRANS_B B

238: begin
239: delete from CSD_FLWSTS_TRANS_TL T
240: where not exists
241: (select NULL
242: from CSD_FLWSTS_TRANS_B B
243: where B.FLWSTS_TRAN_ID = T.FLWSTS_TRAN_ID
244: );
245:
246: update CSD_FLWSTS_TRANS_TL T set (