DBA Data[Home] [Help]

APPS.GMO_INSTR_TASK_ATTR_COLS_PKG dependencies on GMO_INSTR_TASK_ATTR_COLS_B

Line 16: cursor C is select ROWID from GMO_INSTR_TASK_ATTR_COLS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from GMO_INSTR_TASK_ATTR_COLS_B
17: where ATTR_COL_SEQ = X_ATTR_COL_SEQ
18: ;
19: begin
20: insert into GMO_INSTR_TASK_ATTR_COLS_B (

Line 20: insert into GMO_INSTR_TASK_ATTR_COLS_B (

16: cursor C is select ROWID from GMO_INSTR_TASK_ATTR_COLS_B
17: where ATTR_COL_SEQ = X_ATTR_COL_SEQ
18: ;
19: begin
20: insert into GMO_INSTR_TASK_ATTR_COLS_B (
21: TASK_NAME,
22: COLUMN_NO,
23: ATTR_COL_SEQ,
24: ENTITY_NAME,

Line 91: from GMO_INSTR_TASK_ATTR_COLS_B

87: cursor c is select
88: TASK_NAME,
89: COLUMN_NO,
90: ENTITY_NAME
91: from GMO_INSTR_TASK_ATTR_COLS_B
92: where ATTR_COL_SEQ = X_ATTR_COL_SEQ
93: for update of ATTR_COL_SEQ nowait;
94: recinfo c%rowtype;
95:

Line 147: update GMO_INSTR_TASK_ATTR_COLS_B set

143: X_LAST_UPDATED_BY in NUMBER,
144: X_LAST_UPDATE_LOGIN in NUMBER
145: ) is
146: begin
147: update GMO_INSTR_TASK_ATTR_COLS_B set
148: TASK_NAME = X_TASK_NAME,
149: COLUMN_NO = X_COLUMN_NO,
150: ENTITY_NAME = X_ENTITY_NAME,
151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 185: delete from GMO_INSTR_TASK_ATTR_COLS_B

181: if (sql%notfound) then
182: raise no_data_found;
183: end if;
184:
185: delete from GMO_INSTR_TASK_ATTR_COLS_B
186: where ATTR_COL_SEQ = X_ATTR_COL_SEQ;
187:
188: if (sql%notfound) then
189: raise no_data_found;

Line 199: from GMO_INSTR_TASK_ATTR_COLS_B B

195: begin
196: delete from GMO_INSTR_TASK_ATTR_COLS_TL T
197: where not exists
198: (select NULL
199: from GMO_INSTR_TASK_ATTR_COLS_B B
200: where B.ATTR_COL_SEQ = T.ATTR_COL_SEQ
201: );
202:
203: update GMO_INSTR_TASK_ATTR_COLS_TL T set (