The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT PA.name
FROM vea_parameters PA,
vea_program_units PU,
vea_layer_headers LH
WHERE PA.parameter_id = p_tps_parameter_id
AND LH.layer_provider_code = p_layer_provider_code
AND LH.layer_header_id = p_layer_header_id
AND PU.program_unit_id = LH.tps_program_unit_id
AND PU.layer_provider_code = LH.tps_program_unit_lp_code
AND PA.program_unit_id = PU.program_unit_id
AND PA.layer_provider_code = PU.layer_provider_code;
UPDATE VEA_LAYERS
SET execution_sequence = g_layer_branch_tbl(l_curr_index).execution_sequence,
active_flag = nvl(g_layer_branch_tbl(l_curr_index).active_flag, active_flag)
WHERE layer_id = l_layer_id
AND layer_provider_code = g_layer_branch_tbl(l_curr_index).layer_provider_code;
UPDATE VEA_LAYERS
SET execution_sequence = g_layer_branch_tbl(l_curr_index).sequence_number
WHERE layer_id = l_layer_id
AND layer_provider_code = g_layer_branch_tbl(l_curr_index).layer_provider_code;
SELECT distinct PU.name program_unit_name,
PU.program_unit_id ,
PK.name package_name ,
PK.package_id ,
PK.layer_provider_code
FROM vea_program_units PU,
vea_packages PK,
vea_layer_headers LH,
vea_layers_v LV
WHERE PU.tps_flag = 'N'
AND PU.layer_provider_code = PK.layer_provider_code
AND PU.package_id = PK.package_id
AND PU.layer_provider_code = LH.program_unit_lp_code
AND PU.program_unit_id = LH.program_unit_id
AND LH.layer_provider_code = LV.layer_provider_code
AND LH.layer_header_id = LV.layer_header_id
AND LV.tp_layer_id = NVL(p_tp_layer_id, LV.tp_layer_id)
AND LV.layer_provider_code = p_layer_provider_code;
SELECT LA.sequence_number ,
LA.layer_provider_code,
LA.layer_id,
LA.layer_header_id,
LA.active_flag,
LA.tps_parameter1_id,
LA.tps_parameter1_value,
LA.tps_parameter2_id,
LA.tps_parameter2_value,
LA.tps_parameter3_id,
LA.tps_parameter3_value,
LA.tps_parameter4_id,
LA.tps_parameter4_value,
LA.tps_parameter5_id,
LA.tps_parameter5_value,
LA.tps_parameter6_id,
LA.tps_parameter6_value,
LA.tps_parameter7_id,
LA.tps_parameter7_value,
LA.tps_parameter8_id,
LA.tps_parameter8_value,
LA.tps_parameter9_id,
LA.tps_parameter9_value,
LA.tps_parameter10_id,
LA.tps_parameter10_value
FROM vea_layers LA,
vea_layer_headers LH,
vea_program_units PU,
vea_packages PK
WHERE PK.package_id = p_package_id
AND PK.layer_provider_code = p_layer_provider_code
AND PK.package_id = PU.package_id
AND PK.layer_provider_code = PU.layer_provider_code
AND PU.program_unit_id = p_program_unit_id
AND PU.layer_provider_code = LH.program_unit_lp_code
AND PU.program_unit_id = LH.program_unit_id
AND LH.layer_header_id = LA.layer_header_id
AND LH.layer_provider_code = LA.layer_provider_code
ORDER BY LA.layer_provider_code, LA.sequence_number;
g_layer_branch_tbl.DELETE;
SELECT count(distinct LA.layer_provider_code)
INTO l_lp_count
FROM vea_layers LA,
vea_layer_headers LH,
vea_program_units PU,
vea_packages PK
WHERE PK.package_id = l_package_id
AND PK.layer_provider_code = l_layer_provider_code
AND PK.package_id = PU.package_id
AND PK.layer_provider_code = PU.layer_provider_code
AND PU.program_unit_id = l_program_unit_id
AND PU.layer_provider_code = LH.program_unit_lp_code
AND PU.program_unit_id = LH.program_unit_id
AND LH.layer_header_id = LA.layer_header_id
AND LH.layer_provider_code = LA.layer_provider_code
ORDER BY LA.layer_provider_code;
SELECT LA.layer_provider_code,
LA.layer_id,
PU.name program_unit_name,
PK.name package_name
FROM vea_layer_headers LH,
vea_program_units TPA,
vea_packages PK,
vea_program_units PU,
vea_layers LA,
vea_layer_headers LH1
WHERE LH.layer_provider_code = p_layer_provider_code
AND LH.layer_header_id = p_layer_header_id
AND TPA.layer_provider_code = LH.program_unit_lp_code
AND TPA.program_unit_id = LH.program_unit_id
AND PU.layer_provider_code = TPA.layer_provider_code
AND PU.program_unit_id = TPA.tpa_program_unit_id
AND PK.layer_provider_code = PU.layer_provider_code
AND PK.package_id = PU.package_id
AND LH1.program_unit_id = TPA.program_unit_id
AND LH1.program_unit_lp_code = TPA.layer_provider_code
AND LA.layer_provider_code = LH1.layer_provider_code
AND LA.layer_header_id = LH1.layer_header_id
AND LA.sequence_number = p_sequence_number;
PROCEDURE NAME: insert_row
PURPOSE: Inserts a record into VEA_LAYERS table
========================================================================*/
PROCEDURE
insert_row
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_id IN vea_layers.layer_id%TYPE,
p_layer_header_id IN vea_layers.layer_header_id%TYPE,
p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
p_sequence_number IN vea_layers.sequence_number%TYPE,
p_description IN vea_layers.description%TYPE,
p_active_flag IN vea_layers.active_flag%TYPE,
p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
INSERT INTO vea_layers
(
layer_provider_code, layer_id,
layer_header_id,
new_program_unit_id, program_unit_lp_code,
sequence_number,
description,
active_flag,
tps_parameter1_id, tps_parameter1_value,
tps_parameter2_id, tps_parameter2_value,
tps_parameter3_id, tps_parameter3_value,
tps_parameter4_id, tps_parameter4_value,
tps_parameter5_id, tps_parameter5_value,
tps_parameter6_id, tps_parameter6_value,
tps_parameter7_id, tps_parameter7_value,
tps_parameter8_id, tps_parameter8_value,
tps_parameter9_id, tps_parameter9_value,
tps_parameter10_id, tps_parameter10_value,
created_by, creation_date,
last_updated_by, last_update_date,
last_update_login
)
VALUES
(
p_layer_provider_code, p_layer_id,
p_layer_header_id,
p_new_program_unit_id, p_program_unit_lp_code,
p_sequence_number,
p_description,
p_active_flag,
p_tps_parameter1_id, p_tps_parameter1_value,
p_tps_parameter2_id, p_tps_parameter2_value,
p_tps_parameter3_id, p_tps_parameter3_value,
p_tps_parameter4_id, p_tps_parameter4_value,
p_tps_parameter5_id, p_tps_parameter5_value,
p_tps_parameter6_id, p_tps_parameter6_value,
p_tps_parameter7_id, p_tps_parameter7_value,
p_tps_parameter8_id, p_tps_parameter8_value,
p_tps_parameter9_id, p_tps_parameter9_value,
p_tps_parameter10_id, p_tps_parameter10_value,
l_user_id, SYSDATE,
l_user_id, SYSDATE,
l_login_id
);
END insert_row;
PROCEDURE NAME: update_row
PURPOSE: Updates a record into VEA_LAYERS table
========================================================================*/
PROCEDURE
update_row
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_id IN vea_layers.layer_id%TYPE,
p_layer_header_id IN vea_layers.layer_header_id%TYPE,
p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
p_sequence_number IN vea_layers.sequence_number%TYPE,
p_description IN vea_layers.description%TYPE,
p_active_flag IN vea_layers.active_flag%TYPE,
p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
UPDATE vea_layers
SET new_program_unit_id = p_new_program_unit_id,
program_unit_lp_code = p_program_unit_lp_code,
layer_header_id = p_layer_header_id,
sequence_number = p_sequence_number,
description = p_description,
active_flag = p_active_flag,
tps_parameter1_id = p_tps_parameter1_id,
tps_parameter1_value = p_tps_parameter1_value,
tps_parameter2_id = p_tps_parameter2_id,
tps_parameter2_value = p_tps_parameter2_value,
tps_parameter3_id = p_tps_parameter3_id,
tps_parameter3_value = p_tps_parameter3_value,
tps_parameter4_id = p_tps_parameter4_id,
tps_parameter4_value = p_tps_parameter4_value,
tps_parameter5_id = p_tps_parameter5_id,
tps_parameter5_value = p_tps_parameter5_value,
tps_parameter6_id = p_tps_parameter6_id,
tps_parameter6_value = p_tps_parameter6_value,
tps_parameter7_id = p_tps_parameter7_id,
tps_parameter7_value = p_tps_parameter7_value,
tps_parameter8_id = p_tps_parameter8_id,
tps_parameter8_value = p_tps_parameter8_value,
tps_parameter9_id = p_tps_parameter9_id,
tps_parameter9_value = p_tps_parameter9_value,
tps_parameter10_id = p_tps_parameter10_id,
tps_parameter10_value = p_tps_parameter10_value,
last_updated_by = l_user_id,
last_update_date = SYSDATE,
last_update_login = l_login_id
WHERE layer_provider_code = p_layer_provider_code
AND layer_id = p_layer_id;
END update_row;
PROCEDURE NAME: delete_row
PURPOSE: Deletes the specified layer
========================================================================*/
PROCEDURE
delete_row
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_id IN vea_layers.layer_id%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
DELETE vea_layers
WHERE layer_provider_code = p_layer_provider_code
AND layer_id = p_layer_id;
END delete_row;
PROCEDURE NAME: delete_rows
PURPOSE: Deletes layers belonging to specified layer header and specified
TP layer.
========================================================================*/
PROCEDURE
delete_rows
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_header_id IN vea_layers.layer_header_id%TYPE,
p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
x_layer_count OUT NOCOPY NUMBER
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
SELECT layer_id, tp_layer_id
FROM vea_layers_v
WHERE layer_provider_code = p_layer_provider_code
AND layer_header_id = p_layer_header_id;
delete_row
(
p_layer_provider_code => p_layer_provider_code,
p_layer_id => layer_rec.layer_id
);
END delete_rows;
flat file record and updated back into the database.
========================================================================*/
PROCEDURE
populateLayerActiveTable
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'populateLayerActiveTable';
SELECT distinct
PU.program_unit_id,
PU.layer_provider_code,
LA.tp_layer_id,
LA.tp_layer_name,
LA.active_flag
FROM vea_layers_v LA,
vea_layer_headers LH,
vea_program_units PU
WHERE LA.layer_provider_code = p_layer_provider_code
AND LH.layer_provider_code = LA.layer_provider_code
AND LH.layer_header_id = LA.layer_header_id
AND PU.layer_provider_code = LH.program_unit_lp_code
AND PU.program_unit_id = LH.program_unit_id
order by tp_layer_id;
g_layer_active_tbl.DELETE;
SELECT TLA.tp_layer_id,
TLA.name tp_layer_name,
LH.program_unit_id,
LH.program_unit_lp_code
FROM vea_layer_headers LH,
vea_tp_layers TLA
WHERE LH.layer_provider_code = p_layer_provider_code
AND LH.layer_header_id = p_layer_header_id
AND TLA.layer_provider_code = p_layer_provider_code
AND TLA.tp_layer_id = p_tp_layer_id
order by TLA.tp_layer_id;
- inserts EDI code conversion category, if not existing.
- inserts/updates EDI code conversion value within the
category.
========================================================================*/
PROCEDURE
process_code_conversion
(
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_header_id IN vea_layers.layer_header_id%TYPE,
p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'process_code_conversion';
It inserts/updates a record in VEA_LAYERS table.
========================================================================*/
PROCEDURE
process
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_id OUT NOCOPY vea_layers.layer_id%TYPE,
p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
p_layer_header_id IN vea_layers.layer_header_id%TYPE,
p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
p_sequence_number IN vea_layers.sequence_number%TYPE,
p_description IN vea_layers.description%TYPE,
p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
p_id IN vea_layers.layer_id%TYPE := NULL,
p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
p_tp_layer_name IN vea_tp_layers.name%TYPE,
p_tps_parameter1_name IN vea_parameters.name%TYPE,
p_tps_parameter2_name IN vea_parameters.name%TYPE,
p_tps_parameter3_name IN vea_parameters.name%TYPE,
p_tps_parameter4_name IN vea_parameters.name%TYPE,
p_tps_parameter5_name IN vea_parameters.name%TYPE,
p_tps_parameter6_name IN vea_parameters.name%TYPE,
p_tps_parameter7_name IN vea_parameters.name%TYPE,
p_tps_parameter8_name IN vea_parameters.name%TYPE,
p_tps_parameter9_name IN vea_parameters.name%TYPE,
p_tps_parameter10_name IN vea_parameters.name%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'PROCESS';
SELECT LA.LAYER_ID LAYER_ID
FROM vea_layers LA,
VEA_TP_LAYERS TL,
VEA_PROGRAM_UNITS PU,
VEA_PACKAGES PK
WHERE TL.TP_LAYER_ID = p_tp_layer_id
AND TL.TP_LAYER_ID = PK.TP_LAYER_ID
AND TL.LAYER_PROVIDER_CODE = p_layer_provider_code
AND TL.LAYER_PROVIDER_CODE = PK.LAYER_PROVIDER_CODE
AND PK.PACKAGE_ID = PU.PACKAGE_ID
AND PK.LAYER_PROVIDER_CODE = PU.LAYER_PROVIDER_CODE
AND PU.PROGRAM_UNIT_ID = p_new_program_unit_id
AND PU.PROGRAM_UNIT_ID = LA.NEW_PROGRAM_UNIT_ID
AND PU.LAYER_PROVIDER_CODE = LA.PROGRAM_UNIT_LP_CODE;
SELECT layer_id
FROM vea_layers
WHERE layer_provider_code = p_layer_provider_code
AND layer_id = p_layer_id;
UPDATE vea_tp_layers
SET active_flag = 'Y'
WHERE layer_provider_code = p_layer_provider_code
AND tp_layer_id = l_tp_layer_id;
SELECT NVL( p_id, vea_layers_s.NEXTVAL )
INTO l_layer_id
FROM DUAL;
SELECT vea_layers_s.NEXTVAL
INTO l_layer_id
FROM DUAL;
insert_row
(
p_layer_provider_code => p_layer_provider_code,
p_layer_id => l_layer_id,
p_layer_header_id => l_layer_header_id,
p_new_program_unit_id => l_new_program_unit_id,
p_program_unit_lp_code => p_program_unit_lp_code,
p_sequence_number => p_sequence_number,
p_description => p_description,
p_active_flag => l_active_flag,
p_tps_parameter1_id => l_tps_parameter1_id,
p_tps_parameter1_value => p_tps_parameter1_value,
p_tps_parameter2_id => l_tps_parameter2_id,
p_tps_parameter2_value => p_tps_parameter2_value,
p_tps_parameter3_id => l_tps_parameter3_id,
p_tps_parameter3_value => p_tps_parameter3_value,
p_tps_parameter4_id => l_tps_parameter4_id,
p_tps_parameter4_value => p_tps_parameter4_value,
p_tps_parameter5_id => l_tps_parameter5_id,
p_tps_parameter5_value => p_tps_parameter5_value,
p_tps_parameter6_id => l_tps_parameter6_id,
p_tps_parameter6_value => p_tps_parameter6_value,
p_tps_parameter7_id => l_tps_parameter7_id,
p_tps_parameter7_value => p_tps_parameter7_value,
p_tps_parameter8_id => l_tps_parameter8_id,
p_tps_parameter8_value => p_tps_parameter8_value,
p_tps_parameter9_id => l_tps_parameter9_id,
p_tps_parameter9_value => p_tps_parameter9_value,
p_tps_parameter10_id => l_tps_parameter10_id,
p_tps_parameter10_value => p_tps_parameter10_value
);
update_row
(
p_layer_provider_code => p_layer_provider_code,
p_layer_id => l_layer_id,
p_layer_header_id => l_layer_header_id,
p_new_program_unit_id => l_new_program_unit_id,
p_program_unit_lp_code => p_program_unit_lp_code,
p_sequence_number => p_sequence_number,
p_description => p_description,
p_active_flag => l_active_flag,
p_tps_parameter1_id => l_tps_parameter1_id,
p_tps_parameter1_value => p_tps_parameter1_value,
p_tps_parameter2_id => l_tps_parameter2_id,
p_tps_parameter2_value => p_tps_parameter2_value,
p_tps_parameter3_id => l_tps_parameter3_id,
p_tps_parameter3_value => p_tps_parameter3_value,
p_tps_parameter4_id => l_tps_parameter4_id,
p_tps_parameter4_value => p_tps_parameter4_value,
p_tps_parameter5_id => l_tps_parameter5_id,
p_tps_parameter5_value => p_tps_parameter5_value,
p_tps_parameter6_id => l_tps_parameter6_id,
p_tps_parameter6_value => p_tps_parameter6_value,
p_tps_parameter7_id => l_tps_parameter7_id,
p_tps_parameter7_value => p_tps_parameter7_value,
p_tps_parameter8_id => l_tps_parameter8_id,
p_tps_parameter8_value => p_tps_parameter8_value,
p_tps_parameter9_id => l_tps_parameter9_id,
p_tps_parameter9_value => p_tps_parameter9_value,
p_tps_parameter10_id => l_tps_parameter10_id,
p_tps_parameter10_value => p_tps_parameter10_value
);