DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_GNR_PUB

Line 1163: log('Start HZ_GNR_PUB.PROCESS_GNR call.');

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,

Line 1164: HZ_GNR_PUB.PROCESS_GNR(p_location_table_name => 'HZ_LOCATIONS',

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,

Line 1170: log('End HZ_GNR_PUB.PROCESS_GNR call.');

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: /*

Line 1172: log('No need to call HZ_GNR_PUB.PROCESS_GNR.');

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'