APPS.EDR_FWK_TEST_PKG dependencies on EDR_FWK_TEST_B

Line 48: cursor C is select ROWID from EDR_FWK_TEST_B

44: X_LAST_UPDATE_DATE in DATE,
45: X_LAST_UPDATED_BY in NUMBER,
46: X_LAST_UPDATE_LOGIN in NUMBER
47: ) is
48: cursor C is select ROWID from EDR_FWK_TEST_B
49: where FWK_TEST_ID = X_FWK_TEST_ID
50: ;
51: begin
52: insert into EDR_FWK_TEST_B (

Line 52: insert into EDR_FWK_TEST_B (

48: cursor C is select ROWID from EDR_FWK_TEST_B
49: where FWK_TEST_ID = X_FWK_TEST_ID
50: ;
51: begin
52: insert into EDR_FWK_TEST_B (
53: FWK_TEST_ID,
54: FWK_TEST_NO,
55: NUMBER_VALUE,
56: DATE_VALUE,

Line 251: from EDR_FWK_TEST_B

247: ATTRIBUTE28,
248: ATTRIBUTE29,
249: ATTRIBUTE30,
250: ATTRIBUTE_CATEGORY
251: from EDR_FWK_TEST_B
252: where FWK_TEST_ID = X_FWK_TEST_ID
253: for update of FWK_TEST_ID nowait;
254: recinfo c%rowtype;
255:

Line 407: update EDR_FWK_TEST_B set

403: X_LAST_UPDATED_BY in NUMBER,
404: X_LAST_UPDATE_LOGIN in NUMBER
405: ) is
406: begin
407: update EDR_FWK_TEST_B set
408: FWK_TEST_NO = X_FWK_TEST_NO,
409: NUMBER_VALUE = X_NUMBER_VALUE,
410: DATE_VALUE = X_DATE_VALUE,
411: STATUS = X_STATUS,

Line 477: delete from EDR_FWK_TEST_B

473: if (sql%notfound) then
474: raise no_data_found;
475: end if;
476:
477: delete from EDR_FWK_TEST_B
478: where FWK_TEST_ID = X_FWK_TEST_ID;
479:
480: if (sql%notfound) then
481: raise no_data_found;

Line 491: from EDR_FWK_TEST_B B

487: begin
488: delete from EDR_FWK_TEST_TL T
489: where not exists
490: (select NULL
491: from EDR_FWK_TEST_B B
492: where B.FWK_TEST_ID = T.FWK_TEST_ID
493: );
494:
495: update EDR_FWK_TEST_TL T set (