1159: FETCH chk_gnr INTO l_dummy;
1160: CLOSE chk_gnr;
1161:
1162: IF(l_dummy IS NOT NULL) THEN
1163: log('Start HZ_GNR_PUB.PROCESS_GNR call.');
1164: HZ_GNR_PUB.PROCESS_GNR(p_location_table_name => 'HZ_LOCATIONS',
1165: p_location_id => l_location_rec.location_id,
1166: p_call_type => 'U',
1167: x_return_status => x_return_status,
1160: CLOSE chk_gnr;
1161:
1162: IF(l_dummy IS NOT NULL) THEN
1163: log('Start HZ_GNR_PUB.PROCESS_GNR call.');
1164: HZ_GNR_PUB.PROCESS_GNR(p_location_table_name => 'HZ_LOCATIONS',
1165: p_location_id => l_location_rec.location_id,
1166: p_call_type => 'U',
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,
1166: p_call_type => 'U',
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data);
1170: log('End HZ_GNR_PUB.PROCESS_GNR call.');
1171: ELSE
1172: log('No need to call HZ_GNR_PUB.PROCESS_GNR.');
1173: END IF;
1174: /*
1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data);
1170: log('End HZ_GNR_PUB.PROCESS_GNR call.');
1171: ELSE
1172: log('No need to call HZ_GNR_PUB.PROCESS_GNR.');
1173: END IF;
1174: /*
1175: BEGIN
1176: SELECT 'Y'