[Home] [Help]
4111: PROCEDURE insert_text_dtl (x_return_status OUT NOCOPY VARCHAR2) IS
4112: BEGIN
4113: x_return_status := FND_API.G_RET_STS_SUCCESS;
4114:
4115: INSERT INTO gme_text_table_tl
4116: (text_code,
4117: lang_code,
4118: paragraph_code,
4119: sub_paracode,
4141: creation_date,
4142: last_update_login
4143: FROM pm_text_tbl_tl pm
4144: WHERE NOT EXISTS ( SELECT 1
4145: FROM gme_text_table_tl
4146: WHERE text_code = pm.text_code);
4147:
4148: insert_message (
4149: p_table_name => 'gme_text_table_tl/pm_text_tbl_tl',
4145: FROM gme_text_table_tl
4146: WHERE text_code = pm.text_code);
4147:
4148: insert_message (
4149: p_table_name => 'gme_text_table_tl/pm_text_tbl_tl',
4150: p_procedure_name => 'insert_text_dtl',
4151: p_parameters => 'none',
4152: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4153: p_error_type => 'P'
4152: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4153: p_error_type => 'P'
4154: );
4155:
4156: INSERT INTO gme_text_table_tl
4157: (text_code,
4158: lang_code,
4159: paragraph_code,
4160: sub_paracode,
4182: creation_date,
4183: last_update_login
4184: FROM pc_text_tbl_tl pc
4185: WHERE NOT EXISTS ( SELECT 1
4186: FROM gme_text_table_tl
4187: WHERE text_code = pc.text_code);
4188:
4189: insert_message (
4190: p_table_name => 'gme_text_table_tl/pc_text_tbl_tl',
4186: FROM gme_text_table_tl
4187: WHERE text_code = pc.text_code);
4188:
4189: insert_message (
4190: p_table_name => 'gme_text_table_tl/pc_text_tbl_tl',
4191: p_procedure_name => 'insert_text_dtl',
4192: p_parameters => 'none',
4193: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4194: p_error_type => 'P'
4196: EXCEPTION
4197: WHEN OTHERS THEN
4198: x_return_status := 'D';
4199: insert_message (
4200: p_table_name => 'GME_TEXT_TABLE_TL',
4201: p_procedure_name => 'INSERT_TEXT_DTL',
4202: p_parameters => '',
4203: p_message => SQLERRM,
4204: p_error_type => x_return_status