APPS.ZX_PARAMETERS_PKG dependencies on ZX_PARAMETERS_B

Line 26: CURSOR c IS SELECT rowid FROM zx_parameters_b

22: x_last_update_date IN DATE,
23: x_last_updated_by IN NUMBER,
24: x_last_update_login IN NUMBER
25: ) IS
26: CURSOR c IS SELECT rowid FROM zx_parameters_b
27: WHERE tax_parameter_code = x_tax_parameter_code;
28: prminfo c%ROWTYPE;
29: BEGIN
30: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 38: 'Insert into ZX_PARAMETERS_B (+)');

34: END IF;
35: IF (g_level_procedure >= g_current_runtime_level ) THEN
36: FND_LOG.STRING(g_level_procedure,
37: 'ZX_PARAMETERS_PKG.Insert_Row',
38: 'Insert into ZX_PARAMETERS_B (+)');
39: END IF;
40:
41: INSERT INTO zx_parameters_b (
42: tax_parameter_code,

Line 41: INSERT INTO zx_parameters_b (

37: 'ZX_PARAMETERS_PKG.Insert_Row',
38: 'Insert into ZX_PARAMETERS_B (+)');
39: END IF;
40:
41: INSERT INTO zx_parameters_b (
42: tax_parameter_code,
43: tax_parameter_type_code,
44: format_type_code,
45: max_size,

Line 111: 'Insert into ZX_PARAMETERS_B (-)');

107:
108: IF (g_level_procedure >= g_current_runtime_level ) THEN
109: FND_LOG.STRING(g_level_procedure,
110: 'ZX_PARAMETERS_PKG.Insert_Row',
111: 'Insert into ZX_PARAMETERS_B (-)');
112: END IF;
113: END INSERT_ROW;
114:
115:

Line 144: FROM zx_parameters_tl t, zx_parameters_b p

140:
141: BEGIN
142: SELECT decode (p.seeded_flag,'Y',1,0), t.last_update_date
143: INTO db_luby, db_ludate
144: FROM zx_parameters_tl t, zx_parameters_b p
145: WHERE t.tax_parameter_code = p.tax_parameter_code
146: AND t.tax_parameter_code = X_TAX_PARAMETER_CODE
147: AND t.language = userenv('LANG');
148:

Line 214: FROM zx_parameters_b

210:
211: BEGIN
212: SELECT decode (seeded_flag,'Y',1,0), last_update_date
213: INTO db_luby, db_ludate
214: FROM zx_parameters_b
215: WHERE tax_parameter_code = x_tax_parameter_code;
216:
217: -- Record should be updated only if :
218: -- a. file owner is CUSTOM and db owner is SEED

Line 222: UPDATE zx_parameters_b

218: -- a. file owner is CUSTOM and db owner is SEED
219: -- b. owners are the same, and file_date > db_date
220: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
221: db_ludate, x_custom_mode)) THEN
222: UPDATE zx_parameters_b
223: SET tax_parameter_type_code = x_tax_parameter_type,
224: format_type_code = x_format_type,
225: allow_override_flag = x_allow_override,
226: enabled_flag = x_enabled_flag,

Line 265: from ZX_PARAMETERS_B B

261: begin
262: delete from ZX_PARAMETERS_TL T
263: where not exists
264: (select NULL
265: from ZX_PARAMETERS_B B
266: where B.TAX_PARAMETER_CODE = T.TAX_PARAMETER_CODE
267: );
268:
269: update ZX_PARAMETERS_TL T set (