APPS.AR_STANDARD_TEXT_PKG dependencies on AR_STANDARD_TEXT_B

Line 34: cursor C is select ROWID from AR_STANDARD_TEXT_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from AR_STANDARD_TEXT_B
35: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID
36: ;
37: begin
38: insert into AR_STANDARD_TEXT_B (

Line 38: insert into AR_STANDARD_TEXT_B (

34: cursor C is select ROWID from AR_STANDARD_TEXT_B
35: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID
36: ;
37: begin
38: insert into AR_STANDARD_TEXT_B (
39: STANDARD_TEXT_ID,
40: START_DATE,
41: END_DATE,
42: NAME,

Line 181: from AR_STANDARD_TEXT_B

177: ATTRIBUTE12,
178: ATTRIBUTE13,
179: ATTRIBUTE14,
180: ATTRIBUTE15
181: from AR_STANDARD_TEXT_B
182: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID
183: for update of STANDARD_TEXT_ID nowait;
184: recinfo c%rowtype;
185:

Line 293: update AR_STANDARD_TEXT_B set

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER
291: ) is
292: begin
293: update AR_STANDARD_TEXT_B set
294: START_DATE = X_START_DATE,
295: END_DATE = X_END_DATE,
296: NAME = X_NAME,
297: TEXT_TYPE = X_TEXT_TYPE,

Line 349: delete from AR_STANDARD_TEXT_B

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: delete from AR_STANDARD_TEXT_B
350: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 363: from AR_STANDARD_TEXT_B B

359: begin
360: delete from AR_STANDARD_TEXT_TL T
361: where not exists
362: (select NULL
363: from AR_STANDARD_TEXT_B B
364: where B.STANDARD_TEXT_ID = T.STANDARD_TEXT_ID
365: );
366:
367: update AR_STANDARD_TEXT_TL T set (