APPS.GMA_PROCCOL_WF_PKG dependencies on GMA_PROCCOL_WF_B

Line 19: cursor C is select ROWID from GMA_PROCCOL_WF_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from GMA_PROCCOL_WF_B
20: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
21: and PROCESS_NAME = X_PROCESS_NAME
22: and TABLE_NAME = X_TABLE_NAME
23: and COLUMN_NAME = X_COLUMN_NAME

Line 26: insert into GMA_PROCCOL_WF_B (

22: and TABLE_NAME = X_TABLE_NAME
23: and COLUMN_NAME = X_COLUMN_NAME
24: ;
25: begin
26: insert into GMA_PROCCOL_WF_B (
27: WF_ITEM_TYPE,
28: PROCESS_NAME,
29: COLUMN_HIERARCHY,
30: TABLE_NAME,

Line 116: from GMA_PROCCOL_WF_B

112: cursor c is select
113: COLUMN_HIERARCHY,
114: LOV_TABLE,
115: LOV_COLUMN
116: from GMA_PROCCOL_WF_B
117: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
118: and PROCESS_NAME = X_PROCESS_NAME
119: and TABLE_NAME = X_TABLE_NAME
120: and COLUMN_NAME = X_COLUMN_NAME

Line 182: update GMA_PROCCOL_WF_B set

178: X_LAST_UPDATED_BY in NUMBER,
179: X_LAST_UPDATE_LOGIN in NUMBER
180: ) is
181: begin
182: update GMA_PROCCOL_WF_B set
183: COLUMN_HIERARCHY = X_COLUMN_HIERARCHY,
184: LOV_TABLE = X_LOV_TABLE,
185: LOV_COLUMN = X_LOV_COLUMN,
186: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 232: delete from GMA_PROCCOL_WF_B

228: if (sql%notfound) then
229: raise no_data_found;
230: end if;
231:
232: delete from GMA_PROCCOL_WF_B
233: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
234: and PROCESS_NAME = X_PROCESS_NAME
235: and TABLE_NAME = X_TABLE_NAME
236: and COLUMN_NAME = X_COLUMN_NAME;

Line 249: from GMA_PROCCOL_WF_B B

245: begin
246: delete from GMA_PROCCOL_WF_TL T
247: where not exists
248: (select NULL
249: from GMA_PROCCOL_WF_B B
250: where B.WF_ITEM_TYPE = T.WF_ITEM_TYPE
251: and B.PROCESS_NAME = T.PROCESS_NAME
252: and B.TABLE_NAME = T.TABLE_NAME
253: and B.COLUMN_NAME = T.COLUMN_NAME

Line 362: l_wf_item_type gma_proccol_wf_b.wf_item_type%type;

358: X_LOV_COLUMN in VARCHAR2,
359: X_COLUMN_PROMPT in VARCHAR2,
360: X_OWNER in VARCHAR2
361: ) IS
362: l_wf_item_type gma_proccol_wf_b.wf_item_type%type;
363: l_process_name gma_proccol_wf_b.process_name%type;
364: l_user_id number:=0;
365: l_row_id VARCHAR2(64);
366: BEGIN

Line 363: l_process_name gma_proccol_wf_b.process_name%type;

359: X_COLUMN_PROMPT in VARCHAR2,
360: X_OWNER in VARCHAR2
361: ) IS
362: l_wf_item_type gma_proccol_wf_b.wf_item_type%type;
363: l_process_name gma_proccol_wf_b.process_name%type;
364: l_user_id number:=0;
365: l_row_id VARCHAR2(64);
366: BEGIN
367: IF (X_OWNER ='SEED') THEN

Line 372: FROM GMA_PROCCOL_WF_B

368: l_user_id :=1;
369: END IF;
370:
371: SELECT wf_item_type,process_name into l_wf_item_type,l_process_name
372: FROM GMA_PROCCOL_WF_B
373: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
374: and PROCESS_NAME = X_PROCESS_NAME
375: and TABLE_NAME = X_TABLE_NAME
376: and COLUMN_NAME = X_COLUMN_NAME;