APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_EXTRACTS_B

Line 21: cursor C is select ROWID from IBY_EXTRACTS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from IBY_EXTRACTS_B
22: where EXTRACT_ID = X_EXTRACT_ID
23: ;
24: begin
25: insert into IBY_EXTRACTS_B (

Line 25: insert into IBY_EXTRACTS_B (

21: cursor C is select ROWID from IBY_EXTRACTS_B
22: where EXTRACT_ID = X_EXTRACT_ID
23: ;
24: begin
25: insert into IBY_EXTRACTS_B (
26: DATASOURCE_CODE,
27: GEN_CODE_LANGUAGE,
28: GEN_CODE_PACKAGE,
29: GEN_CODE_ENTRY_POINT,

Line 110: update IBY_EXTRACTS_B set

106: X_LAST_UPDATED_BY in NUMBER,
107: X_LAST_UPDATE_LOGIN in NUMBER
108: ) is
109: begin
110: update IBY_EXTRACTS_B set
111: DATASOURCE_CODE = X_DATASOURCE_CODE,
112: GEN_CODE_LANGUAGE = X_GEN_CODE_LANGUAGE,
113: GEN_CODE_PACKAGE = X_GEN_CODE_PACKAGE,
114: GEN_CODE_ENTRY_POINT = X_GEN_CODE_ENTRY_POINT,

Line 152: delete from IBY_EXTRACTS_B

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: delete from IBY_EXTRACTS_B
153: where EXTRACT_ID = X_EXTRACT_ID;
154:
155: if (sql%notfound) then
156: raise no_data_found;

Line 166: from IBY_EXTRACTS_B B

162: begin
163: delete from IBY_EXTRACTS_TL T
164: where not exists
165: (select NULL
166: from IBY_EXTRACTS_B B
167: where B.EXTRACT_ID = T.EXTRACT_ID
168: );
169:
170: update IBY_EXTRACTS_TL T set (