APPS.FWK_TBX_LOOKUP_CODES_PKG dependencies on FWK_TBX_LOOKUP_CODES_B

Line 17: cursor C is select ROWID from FWK_TBX_LOOKUP_CODES_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from FWK_TBX_LOOKUP_CODES_B
18: where LOOKUP_TYPE = X_LOOKUP_TYPE
19: and LOOKUP_CODE = X_LOOKUP_CODE
20: ;
21: begin

Line 22: insert into FWK_TBX_LOOKUP_CODES_B (

18: where LOOKUP_TYPE = X_LOOKUP_TYPE
19: and LOOKUP_CODE = X_LOOKUP_CODE
20: ;
21: begin
22: insert into FWK_TBX_LOOKUP_CODES_B (
23: LOOKUP_TYPE,
24: LOOKUP_CODE,
25: START_DATE_ACTIVE,
26: END_DATE_ACTIVE,

Line 98: from FWK_TBX_LOOKUP_CODES_B

94: ) is
95: cursor c is select
96: START_DATE_ACTIVE,
97: END_DATE_ACTIVE
98: from FWK_TBX_LOOKUP_CODES_B
99: where LOOKUP_TYPE = X_LOOKUP_TYPE
100: and LOOKUP_CODE = X_LOOKUP_CODE
101: for update of LOOKUP_TYPE nowait;
102: recinfo c%rowtype;

Line 161: update FWK_TBX_LOOKUP_CODES_B set

157: X_LAST_UPDATED_BY in NUMBER,
158: X_LAST_UPDATE_LOGIN in NUMBER
159: ) is
160: begin
161: update FWK_TBX_LOOKUP_CODES_B set
162: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
163: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from FWK_TBX_LOOKUP_CODES_B

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: delete from FWK_TBX_LOOKUP_CODES_B
204: where LOOKUP_TYPE = X_LOOKUP_TYPE
205: and LOOKUP_CODE = X_LOOKUP_CODE;
206:
207: if (sql%notfound) then

Line 218: from FWK_TBX_LOOKUP_CODES_B B

214: begin
215: delete from FWK_TBX_LOOKUP_CODES_TL T
216: where not exists
217: (select NULL
218: from FWK_TBX_LOOKUP_CODES_B B
219: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
220: and B.LOOKUP_CODE = T.LOOKUP_CODE
221: );
222: