APPS.FEM_DB_LINKS_PKG dependencies on FEM_DB_LINKS_B

Line 17: cursor C is select ROWID from FEM_DB_LINKS_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 FEM_DB_LINKS_B
18: where DATABASE_LINK = X_DATABASE_LINK
19: ;
20: begin
21: insert into FEM_DB_LINKS_B (

Line 21: insert into FEM_DB_LINKS_B (

17: cursor C is select ROWID from FEM_DB_LINKS_B
18: where DATABASE_LINK = X_DATABASE_LINK
19: ;
20: begin
21: insert into FEM_DB_LINKS_B (
22: MIG_WF_OUT_AGENT_IN_LOCAL_DB,
23: DATABASE_LINK,
24: MIG_WF_IN_AGENT_IN_LINKED_DB,
25: OBJECT_VERSION_NUMBER,

Line 95: from FEM_DB_LINKS_B

91: cursor c is select
92: MIG_WF_OUT_AGENT_IN_LOCAL_DB,
93: MIG_WF_IN_AGENT_IN_LINKED_DB,
94: OBJECT_VERSION_NUMBER
95: from FEM_DB_LINKS_B
96: where DATABASE_LINK = X_DATABASE_LINK
97: for update of DATABASE_LINK nowait;
98: recinfo c%rowtype;
99:

Line 158: update FEM_DB_LINKS_B set

154: X_LAST_UPDATED_BY in NUMBER,
155: X_LAST_UPDATE_LOGIN in NUMBER
156: ) is
157: begin
158: update FEM_DB_LINKS_B set
159: MIG_WF_OUT_AGENT_IN_LOCAL_DB = X_MIG_WF_OUT_AGENT_IN_LOCAL_DB,
160: MIG_WF_IN_AGENT_IN_LINKED_DB = X_MIG_WF_IN_AGENT_IN_LINKED_DB,
161: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 197: delete from FEM_DB_LINKS_B

193: if (sql%notfound) then
194: raise no_data_found;
195: end if;
196:
197: delete from FEM_DB_LINKS_B
198: where DATABASE_LINK = X_DATABASE_LINK;
199:
200: if (sql%notfound) then
201: raise no_data_found;

Line 211: from FEM_DB_LINKS_B B

207: begin
208: delete from FEM_DB_LINKS_TL T
209: where not exists
210: (select NULL
211: from FEM_DB_LINKS_B B
212: where B.DATABASE_LINK = T.DATABASE_LINK
213: );
214:
215: update FEM_DB_LINKS_TL T set (