APPS.SY_REAS_CDS_PKG dependencies on SY_REAS_CDS_B

Line 20: cursor C is select ROWID from SY_REAS_CDS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from SY_REAS_CDS_B
21: where REASON_CODE = X_REASON_CODE
22: ;
23: begin
24: insert into SY_REAS_CDS_B (

Line 24: insert into SY_REAS_CDS_B (

20: cursor C is select ROWID from SY_REAS_CDS_B
21: where REASON_CODE = X_REASON_CODE
22: ;
23: begin
24: insert into SY_REAS_CDS_B (
25: REASON_CODE,
26: REASON_DESC2,
27: REASON_TYPE,
28: FLOW_TYPE,

Line 111: from SY_REAS_CDS_B

107: AUTH_STRING,
108: DELETE_MARK,
109: TEXT_CODE,
110: TRANS_CNT
111: from SY_REAS_CDS_B
112: where REASON_CODE = X_REASON_CODE
113: for update of REASON_CODE nowait;
114: recinfo c%rowtype;
115:

Line 179: update SY_REAS_CDS_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update SY_REAS_CDS_B set
180: REASON_DESC2 = X_REASON_DESC2,
181: REASON_TYPE = X_REASON_TYPE,
182: FLOW_TYPE = X_FLOW_TYPE,
183: AUTH_STRING = X_AUTH_STRING,

Line 223: update SY_REAS_CDS_B set delete_mark = 1

219: raise no_data_found;
220: end if;
221: ************************ */
222:
223: update SY_REAS_CDS_B set delete_mark = 1
224: where REASON_CODE = X_REASON_CODE;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 237: from SY_REAS_CDS_B B

233: begin
234: delete from SY_REAS_CDS_TL T
235: where not exists
236: (select NULL
237: from SY_REAS_CDS_B B
238: where B.REASON_CODE = T.REASON_CODE
239: );
240:
241: update SY_REAS_CDS_TL T set (