APPS.ITA_PARAMETER_HIERARCHY_PKG dependencies on ITA_PARAMETER_HIERARCHY

Line 1: package body ITA_PARAMETER_HIERARCHY_PKG as

1: package body ITA_PARAMETER_HIERARCHY_PKG as
2: /* $Header: itatovrb.pls 120.0 2005/08/17 17:38 anmalhot noship $ */
3:
4:
5: procedure INSERT_ROW (

Line 31: insert into ITA_PARAMETER_HIERARCHY(

27: from ita_setup_parameters_b
28: where parameter_code = x_override_parameter_code;
29:
30: if ((l_check_par_code =1) and (l_check_override_code = 1)) then
31: insert into ITA_PARAMETER_HIERARCHY(
32: parameter_code,
33: override_parameter_code,
34: override_level,
35: creation_date,

Line 69: from ITA_PARAMETER_HIERARCHY

65: x_last_update_login IN NUMBER
66: ) is
67: cursor c is select
68: override_level
69: from ITA_PARAMETER_HIERARCHY
70: where parameter_code = x_parameter_code
71: and override_parameter_code = x_override_parameter_code
72: for update of parameter_code,override_parameter_code nowait;
73: recinfo c%rowtype;

Line 108: update ita_parameter_hierarchy

104: x_last_update_login IN NUMBER
105: )
106: is
107: begin
108: update ita_parameter_hierarchy
109: set
110: override_level = x_override_level,
111: last_update_date = x_last_update_date,
112: last_updated_by = x_last_updated_by,

Line 128: delete from ITA_PARAMETER_HIERARCHY

124: x_parameter_code IN VARCHAR2,
125: x_override_parameter_code IN VARCHAR2
126: ) is
127: begin
128: delete from ITA_PARAMETER_HIERARCHY
129: where parameter_code = x_parameter_code
130: and override_parameter_code = x_override_parameter_code;
131:
132: if (sql%notfound) then

Line 160: from ITA_PARAMETER_HIERARCHY

156: -- Translate char last_update_date to date
157: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
158:
159: select last_updated_by, last_update_date into db_luby, db_ludate
160: from ITA_PARAMETER_HIERARCHY
161: where parameter_code = x_parameter_code
162: and override_parameter_code = x_override_parameter_code;
163:
164: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))

Line 165: then ITA_PARAMETER_HIERARCHY_PKG.UPDATE_ROW(

161: where parameter_code = x_parameter_code
162: and override_parameter_code = x_override_parameter_code;
163:
164: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
165: then ITA_PARAMETER_HIERARCHY_PKG.UPDATE_ROW(
166: x_parameter_code => x_parameter_code,
167: x_override_parameter_code => x_override_parameter_code,
168: x_override_level => x_override_level,
169: x_last_update_date => f_ludate,

Line 175: then ITA_PARAMETER_HIERARCHY_PKG.INSERT_ROW(

171: x_last_update_login => 0);
172: end if;
173:
174: exception when NO_DATA_FOUND
175: then ITA_PARAMETER_HIERARCHY_PKG.INSERT_ROW(
176: x_parameter_code => x_parameter_code,
177: x_override_parameter_code => x_override_parameter_code,
178: x_override_level => x_override_level,
179: x_creation_date => f_ludate,

Line 187: end ITA_PARAMETER_HIERARCHY_PKG;

183: x_last_update_login => 0);
184: end LOAD_ROW;
185:
186:
187: end ITA_PARAMETER_HIERARCHY_PKG;