[Home] [Help]
4042: PROCEDURE insert_text_header (x_return_status OUT NOCOPY VARCHAR2) IS
4043: BEGIN
4044: x_return_status := FND_API.G_RET_STS_SUCCESS;
4045:
4046: INSERT INTO gme_text_header
4047: (text_code,
4048: last_updated_by,
4049: created_by,
4050: last_update_date,
4058: creation_date,
4059: last_update_login
4060: FROM pm_text_hdr pm
4061: WHERE NOT EXISTS ( SELECT 1
4062: FROM gme_text_header
4063: WHERE text_code = pm.text_code);
4064:
4065: insert_message (
4066: p_table_name => 'gme_text_header/pm_text_hdr',
4062: FROM gme_text_header
4063: WHERE text_code = pm.text_code);
4064:
4065: insert_message (
4066: p_table_name => 'gme_text_header/pm_text_hdr',
4067: p_procedure_name => 'insert_text_header',
4068: p_parameters => 'none',
4069: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4070: p_error_type => 'P'
4069: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4070: p_error_type => 'P'
4071: );
4072:
4073: INSERT INTO gme_text_header
4074: (text_code,
4075: last_updated_by,
4076: created_by,
4077: last_update_date,
4085: creation_date,
4086: last_update_login
4087: FROM pc_text_hdr pc
4088: WHERE NOT EXISTS ( SELECT 1
4089: FROM gme_text_header
4090: WHERE text_code = pc.text_code);
4091:
4092: insert_message (
4093: p_table_name => 'gme_text_header/pc_text_hdr',
4089: FROM gme_text_header
4090: WHERE text_code = pc.text_code);
4091:
4092: insert_message (
4093: p_table_name => 'gme_text_header/pc_text_hdr',
4094: p_procedure_name => 'insert_text_header',
4095: p_parameters => 'none',
4096: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4097: p_error_type => 'P'
4099: EXCEPTION
4100: WHEN OTHERS THEN
4101: x_return_status := 'D';
4102: insert_message (
4103: p_table_name => 'GME_TEXT_HEADER',
4104: p_procedure_name => 'INSERT_TEXT_HEADER',
4105: p_parameters => '',
4106: p_message => SQLERRM,
4107: p_error_type => x_return_status