APPS.GMA_ACTCOL_WF_PKG dependencies on GMA_ACTCOL_WF_B

Line 18: cursor C is select ROWID from GMA_ACTCOL_WF_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from GMA_ACTCOL_WF_B
19: where ACTIVITY_ID = X_ACTIVITY_ID
20: and TABLE_NAME = X_TABLE_NAME
21: and COLUMN_NAME = X_COLUMN_NAME
22: ;

Line 24: insert into GMA_ACTCOL_WF_B (

20: and TABLE_NAME = X_TABLE_NAME
21: and COLUMN_NAME = X_COLUMN_NAME
22: ;
23: begin
24: insert into GMA_ACTCOL_WF_B (
25: ACTIVITY_ID,
26: COLUMN_HIERARCHY,
27: TABLE_NAME,
28: COLUMN_NAME,

Line 109: from GMA_ACTCOL_WF_B

105: cursor c is select
106: COLUMN_HIERARCHY,
107: LOV_TABLE,
108: LOV_COLUMN
109: from GMA_ACTCOL_WF_B
110: where ACTIVITY_ID = X_ACTIVITY_ID
111: and TABLE_NAME = X_TABLE_NAME
112: and COLUMN_NAME = X_COLUMN_NAME
113: for update of ACTIVITY_ID nowait;

Line 172: update GMA_ACTCOL_WF_B set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update GMA_ACTCOL_WF_B set
173: COLUMN_HIERARCHY = X_COLUMN_HIERARCHY,
174: LOV_TABLE = X_LOV_TABLE,
175: LOV_COLUMN = X_LOV_COLUMN,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 218: delete from GMA_ACTCOL_WF_B

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: delete from GMA_ACTCOL_WF_B
219: where ACTIVITY_ID = X_ACTIVITY_ID
220: and TABLE_NAME = X_TABLE_NAME
221: and COLUMN_NAME = X_COLUMN_NAME;
222:

Line 234: from GMA_ACTCOL_WF_B B

230: begin
231: delete from GMA_ACTCOL_WF_TL T
232: where not exists
233: (select NULL
234: from GMA_ACTCOL_WF_B B
235: where B.ACTIVITY_ID = T.ACTIVITY_ID
236: and B.TABLE_NAME = T.TABLE_NAME
237: and B.COLUMN_NAME = T.COLUMN_NAME
238: );

Line 345: FROM GMA_ACTCOL_WF_B

341: l_user_id :=1;
342: END IF;
343:
344: SELECT activity_id into l_activity_id
345: FROM GMA_ACTCOL_WF_B
346: WHERE ACTIVITY_ID = X_ACTIVITY_ID
347: and TABLE_NAME = X_TABLE_NAME
348: and COLUMN_NAME = X_COLUMN_NAME;
349: