APPS.IGC_CC_CONTROL_FUNCTIONS_PKG dependencies on IGC_CC_CONTROL_FUNCTIONS_ALL

Line 35: cursor c is select rowid from igc_cc_control_functions_all

31: X_ATTRIBUTE12 VARCHAR2,
32: X_ATTRIBUTE13 VARCHAR2,
33: X_ATTRIBUTE14 VARCHAR2,
34: X_ATTRIBUTE15 VARCHAR2 ) IS
35: cursor c is select rowid from igc_cc_control_functions_all
36: where control_function_id = x_control_function_id;
37: BEGIN
38: insert into igc_cc_control_functions_all (
39: CONTROL_FUNCTION_ID,

Line 38: insert into igc_cc_control_functions_all (

34: X_ATTRIBUTE15 VARCHAR2 ) IS
35: cursor c is select rowid from igc_cc_control_functions_all
36: where control_function_id = x_control_function_id;
37: BEGIN
38: insert into igc_cc_control_functions_all (
39: CONTROL_FUNCTION_ID,
40: CC_STATE,
41: CC_TYPE,
42: JOB_ID,

Line 144: update igc_cc_control_functions_all set

140: X_ATTRIBUTE13 VARCHAR2,
141: X_ATTRIBUTE14 VARCHAR2,
142: X_ATTRIBUTE15 VARCHAR2 ) IS
143: BEGIN
144: update igc_cc_control_functions_all set
145: CONTROL_FUNCTION_ID = X_CONTROL_FUNCTION_ID,
146: CC_STATE = X_CC_STATE,
147: CC_TYPE = X_CC_TYPE,
148: JOB_ID = X_JOB_ID,

Line 184: delete from igc_cc_control_functions_all

180: END UPDATE_ROW;
181:
182: PROCEDURE DELETE_ROW(x_rowid VARCHAR2) IS
183: BEGIN
184: delete from igc_cc_control_functions_all
185: where rowid = x_rowid;
186: if (SQL%NOTFOUND) then
187: raise no_data_found;
188: end if;

Line 223: CURSOR C is select * from igc_cc_control_functions_all

219: X_ATTRIBUTE12 VARCHAR2,
220: X_ATTRIBUTE13 VARCHAR2,
221: X_ATTRIBUTE14 VARCHAR2,
222: X_ATTRIBUTE15 VARCHAR2 ) IS
223: CURSOR C is select * from igc_cc_control_functions_all
224: where rowid = x_rowid
225: for update of control_function_id nowait;
226: recinfo c%rowtype;
227: BEGIN